Syncing Database Client Server In VB 2010?
Mar 24, 2012
I'm creating a VB2010 application which will require a connection to MSSQL. Should I Install SQL 2008 on my computer then use MS SQL 2008 as my data source or skip installing SQL 2008 and use MDF instead?
Also the program must have the following requirement
Program must use SQL as their database source End user must not install SQL server on their machine Program must be able to update (sync) the local SQL database from SQL server on the web. (User will have option to delete everything on their local database and load everything fresh from the server or to merge the update with existing data) Programs will (most of the time) run in an offline environment. When the user have access to internet they can update the database The program must allow user to add,edit, delete their local database while offline Only certain user (authorized user) can update their local database back to the serverC
Is it possible to created a program that meets all the above requirement ?
View 1 Replies
ADVERTISEMENT
Jun 27, 2011
Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
View 4 Replies
May 9, 2009
how to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
View 9 Replies
Jun 8, 2010
Im a beginner at vb.net, and just wanna ask if it is possible to make a vb.net app/client app that can connect to a database on an online web server???The app is locally on the client computer and the database is uploaded on the web server/host together with its website.
View 4 Replies
Jun 21, 2010
We are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
[Code]...
View 2 Replies
Jul 13, 2009
For example, i installed the windows application in more than one pc. All the pc's are in network. I want to save the data in a single database. How it is possible?
View 7 Replies
Dec 10, 2011
I would like to create a server program that accesses an "ms access" database. I will also need a client program that connects to the server. The reason for this is that the server is a mediator for several clients. Since I am using access, I plan on maybe having 20 or 30 clients connect to the server only. The client will have access to a virtual market. So when a person buys or sells something on the market, the server mediates the transaction and etc. At the same time, the access database saves each clients data as well as the overall market data.
View 1 Replies
Jan 14, 2011
I'm working for a socket tcp/ip. I have a server form on Server PC and client forms on all clients. I want the clients auto find and connect to the server PC when I open connection on server form? (in common, I have to set the server IP and ports to each clients, if not they cannot connect).
View 3 Replies
Nov 15, 2011
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
View 1 Replies
Feb 24, 2008
I wrote a program in VB2005. It is a program that is supposed to run in a client computer accessing an MS Access .mdb file stored in the server. The program itself is stored and run in the clients computer. I am not good in networking at all. The way I do it now is:
1. Have a directory made in the server to hold the MS Access .mdb file, and have the directory to be shared.
2. Have the same directory accessed and mapped in the client computer (say to Z:)
3. Then have the program in the client computer simply access the database as if it is in the same computer (as the directory already mapped into the client computer). In the VB 2005, this is done when we set the connection string of the database connection.
However, my user is complaining that by doing so, the database is basically exposed to the operator of the client computer (through the mapped directory), hence more vunerable for any bad intentions from persons who may have access to the client computer but not the server. He insists that he used to have a program that does exactly the same thing like my program, but the database is shielded in the server, where it cannot be seen in the client computer (I have other people who confirm that this can be done, though they can't tell me how, since they are not programmers themselves). Now, I have no idea on how to connect a database that way, and I don't even know where to start looking.
View 1 Replies
Nov 20, 2011
I'm developing a project.
I wanted to connect client software to sql server 2008 database and server for now is Windows 7.
I created an account Named Test with pass=1 on the windows 7 (server) and it's admin account
My Connection string on the client is this:
server=ip of server;database=dbName;uid=Test;pwd=1;
1-Is it neccessary to install sql server on the client?
2-When I want to connect it says: Login failed for the user Test.
View 5 Replies
Jul 23, 2008
The problem I have is: When I click on cmdListen in the server form and cmdConnect in the client form,both programs won't respond and they crash for some reason I don't know.
Client source code:
Code:
Imports System.Net.Sockets
Imports System.Text
Public Class Form1
[CODE]...
Code:
Imports System.Net.Sockets
Imports System.Text
Public Class Form1
[CODE]...
View 3 Replies
Nov 4, 2010
I just finished making my project, its a Registration System using Visual Basic 2010.
How can I make a server that allows client to open the system? so they can Add, Edit, Delete, Save, etc...
P.S. I try file sharing but it doesn't work. using win7 to winXP.
View 3 Replies
Jun 15, 2010
I am currently learning how to program in VB and am using sample code to make a VB Winsock client and server. I beleive the sample code was from VB 6.0. [code]Overload resolution failed because no accessible 'GetData' accepts this number of arguments.I am getting the exact same error in the exact same place in the server aswell. I have tried removing the vbString, but it comes up with a warning and the program doesn't function like it should. I am programming this in Visual Basic 2010 Express.
View 3 Replies
May 12, 2011
I'm doing a small project. It works on a LAN. The working of the project is:In client side, a user would enters "username" and "password". It would sent that to the server, along with the time.The server would authenticates info on checking a db and writes some info to the db.Also, the server should be able to sent some commands or instructions to the clients.These commands on received by the client, it would invoke certain functions/subs on the client based on the command.So, would it be better to use TCP client & listener or WCF ?
View 6 Replies
Jul 19, 2011
I have started to learn how to use the TcpListener class to create a server/client chat facility, But im having some issues as to how to perform this at the moment i have the following code for the server.
Dim counter As Integer
serverSocket.Start()
ListBox1.Items.Add("Server Started!")
counter = 0
While (True)
[Code]...
Client Accepted (I understand would most likely need a new thread for each client who is accepted, Once accepted , Return to the main loop to check for more clients.) No Client Connecting I understand that this may have to be done in a thread but ive not looked into using a seperate thread for this to infinitely run.
View 1 Replies
Nov 2, 2011
We would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 Replies
Jul 19, 2011
I'm trying to make a client and a server connected in vb 2010. how to make a client and server connected? There is only vb2008 in the codebank and if my vb2010 tries to convert it to vb 2010 it will error.
View 1 Replies
Apr 19, 2012
I have a simple client/server program that sends a message to the server from the client.
Here is my
Server
Imports System.Net, System.Net.Sockets
Public Class Server
[Code].....
View 5 Replies
Nov 8, 2011
I'm developing a Windows application that runs on a terminal server and users connect to it via remote desktop. Standard stuff. However, I would like to know something about the user and I was wondering if there's a way to get some information about the client that the user connects from (his local machine).
View 1 Replies
Apr 1, 2010
I have an exe file that I have copied to test workstations and would like to launch that application instantly when needed from a dedicated server. I could do an agent based (timer) application where client application checks every 2 minutes (or so) for a file on server, it there file is modifoed then it launchs the GUI app on the workstation.
I really want an agentless approach and have tried PSexec and MS SCCEM agent but it still takes 3-4 seconds to launch on each machine one after another. If we are talking about thousands of machines in my environment there could be delay of more than an hour to launch app on each machine.
I was wondering if socket programming is the best approach where instead of a timer; app listens to a port and when it sees it it launches local exe file. I am new to socket TCP/IP programming.
View 2 Replies
May 24, 2012
I'm trying to make a Client that will automatically run a .DLL that I have created and send information over port 80 to my Server program that will take that data and import it into a database for me. Problem is, I don't know where to start as I have never done this before. I want to do this in VB .NET as this is the programming language that I know. What are methods of doing this? Is there sample code out there for something like this? My google searches are failing me.
A better layout of what I'm trying to do:1. Client Runs .DLL, retrieving information from an Excel file.2. Client takes these properties with the data it contains and sends it to a program outside of the local network through port 80, my boss refuses to let me use any other port.3. Server accepts the data and builds its own properties to be imported into my Access Database.4. Repeat over, and over, and over, and over.
I plan for the server application to be a console application, and the client to be a windows form.
View 1 Replies
Mar 11, 2012
I created a dll for my host and client, but but does not work! where's the error?
[Code]....
View 4 Replies
May 30, 2011
I'm breaking my head over the next problem. I have 2 applications (client/terminal). the client reads out the webcam and generates an image. This image needs to be send to the terminal which can accept multiple clients. At the terminal all received images are placed in an ordered panel. The purpose of this application is to monitor multiple webcams.What i can't get to work is how to send it on the client side and receive on the terminal side.
[Code]...
View 21 Replies
Feb 21, 2012
I want to make my client & server fully working. If a client connects to the server it should tell that there is a new client connected. if a client disconnects it should tell me a client disconnected.[code]it says in my patcher window(where it should add the text) that it's succesfully connected.but at the server side its not saying there is a new client connected/disconnected, how can I do this?
View 2 Replies
Apr 23, 2010
I'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
View 3 Replies
Oct 29, 2009
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 Replies
Jan 6, 2011
Im trying to make a basic Client/Server. The server can handle multiple clients and each client can send /recieve messages from the server.It works fine with just 1 client. but as soon as i connect with a second client. The first one no longer works. Anything sent from the first client is ignored by the server and when running the server in debug mode it gets errors from the client 1 stream.
Its as if the server will only hold one stream at a time and whenever another client joins the other streams are shut but the new client works fine. Even though i never close a stream.
[Code]...
Edit: FINALLY FOUND IT! Stupid mistake i forgot to put the ClientN variable up by one for each new client.So i was creating a new space in the array but erasing the first slot for the new client
View 2 Replies
Dec 3, 2011
I have a simple tcp server listening for clients. I use a mud client to test if it's working. The mud client says that it's connected to 127.0.0.1, but the server doesn't show the msgbox that a client has connected.[code]
View 3 Replies
Jun 24, 2010
I am working on a chat client and server, and so far it works well, but when I close the client, the server throws an exception because it continues to try to do processes on the disconnected client. I have tried adding clientSocket.Close() in various places throughout the client and server with no luck. Does someone know how to add the disconnect code to either the server or client with this code?Server:
Imports System.Net.Sockets
Imports System.Text
Module Module1
[code].....
View 5 Replies
