error when connecting to DB2 data via IBM OLEDB using

I'm trying to connect to new database called TEST10 through and I'm getting the error: System.Data.OleDb.OleDbException: CLI0124E  Invalid argument value. SQLSTATE=HY009

The database I use to connect to was called TEST and that works without any errors.  Here is my web.config file.  The only change I made was calling the Data Source TEST_TMW10.  It was TEST_TMW.

from web.config....
            <add name="TEST_TMW" connectionString="Provider=IBMDADB2.DB2COPY1;Data Source=TEST_TMW10;Persist Security Info=True;Password=pppp;User ID=uuuu" providerName="System.Data.OleDb"/>

I have a Data Source in Windows ODBC called TEST_TMW10 and I can connect to it there using the connect button.

Any help would be greatly appreciated.

Steve Cross
Who is Participating?
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Hi  fairrington,

Some simple things to check:

 - Is the database set up to answer connections? (Can you connect with other tools)?
 - Is the database name unique in your network? (Do you have identical production and test databases)?
 - Are you connecting with the database name or alias name?  (Life will be easier in the long run if you connect via the alias name.

Good Luck,
fairringtonAuthor Commented:
Thanks for responding to my question. This morning when I tried connecting it worked, so I'm not sure why it was giving me the error yesterday.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.