|
 |
asp_databases thread: ADODB.Connection error '800a0e7a'
Message #1 by fione2002@y... on Wed, 18 Jul 2001 19:48:05
|
|
Please help!!!
I always get this message whenever I test my page
I'm using MS Visual Interdeve this, and this is connection function that
connects into an Oracle database. And I'm using ODBC for Oracle, do you
think there is something with the provider?
Thanks!!
-------------------------
ADODB.Connection error '800a07a'
Provider cannot be found. It may not be properly installed
/orgchart1/ADOFunctions_inc.asp, line 14
--------------------------------------------
Here is my code...
Function GetDBConnection()
Dim objConnection
set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection
.ConnectionString="Provider=MSDORA; password=emp;
user id=emp; data source=sdeprod;"
.Open
End With
set GetDBConnection = objConnection
End Function
Message #2 by kalyan_ramji@h... on Wed, 18 Jul 2001 20:47:01
|
|
Hey,
What preceeds the .Open? I think you can directly say
objConnection.Open "Provider=.....". Try that out..
Good Luck!!
> Please help!!!
>
> I always get this message whenever I test my page
> I'm using MS Visual Interdeve this, and this is connection function that
> connects into an Oracle database. And I'm using ODBC for Oracle, do you
> think there is something with the provider?
>
> Thanks!!
>
> -------------------------
> ADODB.Connection error '800a07a'
> Provider cannot be found. It may not be properly installed
>
> /orgchart1/ADOFunctions_inc.asp, line 14
>
> --------------------------------------------
>
> Here is my code...
>
> Function GetDBConnection()
> Dim objConnection
>
> set objConnection = Server.CreateObject("ADODB.Connection")
> With objConnection
> .ConnectionString="Provider=MSDORA; password=emp;
> user id=emp; data source=sdeprod;"
> .Open
> End With
>
> set GetDBConnection = objConnection
>
> End Function
>
Message #3 by David Cameron <dcameron@i...> on Thu, 19 Jul 2001 10:27:52 +1000
|
|
One comment, you aren't using ODBC. If you were your connection string would
look more like this:
"password=emp; user id=emp; DSN=MyDSN;"
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: fione2002@y... [mailto:fione2002@y...]
Sent: Thursday, 19 July 2001 5:48 AM
To: ASP Databases
Subject: [asp_databases] ADODB.Connection error '800a0e7a'
Please help!!!
I always get this message whenever I test my page
I'm using MS Visual Interdeve this, and this is connection function that
connects into an Oracle database. And I'm using ODBC for Oracle, do you
think there is something with the provider?
Thanks!!
-------------------------
ADODB.Connection error '800a07a'
Provider cannot be found. It may not be properly installed
/orgchart1/ADOFunctions_inc.asp, line 14
--------------------------------------------
Here is my code...
Function GetDBConnection()
Dim objConnection
set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection
.ConnectionString="Provider=MSDORA; password=emp;
user id=emp; data source=sdeprod;"
.Open
End With
set GetDBConnection = objConnection
End Function
Message #4 by "Ken Schaefer" <ken@a...> on Thu, 19 Jul 2001 17:43:39 +1000
|
|
Not necessarily.
ODBC connections can either use a DSN, or they can be DSN-less.
ODBC connections that don't use a DSN use a Driver= statement
OLEDB connections, on the other hand, use a Provider= statement
http://www.able-consulting.com/ADO_Conn.htm
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "David Cameron" <dcameron@i...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, July 19, 2001 10:27 AM
Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'
: One comment, you aren't using ODBC. If you were your
: connection string would look more like this:
: "password=emp; user id=emp; DSN=MyDSN;"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
