topic Re: DB connection for ACCESS in Talend Studio

DB connection for ACCESS

Anonymous — Wed, 05 Jun 2013 15:12:25 GMT

I am trying to make a job to pull data from an access db and puch it to SQL. the issue i am having is trying to create a new db connection to the access db. i am getting an error that {ODBC Driver Manager] Data source name not found and no defualt driver specified. Can some one please help me through this? I have attaced a picture with the error and connection string.
Thanks in advance

Re: DB connection for ACCESS

Anonymous — Thu, 06 Jun 2013 04:22:37 GMT

Hi,
Which talend version are you using? The file uploaded is all right?
Best regards
Sabrina

Re: DB connection for ACCESS

Anonymous — Thu, 06 Jun 2013 13:47:15 GMT

we are running 5.2.2 and the file path and file is good

Re: DB connection for ACCESS

Anonymous — Fri, 07 Jun 2013 09:15:59 GMT

Hi,
Did you install "MS Access Database Driver(*.mdb, *accdb)"? If not, Please check your ODBC Data Source Administrator to add one from website.
Best regards
Sabrina

Re: DB connection for ACCESS

_AnonymousUser — Wed, 31 Jul 2013 12:13:21 GMT

Hi,

I'm using version 5.3 and have the same issue.
Where can I find & install this driver exactly?

Thanx,
Christoph

Re: DB connection for ACCESS

Anonymous — Thu, 01 Aug 2013 04:00:11 GMT

Hi,
You can search for it from Microsoft official website http://www.microsoft.com/en-us/download/details.aspx?id=23734
Best regards
Sabrina

Re: DB connection for ACCESS

_AnonymousUser — Fri, 09 Aug 2013 09:47:20 GMT

Hi,

I've installed the 2010 driver (office/access 2010), but still same error when trying to connect to an *.mdb
URL for download: http://www.microsoft.com/en-us/download/details.aspx?id=13255
-> I took the "AccessDatabaseEngine.exe", not the "AccessDatabaseEngine_x64.exe", cause that one asked to reinstall my office completely.

Any ideas?
Should I change anything in the preferences under Talend>Data Explorer>JDBC drivers?

Thanx,
Christoph

Re: DB connection for ACCESS

Anonymous — Fri, 09 Aug 2013 11:06:56 GMT

Hi,

Should I change anything in the preferences under Talend>Data Explorer>JDBC drivers?

It is impossible to use jdbc to set up the DB connection.(MS ACCESS DB is odbc connection)
What's your OS? Win7 64bit? 32-bit-odbc-driver-for-ms-access-2010-accdb-is-missing-in-win7-64bit
Best regards
Sabrina

Re: DB connection for ACCESS

_AnonymousUser — Fri, 09 Aug 2013 14:08:34 GMT

Hi,

My OS is win7, 32 bit.
Indeed - it would have been great to have an odbc connection as part of the default db-connections ;-).
Christoph

Re: DB connection for ACCESS

Anonymous — Mon, 12 Aug 2013 07:39:57 GMT

Hi,
I have made a testing on Office 2007, everything is OK. Is the MS Access Database Driver still unavailable in your ODBC Data Source Administrator?
There is a jira bug https://jira.talendforge.org/browse/TDI-8995, but it is not new. I will make an investigation on it(office 2010) and come back to you asap.
Best regards
Sabrina