Home » Infrastructure » Windows » error connecting to Oracle 8 database using ODBC
error connecting to Oracle 8 database using ODBC [message #99479] Wed, 28 November 2001 02:11 Go to next message
Emma
Messages: 12
Registered: November 2001
Junior Member
Im trying to connect (DSN connection) from ASP to an Oracle 8 datase.
The database and webserver both run on NT4

I have tested my dsn using ODBC test and it was fine,

Heres the connection strings - I have got the same error message for each

set conn = server.createobject("adodb.connection")

dim strConn

strConn = ("ODBC;DSN=MyDSN;USR=myUid;PWD=myPass")
conn.open strConn

===============================================
Also tried :

Conn.Open "Mydsn", "Myuid", "Mypass"

===================================================
Also tried

strConn = "Provider=MSDAORA.1;Password=MYpass
;User ID=Myuid;Data Source=MYdsn;Persist Security Info=True"

I get the following error when I run the asp page using any of the above connection strings :

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/orcl/ora.asp, line 4

Thanks in advance

----------------------------------------------------------------------
Re: error connecting to Oracle 8 database using ODBC [message #99598 is a reply to message #99479] Tue, 22 January 2002 12:24 Go to previous messageGo to next message
Vasilios Koutsoubidis
Messages: 1
Registered: January 2002
Junior Member
Hi Emma,

it may be related to DLL permissions, check the following article (Q201740):

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q201740

ps.
the following line:
strConn = ("ODBC;DSN=MyDSN;USR=myUid;PWD=myPass")
should be:
strConn = "ODBC;DSN=MyDSN;USR=myUid;PWD=myPass"
(taken out the parentheses)

for a comprehensive list of connection strings refer to:
http://www.able-consulting.com/ADO_Conn.htm
Re: error connecting to Oracle 8 database using ODBC [message #99641 is a reply to message #99479] Sat, 02 February 2002 22:37 Go to previous messageGo to next message
sandeep
Messages: 110
Registered: October 2000
Senior Member
hi i am sandeep
Re: error connecting to Oracle 8 database using ODBC [message #99694 is a reply to message #99479] Wed, 20 February 2002 17:49 Go to previous messageGo to next message
jakkie
Messages: 1
Registered: February 2002
Junior Member
please tell is seconds, Iam waiting here
Re: error connecting to Oracle 8 database using ODBC [message #99709 is a reply to message #99479] Wed, 27 February 2002 03:36 Go to previous message
Breda
Messages: 1
Registered: February 2002
Junior Member
Set cn = New Connection
cn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=text;Password = text ;Data Source = databasename"
this works for me
Previous Topic: Re: Exporting Access to Oracle
Next Topic: Re: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Fri Mar 29 08:16:45 CDT 2024