I'm trying to connect to a client's sql server db using visual basic 6.
He does not know much about computers, so it is very difficult to find out what the problem is.
I'v got a backup of his database and according to a 3rd party the username and password should be "sa" and the database is a sql server 2008 express, but they could be wrong.
When connecting to my own local pc (sql server 2008 express), using the following connection string, it is working.
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MyDB;Data Source=localhost\SQLEXPRESS","sa","sa"
When write a little test app to see if I can connect to his database, it take a long time and then I get the following error.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
I don't have access to his pc and I'm only able to email him test apps to see if I can establish a connection.