on 12-02-2010 6:22 PM
Hi,
I have a requirement, Where I have to Pick Data from MS-ACCESS DB. and I dont have any Idea . How to Do that ?
Please show me the path.?
MY MS-ACCESS 2007 is on Windows OS Based Machine.
MY PI 7.01 System is also on Windows OS Based Machine.
What Connection Need to be maintained ?
What Drivers Need to be deploy?
Please provide me step by step approach from scretch .....
Regards
PS
Check with Basis person for availability/installation of JDBC driver.
For configuration check this link::
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
based on above blogs i have prepared Sender CC for MS-ACCESS JDBC ..
Driver jdbc.odbc.JdbcOdbcDriver
Connection jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=
10.0.3.169\msaccess\Students.accdb
I have not installed any drivers explicitly ...
I am getting this error
Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.accdb)};DBQ=
10.0.3.169\msaccess\Students.accdb' using the JDBC driver 'jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.accdb)};DBQ=
10.0.3.169\msaccess\Students.accdb': SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver'
You can download this driver from here
http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html
the connection URL is fine
regards
Ninad
Still Stucked .................
No solution ...
Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//10.0.3.169/test.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//10.0.3.169/test.mdb': SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'
I am getting this error now ...
I created a java on MY PC and Same PC has .mdb file ... So my java program is able to connect to that .mdb file without any Drivers and DNS Creation ...
I am Still wondring what to do ????????????/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
MS access might be already available in your pc, so you are able to connect access db via your java client program easilyl. Here we have to check few things
1) PI 7.1 is a 64 bit version. So you have to check with basis guys whether you have ms access drivers that supports 64 bit.
2) Even extra space hand jam in the adapter configuration area might cause this type of error.
3) I have tried in PI 7.0 version and no issues.
4) Since Java is case sensitive , Please provide the parameters such as Driver class names etc carefully.
5) If your driver installation is already done, create database in the local drive path of PI and test first.
Thanks
Baskar
Hi JavaGuy ,,
Thanks for your valuable comments ....
Even I am working on PI 7.0 Installed on MS OS .
So U have successfuly worked with MS Acces on PI7.0
Can u check with your basis guy ,and let me the driver .. name or if you can send me the drivers jar file ..which i can directly use ..
I will be very helpful.
Regards
PS
Since your OS is Microsoft , You dont need to install drivers for MS access. Your PI can directly connect to MS access database which is running at OS level.
You get all the required information using below link.
and
http://www.riyaz.net/blog/jdbc-adapter-configuration/technology/1200/
If you need further information, Please let me know.
Hi,
I am facing a similar issue in our scenario.
I checked all the blogs and still facing the problem.
These are my connection details:
Driver : jdbc.odbc.JdbcOdbcDriver
Connection: jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//pid/Nagasatya/pitest.mdb*
Still I am getting this SQLException: MicrosoftODBC Driver Manager Data source name not found and no default driver specified' error.
How to resolve this issue?
Any help would be greatly appreciated.
Regards.
Edited by: Nagasatya Devarakonda on Jan 20, 2011 11:30 AM
Hi,
You need to do the following things
a) Check whether the jdbc driver is installed. if not do it.
b) Since you are going to read data from the ms access, you have to use jdbc sender adapter.
c) Use this link for sender adapter
http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm
d) Sample data type on the source side. Depending on the requirement go for 1 to many.
<resultset>
<row> (1 to unbounded) example
<column-name1>column-value</ column-name1>
<column-name2>column-value</ column-name2>
<column-name3>column-value</ column-name3>
</row>
</resultset>
e) you could also configure sender jdbc adapter using automatic time planning to trigger the read call from db as per requirement. If you need more, go to RWB-> Jdbc sender comm channel and set the time planning as per your need.
I have done this scenario before. If you have any issues, let us know.
Thanks
Baskar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Heyy,
Check this
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.