Issues Oracle9i connection

[jscontreras]

Hi Everyone,

I seem to be having some issues with connecting to Oracle9i. Usually I use the following syntax to connect to Oracle and it works fine.
Syntax:
strConnection = "Driver={Microsoft ODBC for Oracle};SERVER=servername;UID=username;Pwd=password;Database=pubs"

However now with Oracle9i I get the following error message on my asp page:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I noticed a new driver for Oracle9i call Oracle in OraHome90

However when I try to create a DSN name in ODBC sources and try to test it I keep getting this error message:
The procedure entry point slcvs2ptr could not be located in the dynamic link libray oracore9.dll.

I have installed the Oracle 9 Client successfully.

If anyone can help, I would defintely appreciate it.

Thanks

 

[Dynapen]

If you have the Oracle 9i Client installed correctly, you should be able to use the OLEDB driver, instead of the ODBC..

It's connects like this.

Provider=MSDAORA;Password=password;Persist Security Info=True;User ID=userid;Data Source=DB_Name"

That's the easiet way to do it. If the OLE DB driver isn't already installed, you can select it if you do a custom install on the Oracle 9i client. The money's gone, the brain is shot.....but the liquor we still got.

 

[jscontreras]

Thanks I'll let you know what happens!

Nice statement at the bottom!

 

[jscontreras]

In order to access an Oracle Server, you need the client stored on the Web Server? or SQL*Net is it different for Oracle9i?

Thanks

 

[jscontreras]

Managed to get the connection up and running. Here's how I did it:

Installed the Oracle client-created a DSN name and point through my global.asa

ConnDB.OPEN APPLICATION("DSN&quot, APPLICATION("Username&quot, APPLICATION("Password&quot

Thanks