jQuery in Action, 2nd edition*
The moose likes Websphere and the fly likes I need to connect WAS 6.1.0.0 to MS-Access through ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "I need to connect WAS 6.1.0.0 to MS-Access through ODBC" Watch "I need to connect WAS 6.1.0.0 to MS-Access through ODBC" New topic
Author

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

Armando Rivasa
Greenhorn

Joined: Jan 27, 2010
Posts: 4
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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

What JDBC driver are you planning to use for Access?
Armando Rivasa
Greenhorn

Joined: Jan 27, 2010
Posts: 4
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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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
Greenhorn

Joined: Oct 22, 2009
Posts: 11
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
Greenhorn

Joined: Jan 27, 2010
Posts: 4
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 = jdbcdbc: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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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
Greenhorn

Joined: Jan 27, 2010
Posts: 4
No at all, In Tomcat I haven`t never configured a pool connection.
Thanks.
 
Don't get me started about those stupid light bulbs.
 
subject: I need to connect WAS 6.1.0.0 to MS-Access through ODBC
 
Similar Threads
update IBM WAS ND 6.1.0.0 to 6.1.0.15
using JDBC in applets - security exception
Unable to connect to MySQL
client cant connect to mysql
Applet to Database connection