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,NU LL ))

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

[Lionel B]

On Tue, 01 May 2007 14:43:43 +0200, karol1208 wrote:

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-lit...t.html#faq-5.9

[...]

--
Lionel B

[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,NU LL ))

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?

--
OU

[karol1208]

On Tue, 01 May 2007 15:46:29 +0200, Obnoxious User <OU@127.0.0.1>
wrote:

>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.