on 04-17-2008 9:35 AM
HI,
I'm doing file to jdbc scenario.
I gave the connection path as
{Microsoft Access Driver(*.mdb)};DBQ=//hstxid/XITEST1/file2jdbc/rec.mdb
In Runtime workbench it is giving the error as
Attempt to establish database connection failed with SQL error Unable to locate a suitable JDBC driver to establish a connection to URL '{Microsoft Access Driver(*.mdb)};DBQ=//hstxid/XITEST1/file2jdbc/rec.mdb'
Delivery of the message to the application using connection AFW failed, due to: Database connection could not be established.
Can u please tell me if the error is in creating the table in MSAccess or anyother , as the structure of the table is same as i have given in xi.
hi
first of all install the drivers in the system..then it will locate the drivers..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for providing me the information for installing jdbc drivers.
Divya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
First of all you do not need to install any drivers for MS Access and then check your connection path.
Regards
Monika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
first deploy JDBC driver provided by your vendor
athen check your data base connection you must have admin rights for this
Then you wil be able to connect to your data base
regards
sandeep
If helpful reward points
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check if any user Authentication required to access the Ms access table
try this
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb;Uid=yourid;Pwd=yourpwd;
Also check whether your mdb file is on same host. If it might e on different host it may unable to connect.
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
To install JDBC driver follow the how to guide.
We have to mention the following details in case of Ms-Access-XI
URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/XI/Workspace/xi_input.mdb
Jdbc Driver: jdbc.odbc.JdbcOdbcDriver
or
URL: jdbc:odbc:<DSN Name>
Jdbc Driver :sun.jdbc.obc.JdbcOdbcDriver
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.