Home » Infrastructure » Windows » Errors connecting to oracle server thru ADODB (Oracle Client 10, Oracle Server 9i, ASP, Win2k3)
Errors connecting to oracle server thru ADODB [message #349675] Mon, 22 September 2008 10:57 Go to next message
mysticslayer
Messages: 5
Registered: September 2008
Location: Netherlands
Junior Member
Well I have done alot of things to fix the problem:

- Added the environment variables
- Added the IUSR and IWAM accounts to the R:\Oracle folder
- Gave the users full control permissions
- Tested the connections with the ODBC Data Sources. (Works fine)
- Rebooted the system every time I changed something.
- Installed MDAC 2.8

Still have the same problems:

3) Sub Session_OnStart
4)    Dim Connectie, DSN, maxTijd, cst
5)    Dim naam, wachtwoord
6)    maxTijd         = 999       ' 15 minuten
7)    Session.timeout = maxTijd
8)
9)    strConnection =  "Provider=MSDAORA.1;Password=<password;User ID=<login;Data Source=COOA;"
10)
11)    Set conn = Server.CreateObject("ADODB.Connection")
12)   conn.Open strConnection
13)
14) End Sub


Line numbers are for reference to the fault below

But I only get is the following message:

Microsoft OLE DB Provider for Oracle error '80004005'

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

/LM/W3SVC/737670477/ROOT/<website>/global.asa, line 12

I have oracle client 10 installed on my Win2k3 Standard server and try to connect to a oracle server 9.2.0.xx

What have I done wrong, or what did I forget?
Re: Errors connecting to oracle server thru ADODB [message #349679 is a reply to message #349675] Mon, 22 September 2008 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to use Oracle driver instead.
If your Microsoft one requires Oracle 7.3.3 components you are out of luck to make it work now.

Regards
Michel
Re: Errors connecting to oracle server thru ADODB [message #349806 is a reply to message #349679] Tue, 23 September 2008 03:32 Go to previous messageGo to next message
mysticslayer
Messages: 5
Registered: September 2008
Location: Netherlands
Junior Member
Allright I have now changed the connectionstring:

"Driver=oracle.jdbc.driver.OracleDriver;URL=jdbc:oracle:thin:@ipaddress:ORCL;UID=<username>;PWD=<password>;

Now I got the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Re: Errors connecting to oracle server thru ADODB [message #349816 is a reply to message #349806] Tue, 23 September 2008 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How could you have a Microsoft driver error if you use an Oracle driver?

Regards
Michel
Re: Errors connecting to oracle server thru ADODB [message #349821 is a reply to message #349816] Tue, 23 September 2008 03:59 Go to previous messageGo to next message
mysticslayer
Messages: 5
Registered: September 2008
Location: Netherlands
Junior Member
Well It is a strange problem that's for sure, but I don't understand why Oracle gives me M$ errors.
Re: Errors connecting to oracle server thru ADODB [message #349864 is a reply to message #349821] Tue, 23 September 2008 06:11 Go to previous messageGo to next message
mysticslayer
Messages: 5
Registered: September 2008
Location: Netherlands
Junior Member
Well I'm going to give Oracle Client a patch to 10.1.0.5 instead of 10.1.0.2. Maybe this will resolve the problems.
Re: Errors connecting to oracle server thru ADODB [message #349885 is a reply to message #349675] Tue, 23 September 2008 06:51 Go to previous messageGo to next message
mysticslayer
Messages: 5
Registered: September 2008
Location: Netherlands
Junior Member
Well it did work with a patch set of Oracle Very Happy So that is nice Cool
Re: Errors connecting to oracle server thru ADODB [message #349891 is a reply to message #349885] Tue, 23 September 2008 07:09 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good to know it. Thanks

Michel
Previous Topic: TNS-12560 during installation
Next Topic: TNSLSTNR.EXE crashes with every connection
Goto Forum:
  


Current Time: Thu Mar 28 07:57:42 CDT 2024