topic Re: Microsoft Access JDBC/ODBC-Driver problems in Talend Studio

Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Sat, 16 Nov 2024 12:53:10 GMT

Hey,
i have some issues with my Access Connection. On my developer machine my test job (in TOS) works fine. See Screenshot 1.
Environment:
Windows 7 - 64 Bit
Talend Open Studio 4.2.0
JDK: 1.6.240
Access: Only Runtime Environment (Version 2010) Microsoft Access Database Engine 2010 Redistributable
On the same machine, the exported job fails. See Screenshot 2.
Error Message:
Exception in component tAccessConnection_1
java.sql.SQLException: Data source name not found and no default driver specified.

My problem sounds similar to this ( http://community.talend.com:80/t5/Design-and-Development/Microsoft-Access-db-odbc-driver-issues/m-p/1984#M685) one, but all the tips doesn't work for me.
For my ODBC Conncetion (C:\Windows\SysWOW64\odbcad32.exe) see Screenshot 3. The User DSN is named "MS Access Database". In TOS the Database Connection is configured with this Connection string:
"jdbc dbc river={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=c:/windows/temp/controllingdb.accdb"
See Screenshot 4, too.

I have no idea about the problem. I hope someone has a solution.
Thanks a lot.

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Wed, 08 Jun 2011 04:55:48 GMT

Hi
You have configured a User DSN, try to use tDBInput/tDBOutput component replace tAccessxxx component. Let us know if you have the same problem.
Best regards
Shong

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Wed, 08 Jun 2011 08:11:30 GMT

Try to launch the 32 bit version of TOS.

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Wed, 08 Jun 2011 09:12:07 GMT

@emaxt6
Thank you. Thats the right hint!
I'm working with the 32 bit version of TOS, so the connection with the 32 bit ODBC driver was fine.
When I switch to the 64 bit version of TOS the connection fails with the same issue described above.
For the exported Job, I have to install a 64 bit ODBC driver or use a 32 bit JRE, right?
Did you know, if there is a 64 bit ODBC driver for Access available?
And for interesst: Are they any free Linux Access driver available?

@shong
No connection possible with the generic components. It seems, that the tDBInput dont know the User DSN.

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Wed, 08 Jun 2011 11:04:24 GMT

Hi
If you are on windows 7 64bit, you should launch the 64bit version of TOS.
Try to install access ODBC 64bit driver, for more information, please see:
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

And for interesst: Are they any free Linux Access driver available?

yes, I had installed successfully ODBC driver on Linux, see
https://community.talend.com/t5/Design-and-Development/Connect-to-MS-Access-DB-on-Linux/td-p/112156
Best regards
Shong

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Wed, 08 Jun 2011 13:19:13 GMT

Thank you very much!

Re: Microsoft Access JDBC/ODBC-Driver problems

Anonymous — Fri, 05 Oct 2012 01:48:06 GMT

found a solution to this.
in your .bat file.
change the path from "java" to the path in your 32 bit program folder.
"C:\Program Files (x86)\Java\jre7\bin\java.exe"
this will make it work.
see example below.
----------------
%~d0
cd %~dp0
"C:\Program Files (x86)\Java\jre7\bin\java.exe" -Xms256M -Xmx1024M -cp classpath.jar; push_accounts_to_winledge_0_1.Push_Accounts --context=Default %*
----------------------------------------------
this took me 2 days to figure out after trying to change environmental variables to try to run the 32bit version of java.

Re: Microsoft Access JDBC/ODBC-Driver problems

Jcs19 — Wed, 18 Jun 2014 13:11:38 GMT

found a solution to this.
in your .bat file.
change the path from "java" to the path in your 32 bit program folder.
"C:\Program Files (x86)\Java\jre7\bin\java.exe"
this will make it work.
see example below.
----------------
%~d0
cd %~dp0
"C:\Program Files (x86)\Java\jre7\bin\java.exe" -Xms256M -Xmx1024M -cp classpath.jar; push_accounts_to_winledge_0_1.Push_Accounts --context=Default %*
----------------------------------------------
this took me 2 days to figure out after trying to change environmental variables to try to run the 32bit version of java.

Thank you, it solved my problem !!!!!!!!!!!!!!!!!!!!!!!!!!!!"finally