How would i go about seting up a local database to store data so it can be used offline then to sync up with SQL server 2008 r2. i've got to the point of having a test project with a local DB that stores the data and a test SQL server but know idea how to set it up to sync with between databases.
View 2 Replies
Scenario: I want to develop an application.The application should be able to connect to my remote server and download data to the local disk , while downloading it should check for new files and only download the new ones simultaneously creating the required(new) folders.
Problem: I have no idea how to compare the files in the server with the ones in the local disk.How to download only the new files from the server to the local disk?
What am thinking?: I want to sync the files in the local machine with the ones in the server. I am planning to use rsync for syncing but i have no idea how to use it with ASP.NET.
I'm posting this in the vb.net as I will be using visual studio to perform the task. So here is what I am trying to achieve or at least achieve it more efficiently than what I am doing now.
So I have two identical database setups, both with a table , let call it table tblUsers. The local database is edited through vb.net and is a Access database. The second database is hosted on a remote server and is a MySQL databse.
Currently I have no problem connecting and editing either database through vb.net. I'm using OLE DB to connect and handle the Access database and ODBC 5.1 to connect and handle the MySQL database.
Here is what I would like to do:
User opens the program Presses the "update local" button
The program updates the local database to whatever the remote database is The user uses the program to edit fields in the local database
When done, the user presses the "Update remote" button and the remote database fields that have been edited with the program in the local database will be updated to the remote database.
Currently, the only way for me to do this is to go line by line in a for next and use a command builder to compare each field and update that way.
I have no idea at all of how to get a simple True/False function to tell me if the user has any sort of internet connection
View 14 RepliesHow can I check through my application if computer is connected with internet or not (at the moment)I need a message if net is connected.
View 3 RepliesBasically I want to have a picturebox which shows an embedded resource if not connected to the internet, and an online image if connected to the internet.I assume this can be done on the form load event, I just don't know the code for it. Basically this is the logic though:
-If 'http:/[url].... is available (therefore connected to internet)
-Picturebox1.Image = http:[url].....
-Else[code].....
How can I code that properly? Would putting it in the form load event work?
How to check if connected to the internet instantly?
It must support proxi and windows xp,too.
WebBrowser1.Navigate("www.google.com"), it doesn't load. It opens the same webpage you get when you try to navigate to a page and you're not connected to the internet. Also, I opened a webpage that was saved on my computer, and that webpage had a link to a website on the internet, and when I clicked on it, it worked just fine! It's not my internet, what is it then? Here's the snippet of my code:
[Code]...
I have a WebBrowser control on one of my forms to provide information to users when they use my program. If the user is connected to the Internet it works fine.But if they are not connected to the internet, it shows the Internet Explorer message saying that there are connection problems.
View 5 RepliesIs there anyway that i can get a program to disconnect the user from there internet that they are currently connected to?
View 21 RepliesI have written a code for sending emails using my vb.net application,ok.Now i want to inform my client if and only if he is not connected to the internet before the sending emails.so it means the purpose of my code will be to check if he is online or nt and if not then inform him to get online and then try sending the email.How to do this?
View 5 RepliesHere is my Prob- we have a main router from which we use a distributor or hub for internet connection distribution, ever computer connected automatically obtains IP address of format say - 180.50.50.xxx to access net connection.if any connected computer has different IP format than the given one, it cannot access internet.
View 1 RepliesUsing the code below i will get all network interfaces wich are enabled and functional on the machine.
Private netIntrfc As NetworkInterface() = NetworkInterface.GetAllNetworkInterfaces()
For i As Integer = 0 To netIntrfc.Length - 1
If netIntrfc(i).OperationalStatus = OperationalStatus.Up Then
[code]....
But my problem is how to get the default one, the one(ethernet adapter) through wich user is connected to internet?I need to change some settings of default(through wich user is connected to internet) adapter. settings i change through registry so i could sample add same settings for each network interface but that could cause problems and makes no point then?
EDITED:for now i have done like code below, so if this can help someone other...
Dim u As UdpClient = New UdpClient(System.Net.Dns.GetHostName, 1)
Dim localAddr As IPAddress = CType(u.Client.LocalEndPoint, IPEndPoint).Address
Private netIntrfc As NetworkInterface() = NetworkInterface.GetAllNetworkInterfaces()
[code]....
I want to write a program that if ping www.microsoft.com is success,than caption title it's "ok,connected Internet",if ping it's failed,the program "caption" title is "sorry,not connected",but I don't know how to write those code
View 10 RepliesI'm interested in how to open Internet Explorer from Visual BasicAlready, I have this:WebBrowser1.Navigate(TextBox1.Text)And this open Internet Explorer, but I want that Internet Explorer open site with address from TextBox in VB
View 2 Repliesi need to check if my Computer is connected with an Active Directory Domain or only in a Workgroup. Is this possible?
View 4 RepliesI have a new requirement to sync a DVR to an NTP server, but not sure how. I have googled and forum searched, but a lot is VB6 stuff and also for sync'ing a local computer's time. This requirement is for sync'ing time for a Digital Video Recorder on the network.
View 10 RepliesWell guyz its been a long time since my last post here but i got some troubles with a new project i am on and the members of vbforums always had the solution So as the title says i want to make a launcher that will sync 2 folders and some files from my Website to my local HDD. Something like that with Api s
[Code]....
I have to create a block of code that detects the Local IP address of connected adapter and returns it as string to a TextBox.
View 7 RepliesI was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database.
View 5 RepliesI have a client that has the basic database on a server(sql server 2005 express database) and wants to work on his laptop from his home, so i guess that i can install the software on his laptop but how will the 2 databases be synchronized, having same data. the synchronization will be made once a day in the morning when he returns to his office. How can this be accomplished?
View 2 Repliesi am trying to figure out the vb code to convert user input from a windows application and use them in the internet connection wizard to automatically setup up a dial up internet connection in XP. i've got the interface designed, i just can't find any of the vb commands to access the wizard or perform the function of the wizard
View 3 Repliesa small question: what is the difference between sync and async connections in a tcp/ip client/server application?
View 1 RepliesI want to filter the SQL Compact Database to get rows that as been synchronized to the SQL SEVER Using sync framework can any one give me an hint on how to get this done. I will prefer a sample code in VB.NET
View 1 RepliesI have set paths in my program to look for files in the "c:/Documents and Settings/User/ Local Settings/Application Data/".How do I add the "Documents and Settings/User/Local Settings/Application Data/" folder in the setup program? Everyone tells me to use the Local Settings path for my application data but I can't add this folder in the File System Editor. I have read many different help files concerning special folders but none of them explain how to add the local application data folder.
View 1 RepliesQuestion for all of the more experienced programmers out there. I am working on a program with a tab control. One tab will hold a webbrowser control within it. What I am trying to accomplish to have it pull a specific url from my website to the webbrowser control if the person is connected to the internet, BUT if they don't have a internet connection at the time, I would like to display a local html file instead
View 4 RepliesWe are working on a media center plugin to show internet tv from a local provider. They are distributing their metadata as this link[URL]..It seems to be an xml list of rss feeds, because if I open the links in internet explorer, I get a nice html page.
My task in this project, is to write an aggregator that read the xml feeds, convert this into collections of metadata objects, that will be used to build the menu in media center. These will be simple List of... objects with categories, synopsis etc.
What is the best way in .NET to make this happen. It isn't even pure xml but rss feeds and I have never worked wit this. Can I benefit from technologies like xsd schemas, LINQ etc to make my job easier?
How I make SetUp for program in vb.net with local database(data base which include in visual studio.net 2008) to make it work in other computers which not have the visual studio 2008?
View 7 RepliesI am attempting to call a remote modem using a local modem connected via USB. Programming language is VB.NET and I am using the SerialPort control to talk to the modem.
Communication is as follows:
I send: ATZ0[CR]
Modem responds: ATZ0[CR][CR][LF]OK[CR][LF]
I then try to dial a number:
I send: ATDTnnnnnnnnnn[CR] where nnnnnnnnnn is a valid number
The modem responds with:ATDTnnnnnnnnnn[CR][CR][LF]ERROR[CR][LF]
All other commands seem to work without any issues
For info the modem is a MultiTech MT5634ZBA-USB-V92
If I use hyperterminal and type the same commands in it works as expected and dials the number, so it must be something I am doing in my code, possible some setup in the SerialPort control
My first post here in vb forums. I'm new to sockets programming since I migrated from Winsock and I learn a lot from Atheist. using his code, I can't access the messageReceived() every time a client sends a message on the server. but then I put a code to catch the message on sub doRead() and I can retrieve the message. My problem now is how can I determine if a client is still connected to the server or not so I can delete it on the ConnectedClient ?
[Code]...
Note: the server runs on Win7 x64 ultimate and the clients are laptops on win7 x86. I read a comment that the server should be having a static IP address, but when did it together with the clients, It still doesn't work. I am just using a switch for the network.
