ASP.Net C# ODBC username password
Posted on 2012-04-10
Hey folks. I have been working with a connection to a IBM AS400 DB2 database ODBC conneciton on a local host in an ASP.NET C# web project... and it working fine due to the ODBC connection using my windows authenication.
When I pusblish my project to the sever, when the DataSet is called it errors with...
ERROR  [IBM][System i Access ODBC Driver]Communication link failure. comm rc=8015 - CWBSY1006 - User ID is invalid, Password length = 0, Prompt Mode = Never, System IP Address = MyIPAddress
I am assuming it has no username and or password... how do I give it one? Is this set up through the ODBC Connection or is it passed in the code or is there a better way.
I HAVE to use an ODBC connection due to the mainframe database.
I am a newb when it comes to ASP.NET and C# so please help with a code example.
<add name="ConnectionString" connectionString="DSN=AS400TestPLTX;"
above is the code... can I enter UID = MyUserID and PWD=$@#$... if so what is the syntax.