on 04-24-2007 2:03 PM
Hi All,
I'm trying to insert records into the Access DB. My runtime is on AIX. the Access DB is on another windows server (MyWinServer). My Connection parameters are as follows:
JDBC Driver : <b>sun.jdbc.odbc.JdbcOdbcDriver</b>
Connection : <b>jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//MyWinServer/PACKLINE/newpackline.mdb</b>
But i'm getting the following error:
Attempt to establish database connection failed with SQL error com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//MyWinServer/PACKLINE/newpackline.mdb': java.lang.NullPointerException
I tried even with replacing the MyWinServer with the IP address of the windows server. I had also gone through the following URL which has the MDB file locally on XI Server.
<a href="/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn:///people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
Please can anybody help in fixing this issue as it is high priority for my development. I have seen the threads on this but no thread lists the solution.
Any help wud b highly apprecited.
Thnx in Advance.
Anil
HI,
Also see the below
Have deployed correc drivers ..
see also below...
And deploy the JDBC drivers see below
Deploying and Removing JDBC Drivers
http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/content.htm
see in the below link for JDBC driver deployment details
Regards
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandra shekhar,
The notes which u were talking about are not related to this question.
929640 - Talks about the Sender Adapter (In My Case Reciever).
877271 - Talks about null pointer during connection.close() which is far beyond our discussion. I'm not able to establish the connection in the first place.
Thnx
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi chandra shekhar,
Thnx for ur reply. but i had already mentioned that i had seen these threads which doesnt have the solution. if you hav look at the last reply on the thread which u had pasted, u will come to know that it is mine and it is talking abt the same issue. There is no point in pasting the same thing again.
Regards
Anil
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.