You are not logged in.
We recently upgraded to 5.1.1 and have the same issue connecting to Access databases. Previous install was fine but the upgrade installation can not connect to Access. The Drivers are installed and we set up in metadata repository but still get errors.
Has anyone resolved this? what is the trick?
Any help is appreciated. Running on Windows 7 64 bit for TOS, Windows Server 64Bit for TAC Jobserver.
Kind of new to Talend so please let me know if you need more info. Any help is appreciated.
Have you guys tried downloading the Microsoft Access Engine? It's like a runtime for Access ... erm ... access.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Hi, All !
I have the same problem as above, when I trying to create new DB connection in Metadata for MS Access 2007.
I'm working with :
Win 7 64
Talend Open Studio for MDM; Version: 5.0.2; Build id: r78327-20120216-0346
best regards and wishes
I had problems with tAccessOutput and in my case it was a problem with 64 and 32 bit java executables. Played around with different settings (couldn't make it run with java version I wanted) and finally uninstalled all 64bit versions of Java and left only 32bit versions.
Of course I used 32bit versions of ODBC drivers and 32bit version of Talend on my Win7 64bit
ALWAYS backup your workspace before doing an upgrade!
http://www.talend.com/download_form.php … c=HomePage
Please send to me link to download TOS 5.0.2
Here is an issue [tAccessInput Faillure Invalid string or buffer length] on BugTraker.
Try to update TOS from 4.2.3 to 5.0.2.
Now i use Windows 7 with 64Bit OS . After this, i was used Talend 4.2.3 in 32 Bit OS, its does't errors . How i want to resolved this problems and all data can be proceed update one table into the Oracle database .
If your know, i have 250 thousand record to iupdate selected field into the database . Now i just load a little bit source data . Mean 828 record. Can you tell me what i can do to run this job?
How to setup limited update record?
Which OS do you use?
This issue is always caused by Window Server 64bit.
I'm afraid it's a bug.
Now i can use talend 4.2.3 in OS 64 Bit in my computer . But when we run job to update data into the database its error was appeared . I can't run source data more than 828 record . How we want run to process the data overall?
Why the data limit update is 828 record only .
Exception in component tAccessInput_1
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
Did you configure username and password for Access2007?
I also tried with absolute file path but it's the same..
To create a metadata->DB Connection is more simple for users who may be not familiar with TOS.
You'd better use absolute file path in metadata(e.g. D:/My Documents/Database1.accdb).