HELP Connecting from VB to SQL via IP address

[zygon]

I wish to set up an ADO connection and incorporate the IP address into the connection string. I have been told it's really easy but for some reason I can't find it documented, I might be looking in the wrong place.
Thanks

[Jeff Proctor]

Here's an excerpt from my ASP application global.asa and yes you are in the wrong place. The first with the friendly name and the other with the IP. In any of the VB wizards you can use the IP or the friendly name.

Sub Application_OnStart
Application("ConnectString&#34= "PROVIDER=SQLOLEDB.1;DATABASE=MyDatabase;SERVE R=MyServer;UID=sa;PWD=;"
End Sub

Sub Application_OnStart
Application("ConnectString&#34= "PROVIDER=SQLOLEDB.1;DATABASE=MyDatabase;SERVE R=201.178.135.140;UID=sa;PWD=;"
End Sub

HTH



------------
zygon at 5/3/01 6:06:10 AM

I wish to set up an ADO connection and incorporate the IP address into the connection string. I have been told it's really easy but for some reason I can't find it documented, I might be looking in the wrong place.
Thanks