MS Access DB as Source

[raj4Informatica]

Hello,
I am trying to read the data from the MS Access Table in Informatica version 5.1,but my session fails and gives the error LMN_1046,In the DataBase connection, I have key in the foollowing parameter and I have a doubt on one parameter which seems to be causing this issue, The following parameter I have given in the Database Connection in the Server Manager---> Server Configuration.

DataBase Type--->ODBC ( as I have created ODBC DSN for Access db)
DataSource--> RowTrans (DSN Name)
username--> user
password---->user
Connect String---> RowTrans ( DSN Name, the real question is what will be the connect string for MS Access,which seems to be causing this issue)


The error which I get when runs the seesion is

***********************************
READER_1_1_1> DBG_21438 Reader: Source is [RowTrans], user [user]
READER_1_1_1> Wed Sep 17 15:31:34 2003
READER_1_1_1> CMN_1046 ODBC Error
CMN_1046 [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
READER_1_1_1> Wed Sep 17 15:31:34 2003
READER_1_1_1> CMN_1046 ODBC Error
CMN_1046 []
READER_1_1_1> Wed Sep 17 15:31:34 2003
READER_1_1_1> RR_4036 Error connecting to database [].
READER_1_1_1> Wed Sep 17 15:31:34 2003
READER_1_1_1> BLKR_16001 Error connecting to database...
BLKR_16001 [Session DebugSession_NEWMAPPING28 Username user]

**********************************************************

I will appreciate if some one has come accross this problem otr some one has used the MS Access, Please send me the suggestion, Once again the Informatica version which I am using is 5.1

Thanks in Advance.

Raj

 

[raj4Informatica]

I got this solved, actually my .mdb file was not on Informatica server m/c, i think it is supposed to be at Informatica server.