I need to connect WAS 6.1.0.0 to MS-Access through ODBC

[Armando Rivasa]

Hi Everybody

I've spent like 3 days trying to connect to Access and the webServer is WAS 6.1.0.0. but I haven`t been able to do it
I made the same connection and with the same war in Tomcat, GlassFish but not in WAS.

Maybe it's stupid but it is requirement that I have to do, I've read a lot trying to configure the WAS creating a new JDBC dataSource but nothing. Please, could you help to solve this??

Thanks ranchers.

[Paul Clapham]

What JDBC driver are you planning to use for Access?

[Armando Rivasa]

Thanks, I'm not using JDBC, I use ODBC, and the className is "sun.jdbc.odbc.JdbcOdbcDriver".
Previously I've configured a DSN in Windows XP.

[Paul Clapham]

I don't believe that driver supports data sources. Your original post could be interpreted to mean that you configured a connection pool for that driver in Tomcat; did it really mean that, or what did it mean?

[Lalit Chattar]

Armando Rivasa wrote:Hi Everybody

I've spent like 3 days trying to connect to Access and the webServer is WAS 6.1.0.0. but I haven`t been able to do it
I made the same connection and with the same war in Tomcat, GlassFish but not in WAS.

Maybe it's stupid but it is requirement that I have to do, I've read a lot trying to configure the WAS creating a new JDBC dataSource but nothing. Please, could you help to solve this??

Thanks ranchers.

hello,

you can connect odbc using open administrator cosol of server And open resource. in this open jdbc and set the driver type which you use...

[Armando Rivasa]

Okas, I think I need to clarify my issue.

The first thing I made was.

1.- In Window XP, I clicked in "Control Panel"
2.- Then I clicked on "Admin Tools"
3.- then I clicked on ODBC DataSource Administrator, in that dialog, I chose "System DSN" to add a new "Data Source", when I select the Access database that is in other machine.
however, the name I gave to the DSN is "Salvamentos_Access".
4. With the step above I can connect my Java program using Tomcat, Glassfish but NOT in WAS. (obviously I programmed several lines using "sun.jdbc.odbc.JdbcOdbcDriver" which is supposed to be in the java Core).

--------------------------------------------
Searching on the Internet I found that I have to configure WAS 6.1 in the administrative console, and I did.
1.- On the "Resources Section" I created a new JDBCprovider called "ODBC_Provider", the classpath is "C:\IBM\WAS\java\jre\lib\core.jar", the implementation class name "sun.jdbc.odbc.JdbcOdbcDriver".

2.- I also created a new DataSource called "MY_ODBC_DataSource", JNDI name = "JNDI-Access" and the custom properties are.
a. url = jdbc:odbc:Salvamentos_Access
b. driver = sun.jdbc.odbc.JdbcOdbcDriver

Thank all, when I push the "Test Connection" it give me the following error.

The test connection operation failed for data source MY_ODBC_DataSource on server server1 at node M0072017Node01 with the following exception: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: sun.jdbc.odbc.JdbcOdbcDriver incompatible with javax.sql.ConnectionPoolDataSource. View JVM logs for further details.

I don't understand, do you know any other way to connect from WAS to Access???

[Paul Clapham]

So... I ask again... did you configure a connection pool in Tomcat for MS Access? Just yes or no would be a useful answer.

[Armando Rivasa]

No at all, In Tomcat I haven`t never configured a pool connection.
Thanks.