One Star

Microsoft Access JDBC/ODBC-Driver problems

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/...) 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:
"jdbcSmiley SurpriseddbcSmiley Very Happyriver={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.
7 REPLIES
Community Manager

Re: Microsoft Access JDBC/ODBC-Driver problems

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: Microsoft Access JDBC/ODBC-Driver problems

Try to launch the 32 bit version of TOS.
One Star

Re: Microsoft Access JDBC/ODBC-Driver problems

@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.
Community Manager

Re: Microsoft Access JDBC/ODBC-Driver problems

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-8...
And for interesst: Are they any free Linux Access driver available?

yes, I had installed successfully ODBC driver on Linux, see
http://www.talendforge.org/forum/viewtopic.php?id=9389
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Microsoft Access JDBC/ODBC-Driver problems

Thank you very much!

Re: Microsoft Access JDBC/ODBC-Driver problems

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.
One Star

Re: Microsoft Access JDBC/ODBC-Driver problems

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