connect to db2 database

Question

User1122836778 posted

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 .

Answer 1

User-1822989843 posted

how to connect my asp application to db2 database.

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

Answer 2

User-306750178 posted

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.