topic Re: [resolved] TIS 304 (64bit) and MS Access Data input Component in Talend Studio

[resolved] TIS 304 (64bit) and MS Access Data input Component

JimmyM — Sat, 16 Nov 2024 13:42:27 GMT

I have a job built in TIS 3.0.4 (32bit executable). I've since moved to a 64-bit OS and started to use
Initial conditions:
Vista64, using TIS 3.0.4_64, Java 1.6 x64.
When I open the Job and try to preview data for a MS Access Input component it get an error.
-----
Connection failure. You must change the Database Settings.
Data source name not found and no default driver specified
-----
The path to the MS Access MDB file is correct. This Job used to work.
Changed to...
Vista64, TIS 3.0.4(32bit), Java 1.6 (32bit)
Job opens and runs just fine in Talend.
I'm guessing that Talend/Java (x64) is having an issue using the MS Access ODBC driver.
Is there some way to use the 64-bit versions and still get the job to be able to pull data from the MS Access DB?
Also, will exported jobs built in 64-bit Talend/Java execute on 32 bit systems?
Thanks for your time.

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

Anonymous — Mon, 02 Nov 2009 06:13:54 GMT

Hello
It looks we still need to use the 32bit odbc driver: odbcad32.exe, see article.
Best regards

shong

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

JimmyM — Mon, 02 Nov 2009 12:05:34 GMT

That's the way it looks. I was doing some research regarding 64bit apps and 32bit ODBC drivers in general. The odbcad32.exe in the WOW64 folder is for the admin of 32bit ODBC drivers while the ODBC administrator found in Admin Tools is for 64bit ones. A real pain just for one ODBC driver. But I guess such is the state of 64bit applications right now. I wonder if Microsoft will ever make a 64bit MDAC pack.

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

JimmyM — Thu, 11 Mar 2010 15:47:41 GMT

Also, will exported jobs built in 64-bit Talend/Java execute on 32 bit systems?
Thanks for your time.

Per my previous post,
If I'm running Talend x64 and have a 64bit Java JRE selected (jdk1.6.0_17) in Preferences->Java->Installed JREs, will the compiled and exported Jobs run on a 32-bit system?

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

Anonymous — Fri, 12 Mar 2010 03:01:01 GMT

Hello

If I'm running Talend x64 and have a 64bit Java JRE selected (jdk1.6.0_17) in Preferences->Java->Installed JREs, will the compiled and exported Jobs run on a 32-bit system?

Yes, both the two ways of export the job script and export the job item works on a 32-bit system.
Best regards
Shong

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

JimmyM — Fri, 12 Mar 2010 18:59:38 GMT

Hello

If I'm running Talend x64 and have a 64bit Java JRE selected (jdk1.6.0_17) in Preferences->Java->Installed JREs, will the compiled and exported Jobs run on a 32-bit system?

Yes, both the two ways of export the job script and export the job item works on a 32-bit system.
Best regards
Shong

Excellent. Thanks for the reply.

Re: [resolved] TIS 304 (64bit) and MS Access Data input Component

Anonymous — Thu, 22 Apr 2010 16:48:10 GMT

Sorry for being dense, but how do I set talend up to use the 32-bit driver? I can interact with Access 2003 databse through the repository, but if I just drag a taccessoutput component the designer, I cant use SQL Builder.