Microsoft OLE DB Provider for SQL Server error 
Author Message
 Microsoft OLE DB Provider for SQL Server error

Hello,

I'm having problem opening a connection to an SQL 2000
database:
Current Environment:
SQL 2000 with latest patches and SP3
Windows NT SP6
MDAC 2.7 SP1
ASP
SQLXML 3.0

I have no problem opening the connection using ODBC
however when I try
to use SQLOLEDB, I get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

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

/scc/test2.asp, line 51

I have tried a combination of connection strings but
nothing seems to
work:

sConn = "Provider=SQLOLEDB;User ID=abc;Password=abc;Initial
Catalog=North;Data Source=(local)"

sConn = "Provider=sqloledb;Data Source=(local);Network
Library=DBMSSOCN;Initial Catalog=North;User
ID=sa;Password=sa;"

sConn = "Provider=SQLOLEDB; Data Source=LOCAL; Initial
Catalog=North;Trusted_Connection=yes;"

sConn
= "Provider=sqloledb;Server=192.168.1.150,1433;Network
Library=DBMSSOCN;Initial Catalog=North;User
ID=abc;Password=abc;"

sConn ="Provider=SQLOLEDB;Data Source=CR137644-A;Initial

sConn = "Provider=SQLOLEDB;Data Source=CR137644-A;Initial
Catalog=North;Trusted_Connection=yes;"

sConn ="Provider=SQLOLEDB;Server=CR137644-
A;Database=North;UID=sa;PWD=sa"

Dim adoConn
Set adoConn = Server.CreateObject("ADODB.Connection")
   adoConn.ConnectionString = sConn

adoConn.Open

If I use the ODBC method it works great
strConnection="Data Source=North;user id=abc;password=abc"

I need to use SQLOLEDB to load some XML files.

Your help is much appreciated.



Mon, 26 Sep 2005 08:48:58 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Microsoft OLE DB Provider for SQL Server error

2. Microsoft OLE DB provider for SQL server error 80004005

3. Microsoft OLE DB Provider for SQL Server error 80040e31

4. Microsoft OLE DB Provider for SQL Server error

5. Microsoft OLE DB Provider for SQL Server error

6. Microsoft OLE DB Provider for SQL Server error

7. Microsoft OLE DB Provider for SQL Server error 80040e14

8. Microsoft OLE DB Provider for SQL Server 80004005: Unspecified Error followed by Insufficient memory

9. Error -2147217871 from Microsoft OLE DB Provider for SQL Server: Timeout expire

10. Error Source: Microsoft OLE DB Provider for SQL Server

11. Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) Timeout expired

12. DTS Error - Microsoft OLE DB Provider for SQL Server


 
Powered by phpBB® Forum Software