cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with drivers

Former Member
0 Kudos

Hi All,

Can any body help me out form this problem.

I have configured the file to jdbc scenario, I have taken the DataBase as MSAcess.

I have used the following driver and connection string:

<b> Dirver</b>: JDBC Driver:sun.jdbc.odbc.JdbcOdbcDriver

<b>Connection</b>: jdbc:odbc:Driver={Mircrosoft Access Driver(*.mdb)};DBQ=C:\XI_FILES\RECEIVER\LIBRARY_DETAILS.mdb

I am getting the problem in Connection string.

I am getting some problem with the drivers.

Can any body let me know what is the exact driver should i need to use?

Thanks in Advance.

Thanks and Regards,

Chandu.

Accepted Solutions (0)

Answers (2)

Answers (2)

Shabarish_Nair
Active Contributor
0 Kudos

use the JDBC ODBC driver which is packaged with any j2EE installation.

No driver needs to be installed for MS Access.

Also ref:

Former Member
0 Kudos

Hi Vijay,

I am using the following drivers and connection string to connect my databse.

Dirver: JDBC Driver:sun.jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Mircrosoft Access Driver(*.mdb)};DBQ=C:\XI_FILES\RECEIVER\LIBRARY_DETAILS.mdb

I have created this database in xi server itself.

Please let me know if you have any queries..!

Thanks and Regards,

Chandu.

Former Member
0 Kudos

<i>DBQ=C:\XI_FILES\RECEIVER\LIBRARY_DETAILS.mdb</i>

Make sure that...this database file (.mdb)should be placed in XI Server.

Former Member
0 Kudos

Hi Sekhar,

I have created the .mdb in my xi server itself.

Even i am still facing the problem.

Let me know what else i need to set up?

Thanks and Regardds,

Chandu.