clu63
Programmer
- Mar 8, 2006
- 4
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=jdbc
racle: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.
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=jdbc
racle: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: jdbc
racle: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.
