What is the DB2 Provider in connectionstring of MVC web app? RRS feed

  • Question

  • User-1651604128 posted

    Hi, I am trying to connect DB2 database,

    in connectionstring I used this format:

    string connString = @"provider = IBMDADB2.1;persist security info = false;data source = sample;";

    so in my case, I have something like this:

    string connectionString = @"provider = IBMDADB2;Server=DBDEV:60000;Database=DBPROD001;UID=jondoe;Pwd=blahblah;";

    Here, I do not know how to input the value for "provider" above, so the connection was failed.

    How where can I find the provider? is it a DB2 driver I should download and import it to my asp.net MVC app?

    or it is the db2 version I can query from my DB2 database and used here? thanks

    Sunday, January 31, 2016 3:50 AM

All replies