Цитата(Rififi @ 15.5.2008, 15:41  ) | | Google -> "ADO insert sample" |
нашел пример
| Код |
#include <windows.h>
#include <stdio.h>
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
int main(int argc, char* argv[])
{
/*The following variables will be initialized with necessary values and appended to the strSQL values*/
_bstr_t strName;
_bstr_t strAge;
_bstr_t strDOB;
_bstr_t strSalary;
_ConnectionPtr pConn = NULL;
// Define string variables for ADO connection
_bstr_t strCon("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=username;Password=password;Initial Catalog=databasename;Data Source=(local);Integrated Security=SSPI;");
HRESULT hr = S_OK;
//Initialize the COM Library
CoInitialize(NULL);
try
{
//Create the Connection pointer
hr = pConn.CreateInstance((__uuidof(Connection)));
if(FAILED(hr))
{
printf("Error instantiating Connection object\n");
goto cleanup;
}
//Open the SQL Server connection
hr = pConn->Open(strCon,"","",0);
if(FAILED(hr))
{
printf("Error Opening Database object using ADO _ConnectionPtr \n");
goto cleanup;
}
/*Initialize the values */
strName = "'Codersource C++ ADO insert Sample',";
strAge = "10,";
strDOB = "'02/10/2004',";
strSalary = "1010.10)";
/* Append the values to the Insert Statement */
_bstr_t strSQL("Insert into Table1(Name,Age,DOBirth,Salary) Values(");
strSQL += strName + strAge + strDOB + strSalary ;
printf("%s\n",(LPCSTR)strSQL);
//Execute the insert statement
pConn->Execute(strSQL,NULL,adExecuteNoRecords);
printf("Data Added Successfully\n",(LPCSTR)strSQL);
//Close the database
pConn->Close();
}
catch(_com_error & ce)
{
printf("Error:%s\n",ce.ErrorInfo);
}
cleanup:
CoUninitialize();
return 0;
}
|
на строчку 4 ругается
[C++ Error] Unit1.cpp(5): E2209 Unable to open include file ' msado15.tlh'
с чего бы??? И где этот файл тогда найти
| Цитата(Rififi @ 14.5.2008, 02:12 ) | | ADODB.Connection |
ты имеешь ввиду CreateObject("ADODB.Connection")???
Это вроде в ASP такое работает. На С++ не видел пока ни одного примера! |
