Click here to Skip to main content
15,912,977 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Compression : Some new Idea. Pin
Prakash Nadar22-Apr-04 18:48
Prakash Nadar22-Apr-04 18:48 
GeneralObject serialization Pin
Peter Krankl22-Apr-04 2:39
sussPeter Krankl22-Apr-04 2:39 
GeneralRe: Object serialization Pin
hasansheik22-Apr-04 3:16
hasansheik22-Apr-04 3:16 
GeneralRe: Object serialization Pin
Peter Krankl22-Apr-04 3:38
sussPeter Krankl22-Apr-04 3:38 
GeneralRe: Object serialization Pin
Anonymous22-Apr-04 4:28
Anonymous22-Apr-04 4:28 
GeneralRe: Object serialization Pin
Peter Krankl22-Apr-04 4:55
sussPeter Krankl22-Apr-04 4:55 
GeneralRe: Object serializatio Pin
Peter Krankl22-Apr-04 4:56
sussPeter Krankl22-Apr-04 4:56 
GeneralMS-SQL and C++ Pin
andysmurfen22-Apr-04 2:17
andysmurfen22-Apr-04 2:17 
Hi everyone!Smile | :)

I am working with a connection to a MS-SQL server in C++ and use ADO. But I can not make it work like I want to!

I want to use SQL-statment in my code, and there are 2 statment I need, INSERT and UPDATE. I have tried my code with an ACCESS database it worked perfect. When I changed to MS-SQL it stopped when I try to INSERT. Update is not tryed yet.

Hope someone can help me with this, or have some examples...;)

My source is:

::CoInitialize(NULL);

// Use ODBC
_ConnectionPtr ptrConn("ADODB.Connection");

// Make the connection
ptrConn->Open(L"Provider=MSDASQL.1;Data Source=data", L"user", L"password", adConnectUnspecified);

// Pointer to the database
_CommandPtr ptrCmd("ADODB.Command");

// Activate the connection
ptrCmd->ActiveConnection = ptrConn;

// Create a recordset
_RecordsetPtr ptrRs("ADODB.Recordset");
ptrRs->PutRefSource(ptrCmd);

// Create a SQL-statment (nnavn, snavn, gruppe and navn is CString)
sql = "INSERT INTO opc (datamaskin, server, gruppe, tagnavn) VALUES ('" + nnavn + "', '" + snavn + "', '" + gruppe + "', '" + navn + "')";

// Create a char[] of CString (Maybe I dont need this..)
strncpy (buf, sql, 200);

// Execute SQL
ptrRs->Open(buf, ptrConn.GetInterfacePtr(), adOpenForwardOnly, adLockReadOnly, adCmdText);

// Close the database
ptrConn->Close();

CoUninitialize();


Andreas
GeneralRe: MS-SQL and C++ Pin
John M. Drescher22-Apr-04 3:02
John M. Drescher22-Apr-04 3:02 
GeneralRe: MS-SQL and C++ Pin
RChin22-Apr-04 3:15
RChin22-Apr-04 3:15 
GeneralDrawState (CDC) problem Pin
YaronNir22-Apr-04 2:13
YaronNir22-Apr-04 2:13 
GeneralRe: DrawState (CDC) problem Pin
YoSilver22-Apr-04 3:13
YoSilver22-Apr-04 3:13 
GeneralRe: DrawState (CDC) problem Pin
YaronNir22-Apr-04 4:50
YaronNir22-Apr-04 4:50 
GeneralRe: DrawState (CDC) problem Pin
YoSilver26-Apr-04 10:02
YoSilver26-Apr-04 10:02 
QuestionHow to make CDateTimeCtrl not editable, without arrows ? Pin
vgrigor22-Apr-04 2:11
vgrigor22-Apr-04 2:11 
AnswerRe: How to make CDateTimeCtrl not editable, without arrows ? Pin
ravjak22-Apr-04 4:32
ravjak22-Apr-04 4:32 
Generalserial comm in w2k Pin
фил22-Apr-04 1:56
фил22-Apr-04 1:56 
GeneralProblem with CStdioFile Pin
Stojan7822-Apr-04 1:36
Stojan7822-Apr-04 1:36 
GeneralRe: Problem with CStdioFile Pin
Steve S22-Apr-04 1:53
Steve S22-Apr-04 1:53 
GeneralRe: Problem with CStdioFile Pin
jmkhael22-Apr-04 1:53
jmkhael22-Apr-04 1:53 
GeneralRe: Problem with CStdioFile Pin
RChin22-Apr-04 1:53
RChin22-Apr-04 1:53 
GeneralRe: Problem with CStdioFile Pin
Stojan7822-Apr-04 2:11
Stojan7822-Apr-04 2:11 
Generalgraphics in c/c++ Pin
kcal22-Apr-04 1:36
kcal22-Apr-04 1:36 
GeneralRe: graphics in c/c++ Pin
Ian Darling22-Apr-04 2:06
Ian Darling22-Apr-04 2:06 
GeneralChange Style subsequent on CSlideCtrl Pin
AnTri22-Apr-04 1:13
AnTri22-Apr-04 1:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.