Using a CMP MS Access database on Win2000 & WAS 4.0

[RichardNaylor]

Hi,
I'm a relative beginner with WAS 4.0. I have installed the trial software on Win2000 and it all seems to be OK. I'm trying to work out how to configure a serve to access a Jet/MS Access database. I'm using Access as a trial db for the moment. The help/documentation indicate that I should setup a "datasource" on a server configuration.
Q. Is this correct?

If so the docs concentrate on DB2 datasources ... how would I set up a datasource to Access using the jdbc/odbc bridge.

Thanks for any help in advance.
Richard

 

[fearo]

Hi,

As far as I am aware connection pooling only available for Relational Databases that support JDBC. Thefore the only Microsoft Database Supported under WebSphere is "Microsoft SQL Enterprise Edition (2000 & v7).

However you can connect to ODBC Realational Databases using
ODBC database using the Sun JDBC-to-ODBC bridge driver included in the Java Development Kit (JDK) or another vendor's ODBC driver.

The url attribute specifies the location of the database. The driver attribute specifies the name of the driver to be used to establish the database connection.

If the database is an ODBC database, you can use an ODBC driver or the Sun JDBC-to-ODBC bridge included with the JDK. If you want to use an ODBC driver, refer to the driver documentation for instructions on specifying the database location (the url attribute) and the driver name.

In the case of the bridge, the url syntax is jdbcdbc:database. An example is:

url="jdbcdbc:autos"
driver="sun.jdbc.odbc.JdbcOdbcDriver"

To enable the Application Server to access the ODBC database, use the ODBC Data Source Administrator to add the ODBC data source to the System DSN configuration. To access the ODBC Administrator, click the ODBC icon on the Windows NT Control Panel.

All that looks mighty complicated to me!!!

Lots of luck.

Fearo

 

[wushutwist]

Also, just because a database has a JDBC Driver does not mean that it is supported as a CMP Datasource. Most Application Servers do a lot of optimizations for CMP and these will differ between RDMBS products. You will be pretty much guaranteed the top 3 (Oracle, SQL Server, and DB2) but I would highly doubt that Access is supported as a CMP source.