on 11-28-2011 5:37 AM
Hi All,
I have a file to jdbc scenario.
PI 7.0 is installed on Windows...
I have created a table T1.mdb on the server iitself..
I am unable to connect..
Pls share ur thoughts..
Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:\usr\sap\trans\T1.mdb' 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: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. : SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'
hi,
did you upload database driver into PI? because it seems it's not the case?
See this SAP help: [Providing External Drivers for the JDBC and JMS Adapters|http://help.sap.com/saphelp_nwpi711/helpdata/en/48/cafc972fbb5c97e10000000a42189d/frameset.htm].
regards.
Mickael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is unable to connect to the DB Server.
Please check if you are using the correct JDBC driver and correct connection parameters.
If not then contact your basis team to provide the JDBC driver and connection parameters.
Regards,
Venkata Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Kindly, ask your basis team to check whether the Microsoft Access Driver is configured in PI server. If not ask them to configure.I think this is the reason for the error.
Regard's
Preethi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.