A) Since a MS Access database is not a database server, you'll have to use a third party driver or a Java/COM bridge such as our RJAX product, to enable connectivity. The Access database must remain on its Windows NT host. In addition to RJAX, we have also tested Merant's SequeLink JDBC driver. An evaluation copy of SequeLink can be obtained from: http://www.merant.com/datadirect/download/eval/index.asp . Make sure you download both the SequeLink server for Windows NT and the JDBC driver for the iASP side of things.

NOTE: We do NOT recommend Access databases for anything other than lightly loaded environments. Remember, MySQL is free...

Configuring SequeLink Server

Please refer to the SequeLink Server installation instructions provided by Merant.

JDBC Client Configuration

Download the "SequeLink Java Edition 2.0 Client" from the link above and run the following command at the command line to extract the slje.jar (JDBC Client) file:

cd [location of setup.class]
java -classpath ./ setup.class

NOTE: The installation will prompt you for a license key which you can get from DataDirect.

Once the installation has completed, slje.jar should be located in [installation folder]/slje/driver/classes. Copy the slje.jar file to the system on which iASP is installed and modify start-server.sh so that it includes slje.jar in the classpath.

NOTE: For Novell NetWare, copy the slje.jar file to the NetWare volume and modify etc/java.conf so that it includes slje.jar in the servletclasspath.

Restart your webserver for the configuration to take effect.

ADO Connection Strings

Finally, modify your ADO connection strings. The basic prototype looks like:

"DRIVER=intersolv.jdbc.sequelink.SequeLinkDriver;
URL={jdbc:sequelink://[ip address]:[server port]/
[ODBC MS Access];Database=[path to MS Access database]};
UID=[user id];PWD=[user passwd]"

EXAMPLE: The following example connects to a a SequeLink server residing on 192.168.200.245 on port 4011. The userid is 'admin' and the password is also 'admin'. The Access database is located in d:\webservers\iasp102p2\samples\testscripts\threadit\data.mdb.

Set objConn = Server.CreateObject ("ADODB.Connection")
Set objRec = Server.CreateObject ("ADODB.Recordset")

objConn.Open strConnect = "DRIVER=intersolv.jdbc.sequelink.SequeLinkDriver;URL=
{jdbc:sequelink://192.168.200.245:4011/[ODBC MS Access];Database=
d:\\webservers\\iasp102p2\\samples\\testscripts\\threadit\\data.mdb};
UID=admin;PWD=admin"