Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JimmyM
Contributor
Contributor
‎2009-10-30 05:00 PM

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

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.
Labels (3)
Labels
257 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2010-03-11 10:01 PM

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

View solution in original post

257 Views
0 Likes
6 Replies
Anonymous
Not applicable
‎2009-11-02 01:13 AM

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

shong
257 Views
0 Likes
JimmyM
Contributor
Contributor
‎2009-11-02 07:05 AM
Author

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.
257 Views
0 Likes
JimmyM
Contributor
Contributor
‎2010-03-11 10:47 AM
Author

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?
257 Views
0 Likes
Anonymous
Not applicable
‎2010-03-11 10:01 PM

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
258 Views
0 Likes
JimmyM
Contributor
Contributor
‎2010-03-12 01:59 PM
Author

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.
257 Views
0 Likes
Anonymous
Not applicable
‎2010-04-22 12:48 PM

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.
257 Views
0 Likes