| Errors connecting to oracle server thru ADODB [message #349675] |
Mon, 22 September 2008 10:57  |
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 #349806 is a reply to message #349679] |
Tue, 23 September 2008 03:32  |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
So that is nice 