This question is locked. New answers and comments are not allowed.
I was not able to establish a connection to my SQL Server 2000 db. I can connect to SQL 2008.
test connect with the following URL:
Backend=mssql;Server=DevServer1\SP3;Database=Orders;Driver=;Integrated Security=True;
The connection could not be established. The reason was:
No Server.
A database server on the computer 'DevServer1\SP3' does not respond.
Please verify that a database server is running and reachable on that machine.
I tried add changing the connectionParams adding 'Provider=SQLOLEDB.1;'
Any other suggestions?
test connect with the following URL:
Backend=mssql;Server=DevServer1\SP3;Database=Orders;Driver=;Integrated Security=True;
The connection could not be established. The reason was:
No Server.
A database server on the computer 'DevServer1\SP3' does not respond.
Please verify that a database server is running and reachable on that machine.
I tried add changing the connectionParams adding 'Provider=SQLOLEDB.1;'
Any other suggestions?