Connect string name

[ayyappa]

Hi All,

I am working on Informatica Designer using MS Access. Here, i have successfully accessed the data thru ODBC connection.

After creating session in Workflow Manager in Informatica, it has asked the following:

DB Type: ODBC

Username: myname

Password: mypwd

Connect String:Provider =Microsoft.Jet. OLEDB.4.0;Data Source=E:\Ayyap pa_Works\Sample \work.mdb;Mode= ReadWrite;

After passing all the above information, and run start workflow, i am getting the below error

CMN_1022 Database driver error...
CMN_1022 [
Invalid database license key

Please let me know the exact process how to connect MS Access in Workflow Manager - Informatica.

If any is having the screen shots please send the same to mnvsayyappa@gma il.com

Thanks & Regards,
Ayyappa

[pks00]

Wild guess here

Are you running any SQL against it? Have u checked the SQL is correct?

Do the tables u are referencing exist?

[pks00]

Another thing, can u see the database via ODBC?

I found this, I dont know if it will help u any
http://www.tek-tips.com/viewthread.cfm? qid=507713

[NeoPa]

Have you correctly installed and configured the Informatica ODBC driver on to your system?
From the error message, it sounds like it is not (correctly) installed.