topic Re: TAccessInput - Access Databases 97 - 2000 in Talend Studio

TAccessInput - Access Databases 97 - 2000

_AnonymousUser — Sat, 16 Nov 2024 14:23:24 GMT

Hello,
I have just noticed that the tAccessInput component does not allow to affect Access database created with MS ACCESS 97 or 2000.
Big negative point of Talend because in many companies, we still use the Microsoft Pack office 2000 or 97 and worse, it arranges bases Access 97or 2000.
Here is for the info
Otherwise the developpeurs of Talend can you inform me?
Thank you in advance

Re: TAccessInput - Access Databases 97 - 2000

Anonymous — Fri, 25 Apr 2008 06:50:34 GMT

Hello
I have tried to connect MS ACCESS 2000 with TOS2.4.0M2 and the job works fine.
Which version of TOS are you using?
Best regards
shong

Re: TAccessInput - Access Databases 97 - 2000

_AnonymousUser — Fri, 25 Apr 2008 10:07:07 GMT

I use TOS-All-r12707-V2.3.2

Re: TAccessInput - Access Databases 97 - 2000

Anonymous — Fri, 25 Apr 2008 23:48:15 GMT

I can confirm that tAccess components are compatible with 2000 / 2003
I did'nt try on 97.
Can you add details on yhour problem ?

Re: TAccessInput - Access Databases 97 - 2000

_AnonymousUser — Tue, 29 Apr 2008 15:58:02 GMT

Hello,
In my company, there are different database which implement with MS Access 97. So for integration, i use TOS 2.3.2.
But when i use the componment TAccessInput to make the connection with database, i have an error!!!!!

Re: TAccessInput - Access Databases 97 - 2000

Anonymous — Tue, 29 Apr 2008 21:40:09 GMT

Please add your detailed error message.
Thanks

Re: TAccessInput - Access Databases 97 - 2000

_AnonymousUser — Wed, 30 Apr 2008 14:28:16 GMT

Error Message : Database connection is failed.

Re: TAccessInput - Access Databases 97 - 2000

Anonymous — Mon, 05 May 2008 03:17:52 GMT

Hello Rgent
I also checked that TOS2.3.2 can connect to Access 97.
Can you try your connection on Metadata part? Can you upload a screenshot of your tAccessInput setting?
Best regards
shong

Re: TAccessInput - Access Databases 97 - 2000

Anonymous — Mon, 05 May 2008 08:56:35 GMT

I use TAccessInput in TOS 2.3.2 on Access 97 database and the job is ok i don't have any problem.
I don't use particular features.