JDBC Connection Help
- From: "clu" <josperjr@xxxxxxxxx>
- Date: 8 Mar 2006 16:30:54 -0800
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:oracle: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:oracle: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.
.
- Follow-Ups:
- Re: JDBC Connection Help
- From: Hal Rosser
- Re: JDBC Connection Help
- Prev by Date: Re: Rename file extension
- Next by Date: How to copy sheets in an Excel Workbook
- Previous by thread: remove white spaces at the end of a string.
- Next by thread: Re: JDBC Connection Help
- Index(es):