OraFAQ Forum: Windows » error connecting to Oracle 8 database using ODBC

Home » Infrastructure » Windows » error connecting to Oracle 8 database using ODBC

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error connecting to Oracle 8 database using ODBC [message #99479]

Wed, 28 November 2001 02:11

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

----------------------------------------------------------------------

Report message to a moderator

Re: error connecting to Oracle 8 database using ODBC [message #99598 is a reply to message #99479]

Tue, 22 January 2002 12:24

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

Report message to a moderator

Re: error connecting to Oracle 8 database using ODBC [message #99641 is a reply to message #99479]

Sat, 02 February 2002 22:37

sandeep
Messages: 110
Registered: October 2000

Senior Member

hi i am sandeep

Report message to a moderator

Re: error connecting to Oracle 8 database using ODBC [message #99694 is a reply to message #99479]

Wed, 20 February 2002 17:49

jakkie
Messages: 1
Registered: February 2002

Junior Member

please tell is seconds, Iam waiting here

Report message to a moderator

Re: error connecting to Oracle 8 database using ODBC [message #99709 is a reply to message #99479]

Wed, 27 February 2002 03:36

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

Report message to a moderator

Previous Topic:	Re: Exporting Access to Oracle
Next Topic:	Re: ORA-12560: TNS:protocol adapter error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 07:48:04 CST 2025