Solved

error when connecting to DB2 data via IBM OLEDB using ASP.net

Posted on 2011-02-20
2
1,818 Views
Last Modified: 2012-05-11
I'm trying to connect to new database called TEST10 through ASP.net 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.

Thanks,
Steve Cross
Fairrington
0
Comment
Question by:fairrington
2 Comments
 
LVL 45

Accepted Solution

by:
Kdo earned 500 total points
Comment Utility
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,
Kent
0
 

Author Closing Comment

by:fairrington
Comment Utility
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.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Lync server 2013 Backup Service Error ID 4049 – After File Share Migration
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now