General Questions:
ADODB Questions:
Does J-ASP support JScript and JavaScript code in the server side ? |
No, J-ASP only supports VBScript server side code. |
Does J-ASP support Third-Party ActiveX/COM ? |
No, J-ASP can't support Third-Party ActiveX/COM. You need to migrate ActiveX/COM to JavaBean. J-ASP does support the JavaBean fine. We also provide ActiveX/COM to JavaBean migration services, please contact asp2jsp@netcoole.com if you need. |
Why do I get the "The page cannot be found" error ? |
Please make sure the path and file name are correct, the file name is case sensitive. |
Why do I get "4200 Not found the Driver" error ? |
You need set the JDBC Driver to CLASSPATH, for example:
Dim DBConn you need to add the Oracle jdbc driver ojdbc14.jar to CLASSPATH. |
How to connect a database with J-ASP ADO ? |
Please modify your ConnectionString as JDBC driver provided syntax: "Driver=drivername;URL={url};UserID=userid;Password=password" For example (Connect Oracle database):
Dim DBConn Note: please download Oracle jdbc driver from http://www.oracle.com
For example (MS-SQLServer with JTurbo jdbc driver): If you have created the JNDI Data Source Name in the webserver, you may change the connection string to the following format: |
How to handle REF CURSOR output parameter with J-ASP? |
J-ASP supports REF CURSOR parameter, please refer to the following sample.
'----------------- SQL SCRIPT -----------------------
Set cmdStoredProc = Server.CreateObject ("ADODB.Command") |