What is Wrong??

[Janaka]

In a VB program ADODB object is used to connect to a database

Private conObj      As New ADODB.Connection

We use following connection string to connect to our test database in our network, and it works fine

sConnString=”Provider=SQLOLEDB.1;Password=prasad;Persist Security Info=True;User ID=janaka;Initial Catalog=LTL;Data Source=DB”
 
conObj.Open sConnString

We then hosted the database in different location

They have given us following connection string to connect to the sites database in our ASP pages,

sConnString = "DRIVER=SQL Server;SERVER=10.14.8.20;UID=janaka;PWD=prasad;DATABASE=db8"

When I try to open the connection to the database in my VB program using the same connection string

I get following error

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

What’s going on??

[khalik]

cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=SA;Password=XXX=;Initial Catalog=data_dmp;Data Source=aswin"

u can use this and change the source to

SERVER=10.14.8.20;UID=janaka;
PWD=prasad;
Catalog=db8