In W2k SP2/JDK1.3.1,
I am able to compile/execute JAVA program to access oracle9i database
thru oracle JDBC thin driver from the command line by setting CLASSPATH/PATH and
aso able to access oracle9i database thru ASP+DSN...
When connecting Oracle9i Database in ASP using thin driver, I got the following error:
Microsoft OLE DB Provided for ODBC Drivers (0X80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The code is as follows( CLASSPATH & PATH are defined as System Variables):
set conn = Server.CreateObject("ABODB.Connection")
strCnn = "Driver=oracle.jdbc.OracleDriver;"
strCnn = strCnn & "URL={jdbc:oracle:thin:@mysite:1521:orcl};UID=scott;PWD=tiger;"
conn.Open strCnn
What to do next!
How does ASP access the oracle jdbc thin driver?
Do I have to do any installation?
Please advise...
Thanks,