Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Connecting Oracle DB thru oracle JDBC thin driver in ASP


Message #1 by "henry Kam" <hkskam@w...> on Thu, 2 May 2002 17:20:48
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,


  Return to Index