ODBC Connection to Ms Access

[imfarhan]

Hi All,

I've got the Ms Access (2003)database "Test.mdb",
I've created the ODBC connection using following steps
1. SystemDSN
2. Ms Access (Select from the list)
3. Add | Data Source Name = 'Test_Conn'
4. Select Database (Test.mdb)
Now on Parallel Job ,
1. ODBC Connector
2. Datasourec from choose the 'Test_Conn'
3. Select * from Test_tbl
error

Code: Select all

 " ODBC Connection SQL Connect reported SQL State Msg [Microsoft][ODBC Microsoft Driver] System Resourece Exceeded"

Appreciate your help

[chulett]

I didn't look any further than doing a google search for "system resource exceeded" but it did bring up quite a number of topics on the subject. Probably some good information out there for you...

[imfarhan]

Thanks for your reply ,
But its not even connect , when I first tried to use 'Test' button on Properties|Connection|DataSource (Test option or rigth top)

[imfarhan]

Hi All,

Only thing I think of is, the server where the database dump kept has no Ms Access(Ms Office) software.

But , the connection was made successfully last week. and today same error and I haven't change anything since last week

Appreciate your help!
Regards
Farhan

[chulett]

With no Access installed this would have never worked. Did you ever do the google search I suggested?

[ray.wurlod]

But , the connection was made successfully last week. and today same error and I haven't change anything since last week.

Something has changed since last week. You have to do some detective work to find out what it is, particularly if it was not you who made the change.

[imfarhan]

Spoke to IBM they won't recommend to use connection on MS Access.
So I've to export/download the table output into CSV and then use the csv files to work through in my ETL Datastage Job.

I will post once I will any success.
Kind regards,
Farhan