SQL query in C++

[karol1208]

I have problem with sending query (form C++ MFC program) to data base.
When i send query with "SELECT" everything is ok. But when I send the
one with "UPDATE" or "INSERT" I get exeption.
I use:

CDatabase::OpenEx

"DRIVER={SQL
Server};DATABASE=database;SERVER=server;UID=login;PWD=password"

OpenEx(pszDest, CDatabase::noOdbcDialog );

CMyRecordset.Open(CRecordset::dynaset,strQuery1,NULL ))

When I use SQL Manager with this same connection parameters (login,
password, server...) everything is ok.

 

[Lionel B]

I have problem with sending query (form C++ MFC program) to data base.

Your problem is off-topic here. Please see:

http://www.parashift.com/c++-faq-lite/how-to-post.html#faq-5.9

[...]

 

[Obnoxious User]

karol1208 skrev:

I have problem with sending query (form C++ MFC program) to data base.
When i send query with "SELECT" everything is ok. But when I send the
one with "UPDATE" or "INSERT" I get exeption.
I use:

CDatabase::OpenEx

"DRIVER={SQL
Server};DATABASE=database;SERVER=server;UID=login;PWD=password"

OpenEx(pszDest, CDatabase::noOdbcDialog );

CMyRecordset.Open(CRecordset::dynaset,strQuery1,NULL ))

When I use SQL Manager with this same connection parameters (login,
password, server...) everything is ok.

Ever bothered checking what the exception is telling you?

 

[karol1208]

Ever bothered checking what the exception is telling you?

I've try but I still get a "Microsoft Visual C++ Debug Lirary" Message
Error Box.