Onnect Client Software To Sql Server 2008 Database?
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
ADVERTISEMENT
Oct 6, 2011
is there any method or function or anything else to connect database without installing sql server in vb.net (Client side)!
View 8 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
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
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
Aug 18, 2009
Im using the code from [URL] as a starter, most of the code is the same. the chat system works fine but on the client a added a disconnect button "clientSocket.Close()" and as soon as i click that i get errors, on the client, this is the code...
Private Sub getMessage()
For infiniteCounter = 1 To 2
[CODE]...
And this line...
serverStream.Read(inStream, 0, buffSize)
gives me "Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."
Now im talking the server, after the client clicks disconnect or closes by task manager, looses connection, etc the server crashes and gives me.
View 5 Replies
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
Aug 10, 2009
Multi-User Chat Program (Server & Client) with Main Server?
View 1 Replies
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 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
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
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
Jul 15, 2009
i have been working on a chat program Server side and client side i have most of the features i was asked to put in but then once i got most of the bugs out i noticed something the server admin could send whispers and alerts to single users but then when you try do do it on the client side it wont work so i looked through it all and found my issue the user list on the client is only a list of the names in server hash table so i was wondering how do i send the hashtable and all of its data E.G. user connection information to the client so that it can send commands to individual users like the server side can
vb
Public clients As New Hashtable()
' This subroutine checks to see if username already exists in the clients
' Hashtable. If it does, send a REFUSE message, otherwise confirm with a JOIN.
[code]....
i tried to send the hashtable over the same method used to send the user names to the client but it cannot convert the hashtable to a string so that wont work so my question is How do i send the hash table to the user from the server then display the username on the client ??
View 39 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 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
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
Mar 30, 2009
I've basically made a basic tcp server/client application. The thing is that I'm behind a router and so will be the other people that use my clients. I've had to use port-forwarding or the software "rinetd"to run quite a few applications online.
Let me explain: I'm on a lan network that connects to the internet. Whenever I want to host a server - for instance a basic ftp or http server. If I give my external IP to anyone, they won't be able to access my server. Even if I portforward, it doesnt work. I have to use rinetd here. For other applications, portforwarding works. I'm not sure how these things work at all.
Anyway, my issue now is that I have created this server/client application. I'm having serious doubts that if I run the server, I'll have to either a) portforward or use rinetd to get people to connect to my server. IF I need to portforward, that's fine. However, using rinetd would really suck... My 2nd concern is as follows: IF the person running the client is in a similar situation as me (i.e he's on a lan that has a router which connects to the net), will he have to portforward or use rinetd as well? If he portforwards that's fine. But I don't think I could get people to use rinetd.... Also, if there are more than 1 person on a lan trying to connect to my server, there is a big problem when they try to portforward: they will only be able to allocate one of their internal ip to that port, and the others won't be able to connect, right? How does this work? I mean, I use many softwares like msn/skype/(some games)/firefox that do not need portforwarding/rinetd. Yet they work. My housemates(other people on the lan) use the same softwares, and it works fine. There's no clash/probs watsoever How come these run fine?
Anyway, back to my issues. Given I have no knowledge about how the above work, I was wondering whether there was a way to host a vb .net server application on an external website (external to my house) so that I might *avoid* the above mentioned problems, and to what extent that would be a sound solution.
View 11 Replies
Aug 26, 2009
procedure to create a FTP Server and Client program in VB 2008 with sample code?
View 2 Replies
Jun 30, 2009
i wan't to create a tcp client and server
Client contains 1 textbox
Server contains
dim pcdetails as string
pcdetails = "Operating System Name : " + My.Computer.Info.OSFullName.ToString + " ; " + "Platform : " + My.Computer.Info.OSPlatform + vbNewLine + "Operating System : " + Environment.OSVersion.ToString + " v." + Environment.OSVersion.Version.ToString + vbNewLine + "Computer Name : " + Environment.MachineName.ToString + vbNewLine + "User Name : " + Environment.UserName.ToString + vbNewLine + "System
[code]....
View 7 Replies
Sep 22, 2009
i have lots of confused ideas like should you transfer files using tcp? Example: I was thinking, I connect to server from client, open file in binary, division by packet size(bytes), send first packet to server, get request if file was delivered succesfully, send next packet. If I do it this way i would need something to know/increase packet size.
View 5 Replies
Apr 11, 2009
I'm making a program that would require me to send data between to different machines.The way i plan to do this is to have a server program constantly running on my computer.(any other way to do this?) When someone opens the Client program, the program connects to the server. The server then takes the users I.P address and Username and adds it to a listbox on the Server application. Then the server application constantly updates the list of users on the Client application. So that way every user can see everyone that is connected.Then, when the user wants to connect to another user - They select the Username from their listbox of users. Then all connections will be handled between the users = Each user is connected to the other user's Client program. Well there is the first thing i don't know how to do.The next is simply how i send the data between the users. Would i use a winsock control?Example: One user does an action. The winsock control sends the text "blue" to the other user. The other user's program's form color changes to the color blue. That's not what this program will do, but it's just an example.
View 6 Replies
Nov 11, 2009
Is is possible for the server to give all clients that are connected to it a separate threading starting from 1-2-3-etc that will be display there username on a listview. Server can now connect to any of them by clicking on one of the items in the listview.
EX: Multi-Clients Connect to server ---> Server gives each one a separate thread starting with 1 ----> Client sends username to server -----> Server displays them on listview ---> Server can now double click or whatever on the item ---> Pulles up thread count and connects to it.
View 1 Replies
Aug 23, 2010
i write a vb code that it can do connect to serverthe question is when i connect to the server the server have receive the connected and the client exists not found serverit shows out this warning "strData' is passed by reference before it has been assigned a value. A null reference exception could result at runtime."
View 4 Replies
Dec 1, 2008
I have been reading through Atheists posts in regards to client-server and TCP client/server connection's. But how do i go about writing a program with 1 client and server where the client side creates a text file.Once the server sees there is a text file it connects and downloads it to itself or the client pushes the text file to the server.Once on the server i will read the text file and put its info into a sql db.
View 14 Replies
Jun 2, 2010
I'm not even sure where to start. I would like to create something like the ADO DataReader but that works in a TCP Client/Server scenario.Basically, in the TCP Client, I want to be able to call a certain command in the TCP Server which will return a DataReader like object, which I can then iterate through such as:
while dr.Read from the client. In each loop, I would parse out the various fields as in a normal DataReader.The reason I want to do this is to gain the inherent efficiency of the DataReader object since it doesn't first load ALL of the data. To my understanding, the typical TCP Client/Server setup using streams, would first load all of the data on the server, then transport ALL of that data to the client for processing. I want to avoid that, and just stream the data as the client requests through the Read() command which means the connection will remain open to the server while the Read() command is being issued by the client, or until explicitly closed by the client.
View 5 Replies
Aug 10, 2011
I am building a client-server type applications and they are communicating over sockets. This is the first time I am doing such a program and I have been learning off a web example and thought I understood it all but it would appear I am missing something as it starts to work then errors. Here is what I have:
VB
Dim serverSocket As New TcpListener(ListeningPort)
Dim clientSocket As TcpClient
Dim netStream As NetworkStream
Dim BytesFrom(1024) As Byte
Dim DataFromClient As String
[Code] .....
All of the above works and if I open up a telnet command window I can connect to my machine running this code on my specified port and in the command prompt window 'IDENTIFY' appears as it should from the above code. But it then gets to this block an errors on the second line:
VB
'RECEIVE FROM CLIENT
netStream = clientSocket.GetStream()
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
DataFromClient = System.Text.Encoding.ASCII.GetString(BytesFrom)
Now as far as I can tell it shouldn't be processing the first line
[ netStream = clientSocket.GetStream() ]
Until I send something back from the client because then going on to the second line its trying to process something that isn't there yet.
The actual error I get is:
Specified argument was out of the range of valid values. Parameter name: size
On the line:
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
View 8 Replies
Mar 28, 2012
i wanted to develop an apps that sends sends data from client to server and vice versa. i want to biuld it with
View 5 Replies
