Couple of ways. Are you using an ODBC DSN or are you going DSN Less?

DSN Less see http://www.connectionstrings.com


Good Luck

I used the Connection string via an IP address (see the code below) and successfully connected...


But when I run the application in another computer I got this error:
Run-time error'-2147467259(80004005)': SQL Server does not exist or access is denied.


I also used the OLE db Provider Connection String but same error encountered...

Thanks for the assistance.

Check the settings of your server and OS and I think you need to specify the port of 1433...

see...

http://www.connectionstrings.com/sql-server#6

then scroll down a bit for internet connection


Good Luck

I really appreciate your help, thank u so much! Is the problem really in the connection string? Or do i need to configure first or setup the connection of the two pcs? Thanks!

Normally, on a MS network that uses TCP/IP, the named pipes protocal is also installed and is used as a secondary protocal. Now, SQL server is very use to this protocal and normally when you create an ODBC DSN it is via named pipes but you can specify other protocals when you create it.

So, first off, I would suggest just as an experiment, to see if you can create an ODBC DSN from one computer to the server. Don't forget to test the connection to make sure it works.

Then if the ODBC DSN does work then yes you do have to tweak your connection string some...

Search the web for vb6 connection string builder

and this is a vb6 add-in someone made

http://www.vbforums.com/showthread.p...string+builder

There are a couple more out there also...


Good Luck