how to connect sql server database in C++ code?

Question

I have a project of C++ windows form. Now, I want to store the data in my SQL server database. So, how can I connect my database from inside my C++ code and how to write an insert query?

I used the following code but it throws an exception that cannot open or cannot found the database.

SqlConnection^ con = gcnew SqlConnection();
int i = 0;  

con->ConnectionString = "Data Source=122.179.151.229\EIEXPRESS;Initial Catalog=ICAST_IMS;Uid=developer;pwd=dev@12345";
con->Open();

SqlCommand^ com = gcnew SqlCommand();
com->Connection = con;
com->CommandText = "INSERT INTO image_analysis (nodule_count, nodularity) VALUES (final_nodule_count, 'final_nodularity')";
com->ExecuteNonQuery();

Once you get the connection string issue sorted out you are going to find an error in your insert statement also. You are trying to insert final_nodule_count but what is that? It will fail with an invalid column name final_nodule_count — Sean Lange
– Sean Lange, Commented Jun 13, 2019 at 15:06

Marvin García · Accepted Answer · 2019-06-13 15:00:29Z

2

I think your problem it's your connection string, you include an "\" which is a special character, you need to try doing "\\" so the system recognize you're inserting an "\".

Hope this helps you!

answered Jun 13, 2019 at 15:00

Marvin García

487 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marvin García Over a year ago

This is an ex. of a connection I made "Password=1234;Persist Security Info=True;User ID=sa;Initial Catalog=Entrecom;Data Source=LAPTOP-B2CORTSA\\SQLEXPRESS"... but i see now that u solved your problem, that's nice :)

Collectives™ on Stack Overflow

how to connect sql server database in C++ code?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related