iASP ADO Interface

Instant ASP provides an ADO interface that allows you to access a database through the JDBC driver. To set the connection string, use the following general syntax:

"Driver=drivername;URL={http://www.myURL.com};UID=username;PWD=password;"

Parameter	Description
Driver	Certain drivers convert client JDBC calls to DBM. Each driver must supply a class that implements the Driver interface.
URL	JDBC URL-a database url of the form jdbc:subprotocol:subname
UID	The database user on whose behalf the Connection is being made
PWD	The database user's password

Visual Basic Example:

Dim conDim conString conString = "Driver=oracle.jdbc.driver.OracleDriver;URL={jdbc:oracle:thin:@192.9.200.111:ORCL}; UID=SCOTT;PWD=TIGER;". set con = Server.CreateObject("ADODB.Connection") con.Open(conString)

NOTE: You must set your CLASSPATH to include the path of the driver file containing the java classes that implement the driver.

For example, if the connection string is:

"Driver=oracle.jdbc.driver.OracleDriver;URL={jdbc:oracle:thin:@192.9.200.111:ORCL};UID=SCOTT;PWD=TIGER;",

then you must set your CLASSPATH to include the path of the zip file containting the class files of "oracle.jdbc.driver.OracleDriver."

Additionally, if you are using "JDBC-ODBC bridge" as your driver type, you don't have to set the driver files in your CLASSPATH, but you must register database then connect the database by using the following general syntax:

"DSN=Datasource name;UID=UserID;PWD=Password;"

Parameter	Description
DSN	Certain drivers convert client JDBC calls to DBM. Each driver must supply a class that implements the Driver interface.
UID	The database user on whose behalf the Connection is being made
PWD	The database user's password

If you encounter any problems or errors, please contact support@halcyonsoft.com