on 05-22-2013 12:24 PM
Hi All ,
We are trying to access a MS Access(2010) db file i.e test.accdb file from Sender JDBC Adapter .
We are placing the file in PI Local server
We are giving the path in connection(In Sender JDBC Adapter) as below
jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb
But we are not able to access the file
We are getting the following error in channel
Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb 'using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. : SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified'
Could any one please let us know how to proceed with the issue
Thanks
Swathi
Hi Swathi,
There is some problem with the drivers.. also check is there any firewalls..
Refer below links
http://scn.sap.com/thread/1285628
http://scn.sap.com/message/6398135
Hope it will helpful..
Regards
Bhargava krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhargav
MY PI Server in an unix server....how should i check whether the driver for MS Access is installed or not??because am getting error as below
sun.jdbc.odbc.JdbcOdbcDriver returns: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. : SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified'
Thnks
Swathi
Hi Swathi,
we have to install the correct version to establish connection to the database. so check the D.B version and download the drivers which is supported by that version..
Inform basis team, to look into that, pi developer is not responsible for that..
Link for JDBC drivers (MS-Access DB)
http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html
For deploying JDBC drivers
For Driver not found issues
Hope it will helpful..
Regards
Bhargava krishna
Hi ,
Have you deployed the JDBC drivers ?
you can try check with this as well.
http://host:port/ftp-jdbc --> connection test.
Regards,
Loordh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi swathi
Looks like somthing wrong with the connections string. pls double check the CC parameters
Rgds
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swathi,
Try with file extension testaccdb.mdb ( Microsoft database ) in
jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb
make sure same DB should be created in in your system.
go through below link in detail reference.
http://www.sappi.sapag.co.in/jdbc2-jdbc-sap-xi-senario/jdbc-2-jdbc-step-by-step-guide/
Thanks ,
Naga
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.