By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

Connect string name

P: 1
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:\Ayyappa_Works\Sample\work.mdb;Mode=ReadW rite;

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@gmail.com

Thanks & Regards,
Ayyappa
Oct 30 '06 #1
Share this Question
Share on Google+
3 Replies


pks00
Expert 100+
P: 280
Wild guess here

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

Do the tables u are referencing exist?
Oct 30 '06 #2

pks00
Expert 100+
P: 280
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
Oct 30 '06 #3

NeoPa
Expert Mod 15k+
P: 31,426
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.
Oct 30 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.