Problem on Asp ODBC Connection to SQL Server


E

EDDIE

Dear All,

I have problem on data connection to a SQL Server by Asp Statement.
It's Very strange that my asp statement can connect to one remote SQL server
but can't connect to other remote SQL server.
The statement written like this :

Set DBLBX=Server.CreateObject("ADODB.Connection")
DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"

It show the follows:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

Is that the problem of my Sql server ?

Thanks all.
 
Ad

Advertisements

B

Bob Barrows [MVP]

EDDIE said:
Dear All,

I have problem on data connection to a SQL Server by Asp Statement.
It's Very strange that my asp statement can connect to one remote SQL
server but can't connect to other remote SQL server.
The statement written like this :

Set DBLBX=Server.CreateObject("ADODB.Connection")
DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"

It show the follows:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

Is that the problem of my Sql server ?

Thanks all.

Part of the problem is that you are using the obsolete ODBC provider when
there is a perfectly good native sql server provider available (SQLOLEDB).
See http://www.aspfaq.com/show.asp?id=2126

Also relevant is this article, which is a compendium of all the causes of
database-related 80004005 errors:
http://www.aspfaq.com/show.asp?id=2009

Bob Barrows
 
Ad

Advertisements

E

EDDIE

Many thanks.
I have solved it by using OLEDB.
Thx ^^
Bob Barrows said:
EDDIE said:
Dear All,

I have problem on data connection to a SQL Server by Asp Statement.
It's Very strange that my asp statement can connect to one remote SQL
server but can't connect to other remote SQL server.
The statement written like this :

Set DBLBX=Server.CreateObject("ADODB.Connection")
DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"

It show the follows:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

Is that the problem of my Sql server ?

Thanks all.

Part of the problem is that you are using the obsolete ODBC provider when
there is a perfectly good native sql server provider available (SQLOLEDB).
See http://www.aspfaq.com/show.asp?id=2126

Also relevant is this article, which is a compendium of all the causes of
database-related 80004005 errors:
http://www.aspfaq.com/show.asp?id=2009

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top