Talend community forum / can't connect to Access 2007 Database

vittirivizzik · 2012-02-20 09:39:08

Hello there,

I have a connexion problem. i can't connect to my Access Database. I selected the Database but when i checked the connection an error message appear : can't connect to database you should modifie your database parameter.
when i clicked on details : [Microsoft][Pilote ODBC Microsoft Access] Ressources système insuffisantes.

pedro · 2012-02-20 10:30:36

Hi

Which version of TOS do you use? Which OS?
I guess this is due to wrong configuration of Access connection.
Have you tried to create a DB metadata?

Regards,
Pedro

vittirivizzik · 2012-02-20 10:40:33

Hi Pedro,

thank you for having answered me
I use TOS-Win32-r67267-V4.2.3. OS = windows XP
I create DB metadata --> New connexion --> I chose Access 2007 database --> and i selected my Access database --> Click on Check --> Error message : can't connect to database you should modifie your database parameter.

Best Regards

vittirivizzik · 2012-02-22 09:46:03

??

wani0102 · 2012-02-22 10:04:17

Hi all,

Please help me to assist that problems

I use TOS-Win32-r67267-V4.2.3. OS = windows 7 64 bit OS , Although i have problems to run SQL when i use TInput Access .So how iwant to assist this problems and then i also cannot to insert attachment in forum to display error from me.

this error is below :

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

tq

Uploaded Images

Last edited by wani0102 (2012-02-23 04:16:51)

pedro · 2012-02-22 10:13:14

Hi All

Please upload a screenshot of your job.
Or show me the settings of tAccessInput.

Click "Edit" of your post.
Then you can upload image.

Regards,
Pedro

vittirivizzik · 2012-02-22 11:03:48

Hello there,

Please help me with my issue:

I experienced some issue wth Database connection . It's not working well most of the time the connection failed but from time to time the connection is successfull.

best Regards

Uploaded Images

wani0102 · 2012-02-23 04:54:55

Hello alls,

We run TalendOpenStudio-win32-x86_64 in my computer .Although, i have error to progress my job . Below is thi s error :

Uploaded Images

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

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

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 09:10:25

Hi

Did you configure username and password for Access2007?

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

Uploaded Images

Last edited by wani0102 (2012-02-24 03:45:34)

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 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 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 09:20:36

Please send to me link to download TOS 5.0.2

TQ

pedro · 2012-02-24 09:21:58

Hi

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

Regards,
Pedro

JohnGarrettMartin · 2012-02-24 16:36:19

ALWAYS backup your workspace before doing an upgrade!

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

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

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.

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

Announcement

Unanswered posts

#1 2012-02-20 09:39:08

can't connect to Access 2007 Database

#2 2012-02-20 10:30:36

Re: can't connect to Access 2007 Database

#3 2012-02-20 10:40:33

Re: can't connect to Access 2007 Database

#4 2012-02-22 09:46:03

Re: can't connect to Access 2007 Database

#5 2012-02-22 10:04:17

Re: can't connect to Access 2007 Database

#6 2012-02-22 10:13:14

Re: can't connect to Access 2007 Database

#7 2012-02-22 11:03:48

Re: can't connect to Access 2007 Database

#8 2012-02-23 04:54:55

Re: can't connect to Access 2007 Database

#9 2012-02-23 06:09:22

Re: can't connect to Access 2007 Database

#10 2012-02-23 06:11:11

Re: can't connect to Access 2007 Database

#11 2012-02-23 09:07:34

Re: can't connect to Access 2007 Database

#12 2012-02-23 09:10:25

Re: can't connect to Access 2007 Database

#13 2012-02-24 03:44:23

Re: can't connect to Access 2007 Database

#14 2012-02-24 04:12:26

Re: can't connect to Access 2007 Database

#15 2012-02-24 04:58:48

Re: can't connect to Access 2007 Database

#16 2012-02-24 05:59:41

Re: can't connect to Access 2007 Database

#17 2012-02-24 09:20:36

Re: can't connect to Access 2007 Database

#18 2012-02-24 09:21:58

Re: can't connect to Access 2007 Database

#19 2012-02-24 16:36:19

Re: can't connect to Access 2007 Database

#20 2012-04-11 00:00:07

Re: can't connect to Access 2007 Database

#21 2012-04-30 00:19:02

Re: can't connect to Access 2007 Database

wani0102 wrote:

#22 2012-05-29 05:45:32

Re: can't connect to Access 2007 Database

#23 2013-02-11 21:13:27

Re: can't connect to Access 2007 Database

Board footer