samedi 9 mai 2015

connecting to local database (sql server ) in c++

I am new to database connection in sql server using c++. Here I am trying to connect to localdb instance which I created in my sqlserver management studio, and the name of database is "filingdb", server is "(localdb)\filing". I copied the code from some other site and trying to query, the problem which I am facing is here as I have shared the error list:

Error   8   error C2440: '=' : cannot convert from 'System::Data::SqlClient::SqlCommandBuilder *' to 'System::Data::SqlClient::SqlCommandBuilder ^' 143 1   cvtest
Error   6   error C2440: '=' : cannot convert from 'System::Data::SqlClient::SqlDataAdapter *' to 'System::Data::SqlClient::SqlDataAdapter ^'   139 1   cvtest
Error   4   error C2440: 'initializing' : cannot convert from 'System::Data::DataSet *' to 'System::Data::DataSet ^'    126 1   cvtest
Error   2   error C2440: 'initializing' : cannot convert from 'System::Data::SqlClient::SqlConnection *' to 'System::Data::SqlClient::SqlConnection ^'  125 1   cvtest
Error   3   error C2750: 'System::Data::DataSet' : cannot use 'new' on the reference type; use 'gcnew' instead  126 1   cvtest

'System::Data::SqlClient::SqlCommandBuilder *' this is the major issue which iam facing

I have tried other way too, but I am but still getting the same problem

Error   12  error C2440: '=' : cannot convert from 'System::Data::SqlClient::SqlCommandBuilder *' to 'System::Data::SqlClient::SqlCommandBuilder ^' 140 1   cvtest
Error   10  error C2440: '=' : cannot convert from 'System::Data::SqlClient::SqlDataAdapter *' to 'System::Data::SqlClient::SqlDataAdapter ^'   136 1   cvtest
Error   6   error C2440: 'initializing' : cannot convert from 'System::Data::DataSet *' to 'System::Data::DataSet ^'    126 1   cvtest
Error   3   error C2440: 'initializing' : cannot convert from 'System::Data::SqlClient::SqlConnection *' to 'System::Data::SqlClient::SqlConnection ^'  125 1   cvtest
Error   5   error C2750: 'System::Data::DataSet' : cannot use 'new' on the reference type; use 'gcnew' instead  126 1   cvtest
Error   11  error C2750: 'System::Data::SqlClient::SqlCommandBuilder' : cannot use 'new' on the reference type; use 'gcnew' instead 140 1   cvtest
Error   2   error C2750: 'System::Data::SqlClient::SqlConnection' : cannot use 'new' on the reference type; use 'gcnew' instead 125 1   cvtest
Error   9   error C2750: 'System::Data::SqlClient::SqlDataAdapter' : cannot use 'new' on the reference type; use 'gcnew' instead    136 1   cvtest

Can any one please offer advice on how to solve this problem, any other method of connection, and can any one suggest any good link for future use reg connecting db using sql server? Thanks in advance

Aucun commentaire:

Enregistrer un commentaire