Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Marshal
Posts: 27276
87
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What JDBC driver are you planning to use for Access?
 
Armando Rivasa
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Marshal
Posts: 27276
87
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Marshal
Posts: 27276
87
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
No at all, In Tomcat I haven`t never configured a pool connection.
Thanks.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic