[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


I am having a bit of a nightmare here.

My web application connects to eight different SQL databases, each of which
is connected using a connection string (like the following) and it also
connects to three Access DB's

*** SQL Connections ***

Provider=SQLOLEDB;Data Source=127.0.0.1;Initial
Catalog=E_Database;UID=****;PWD=****;
Provider=SQLOLEDB;Data Source=127.0.0.1;Initial
Catalog=M_Database;UID=****;PWD=****;
Provider=SQLOLEDB;Data Source=127.0.0.1;Initial
Catalog=F_Database;UID=****;PWD=****;

*** Access Connections ***

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\...\WMS.mdb

That all works fine, but I am trying to move the Access database into SQL
.... that was simple. Created the permissions on the SQL WMS database and
changed the connection to the following:

Provider=SQLOLEDB;Data Source=127.0.0.1;Initial
Catalog=WMS;UID=****;PWD=****;

.... and it just will not work, with the following error when I try to
connect
[DBNETLIB][ConnectionOpen (Connect()).]
SQL Server does not exist or access denied.

The line of ASP code which triggers the error is the cn.Open in the
following.

Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB;Data Source=127.0.0.1;Initial
Catalog=WMS;UID=****;PWD=****;"
[code]
cn.Close
Set cn = Nothing

Any advice would be welcomed.

Thanks

Sean



.

Relevant Pages

  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: User not associated with trusted SQL Server connection
    ... > using the osql utility. ... > associated with a trusted SQL Server connection. ... > database or is it just for that instance. ...
    (microsoft.public.sqlserver.security)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... While I cannot see how a working example of a connection to a database is ... Select the control button view dataor edit query. ... Look for SQL button to get the SQL ...
    (microsoft.public.excel.programming)
  • Re: Is it just me or are there BIG problems with SQLCE 3.0?
    ... has been done with parameterised SQL, ... bit of code into my test which closes and reopens the database ... opening and closing the DB connection is not a good idea. ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... What version of SQL CE are you using? ... Are you accessing the database from an app written in C++? ... then opens his work forms and it's in those ... It wouldn't seem to me that you'd need a new connection to ...
    (microsoft.public.sqlserver.ce)
Loading