This is the relevant code:
private void btnLoad_Click(object sender, EventArgs e)
{
PhoenixWrapper phxConnection = new PhoenixWrapper();
string bctConnProps = PhoenixWrapper.GetConnecti
onString()
;
SqlConnection cnn = new SqlConnection(bctConnProps
); - GETTING ERROR HERE!!!
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT VIEW_NAME FROM ENDORSEMENT_VIEWS";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "ENDORSEMENT_VIEWS");
dgProducts.DataSource = ds;
dgProducts.DataMember = "ENDORSEMENT_VIEWS";
}
}
When I click the button btnLoad, it is giving the following error:
Keyword not supported: driver
When I debug the code, I am getting the following:
Cnn = null
bctConnProps "driver={SQL Server};server=HMWBPRDDB1;
database=H
MWDEV;uid=
PHXADM;pwd
=PHOENIXDI
;dsn=Phoen
ix Desktop;" string
Please help,
Thanks
JD
Start Free Trial
