Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

Amy
2013-02-11 21:13:27

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.

Thanks,
Amy

Cavan Lee Sears
2012-05-29 05:45:32

Have you guys tried downloading the Microsoft Access Engine?  It's like a runtime for Access ... erm ... access.

qMax
2012-04-30 00:19:02

wani0102 wrote:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
tq

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

TOS_MDM-win-x86_64.exe
Talend Open Studio for MDM; Version: 5.0.2; Build id: r78327-20120216-0346

best regards and wishes

sdupor
2012-04-11 00:00:07

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

JohnGarrettMartin
2012-02-24 16:36:19

ALWAYS backup your workspace before doing an upgrade!

pedro
2012-02-24 09:21:58

Hi

It's here.
http://www.talend.com/download_form.php … c=HomePage

Regards,
Pedro

wani0102
2012-02-24 09:20:36

Please send to me link to download TOS 5.0.2

TQ

pedro
2012-02-24 05:59:41

Hi

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.

Regards,
Pedro

wani0102
2012-02-24 04:58:48

Hi ,

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?

pedro
2012-02-24 04:12:26

Hi

Which OS do you use?
This issue is always caused by Window Server 64bit.
I'm afraid it's a bug.

Regards,
Pedro

wani0102
2012-02-24 03:44:23

Hi Pedro,

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 .

example :

Exception in component tAccessInput_1
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

pedro
2012-02-23 09:10:25

Hi

Did you configure username and password for Access2007?

Regards,
Pedro

vittirivizzik
2012-02-23 09:07:34

Hi Pedro,

I also tried with absolute file path but it's the same..

Best regards

pedro
2012-02-23 06:11:11

Hi wani0102

To create a metadata->DB Connection is more simple for users who may be not familiar with TOS.

Regards,
Pedro

pedro
2012-02-23 06:09:22

Hi vittirivizzik

You'd better use absolute file path in metadata(e.g. D:/My Documents/Database1.accdb).

Regards,
Pedro

Board footer

Powered by FluxBB