I try to connect a server via IP address but I didn't.
My server is in LAN network. The address of router is 222.252.96.159 and address of myserver in LAN 10.0.0.3 My connectionstring is

CN2.ConnectionString = "Driver={SQL Server};" & _
           "Server=222.252.96.159;" & _
           "Address=10.0.0.3,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=Pubs;" & _
           "Uid=sa;" & _
           "Pwd="

Any problems ?

Tran Tuan An.

http://www.carlprothman.net/Default....erForSQLServer

I have no idea why you are using ADDRESS= there.

And the 1433 belongs on the Server, but you really don't need it since that's the default.

Thanks for your help, Old Pedant.

Infact, the syntax of this connectionstring is:
CN2.ConnectionString = "Driver={SQL Server};" & _
           "Server=x.x.x.x;" & _
           "Address=x.x.x.x,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=Pubs;" & _
           "Uid=sa;" & _
           "Pwd="
but I didn't connect with

CN2.ConnectionString = "Driver={SQL Server};" & _
           "Server=222.252.96.159;" & _
           "Address=222.252.96.159,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=Pubs;" & _
           "Uid=sa;" & _
           "Pwd="
or
CN2.ConnectionString = "Driver={SQL Server};" & _
           "Server=10.0.0.3;" & _
           "Address=10.0.0.3,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=Pubs;" & _
           "Uid=sa;" & _
           "Pwd="

so i tryed that. And the port of sql server is default (1433).

I worry about ado don't support this case. That is true ?

Tran Tuan An

Is there a reason you must use the IP information to connect to the database? I usually use this sort of connection string with no problems:

cn.Open "Provider=SQLOLEDB;Data Source=SERVERNAME;Initial Catalog=DATABASENAME;UID=USERID;PWD=PASSWORD"






mmcdonal

Look it up at: http://wrox.books24x7.com

That's what I was trying to ask, also. Why is the ROUTER address important, at all??? Why is it in there?