JDBC connection to an oracle database in VBS

[clu63]

I need assistance with establishing a JDBC connection to an oracle database in VBS.

I am familiar with VBA and ADODB connections but I am new to VBS and JDBC. I have all the pieces I need and have been able to successfully connect to the database with DbVisualizer but after spending several days searching the web and newsgroups I am not sure what I am lacking to make the connection.

ConectionString="DRIVER=oracle.jdbc.OracleDriver;URL=jdbcracle:thin<mc-name>:<port-no>:<DbName>;uid=<uid>;pwd=<pwd>"
set con = CreateObject("ADODB.Connection")
con.open(ConectionString)
set RS = CreateObject("ADODB.Recordset")
RS.Open "Select * FROM PKG", con, 3, 3


The above code has been pieced together from my research and when it is run it produces an error: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified

I have the correct driver 0jdbc.jar which from what I can tell contains 2 drivers which is where I got "oracle.jdbc.OracleDriver" from. This driver was used to set up DbVisualizer but I am not clear how to use it with the above code. Also, I am aware that I am using CreateObject("ADODB.Connection") which does not seem correct as I am trying to establish a JDBC connection.

The below information was provided to me along with the driver.
DB name: <DbName>
DB type: oracle/unix
DB UID: <uid>
DB PWD: <pwd>
URL: jdbcracle:thin<mc-name>:<port-no>:<DbName>

I am also interested in using the above information in a DSN file but I am mostly concerned with creating the connection in vbs any way that I can.

Thank you for any assistance and direction.

 

[PHV]

Aren't JDBC drivers for Java ?

 

[clu63]

Yes they are but I have been aked to use it instead of ODBC. I am starting to get the feeling after my research that JDBC is not meant to work with VBS. That is what I am trying to determine. Thank you for your reply.

 

[Sheco]

If you could make a DSN with it then perhaps... I'd do some poking around and see if JDBC could be used via MS Access... if so then it should be doable via VBScript.