client server in vb6 and microsoft sql server 2000

[hondaboy24]

hi guys.. i am currently doing a project that needs to have a client server.. now my IP is let's say 10.0.0.2 and the IP of one of the client is 10.0.0.4. The form i am using is a simple login to see whether my client can login to the system and the database is on the server. Do i have to do a winsock program? i curently have this string connection on the client:

strConn = "driver={SQL Server};server=Test;database=Project;uid=;pwd="

Do i still need to type in the IP add of the server? if yes where do i put it? and is anything missing from my connection string? thanks very much

[Hack]

Is the database on the internet or on a internal network file server?

[hondaboy24]

the database is on an internal network file server.. the client and the server is connected via WiFi

[Hack]

Then I don't see the need for winsock. You should be able to connect to straight through you connection string using the ado connection object.

[hondaboy24]

yea but it doesn't work.. i get an error message saying "Login failed for SERVER\guest"

[Hack]

Are you sure you have the right connection string?

[si_the_geek]

You need to have the server name or address in the "server=Test;" part, you can either use the computer name, or the IP address.

In addition to that, you need to provide some kind of login details - either specify values for uid/pwd if you are using SQL Server logins, or replace them with "Trusted_Connection=Yes;" if you want to use Windows logins.

Note also that if the client computer is using Windows 2000 or earlier, you should install MDAC on it (link in my signature).

[hondaboy24]

the Test is the server name.. should i still put the computer name or IP add before the server name?

[hondaboy24]

i tried it but then i still keep getting the error message "Login failed for SERVER\Guest"

[abhijit]

Could you please post your connection string ?

[Hack]

And are you using ADO or DAO?

[si_the_geek]

the Test is the server name.. should i still put the computer name or IP add before the server name?

No, just one or the other.

i still keep getting the error message "Login failed for SERVER\Guest"

Then the problem is the login details, as I described in my previous post. Either specify uid/pwd, or tell it to use Windows login details (assuming you have enabled Windows logins within SQL Server).

You also need to make sure that in the Security section of SQL Server, the user has permission to connect to the database.