error when connecting to DB2 data via IBM OLEDB using ASP.net
Posted on 2011-02-20
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.
<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.