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

VB Code:
  1. Private conObj      As New ADODB.Connection
We use following connection string to connect to our test database in our network, and it works fine

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

  2.  
  3. 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,

VB Code:
  1. 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

VB Code:
  1. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

What’s going on??