i want to store my data in db2 instead of sqlserver. how to connect my asp application to db2 database.
and also give a simple example to retrive a data from db2 database . will i have to create another server for this or not .
http://www.codeproject.com/Articles/4870/Connect-to-DB2-from-Microsoft-NET
http://www.codeproject.com/Articles/26344/Connection-to-DB2-from-NET
http://www.ibm.com/developerworks/data/library/techarticle/0307swart/0307swart.html
http://www.ibm.com/developerworks/data/library/techarticle/0306stephens/0306stephens.html
Hi,
Make change in "Connection String" from sqlserver to DB2. It is better to add a new connection (DB2) to the "server explorer" in Visual Studio to get a proper "Connection String".
Use "OleDB" Objects instead of SQL objects.