Styjun

Another "name-that-distribution" question

Improving an O(N^2) function (all entities iterating over all other entities)

Date input format problem

Three phase systems - are there any single phase devices that are connected between two phases instead of between one phase and neutral?

Can a crisscrossed metallic skeleton resist earthquakes for buildings?

Why is the forgetful functor representable?

How to declare an array without specifying its size, but with an initializer inside a class in C++?

setcounter is not affecting numbering

Why should fork() have been designed to return a file descriptor?

Why is there an extra "t" in Lemmatization?

Has anyone ever written a novel or short story composed of only dialogue?

Do I care if the housing market has gone up or down, if I'm moving from one house to another?

Why didn't NASA launch communications relay satellites for the Apollo missions?

Satellite in orbit in front of and behind the Moon

Difference between string += s1 and string = string + s1

Host telling me to cancel my booking in exchange for a discount?

What's the difference between 1kb(64x16) and 1kb(128x8) for EEPROM memory size?

What is the origin of "Wonder begets wisdom?"

Why would word of Princess Leia's capture generate sympathy for the Rebellion in the Senate?

How does the Gameboy's memory bank switching work?

Does a hash function have a Upper bound on input length?

Do you need to have the original move to take a "Replaces:" move?

Linearize or approximate a square root constraint

Will a ThunderBolt 3 (USB-C?) to ThunderBolt 2 cable allow me to use a MacBook Pro as second monitor?

How to fix _pRecordset doesn't open ADO C++

What are the differences between a pointer variable and a reference variable in C++?How can I prevent SQL injection in PHP?How to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?How do I iterate over the words of a string?How can I profile C++ code running on Linux?The Definitive C++ Book Guide and ListWhat is the “-->” operator in C++?How do I UPDATE from a SELECT in SQL Server?How to Delete using INNER JOIN with SQL Server?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

i am trying to connect my C++ project to SQL Server using ADO it goes well before pRecordset->Open(...); and error encounter it says Microsoft C++ exception: _com_error at memory location'.

i tried to do such things
pRecordset->Open(SelectQuery, _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);
but in the debug window it shows _hr: DB_E_NOTABLE Table Does not exist.
i also tried to do such things
pRecordset->Open("TestTB", _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdTable); but it doesn't help.

Is this Connection problem? it would be vary usefull for me if you give me some advice. Thank you in advance.

_ConnectionPtr pConnection;
_CommandPtr pCommand;
_RecordsetPtr pRecordset;

_bstr_t strCon("ADOSQL"); //"Provider=sqloledb; Data Source=...\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True");

_bstr_t SelectQuery("Select * from TestTB");

HRESULT hr = S_OK;
CoInitialize(NULL);

//Create the Connection pointer
hr = pConnection.CreateInstance(__uuidof(Connection));
if (FAILED(hr))

 printf("Error instantiating Connection objectn");


//Open the SQL Server connection
hr = pConnection->Open(strCon, "", "", adConnectUnspecified);
if (FAILED(hr))

 printf("Error Opening Database object using ADO _ConnectionPtr n");


hr = pCommand.CreateInstance(__uuidof(Command));
if (FAILED(hr))

 printf("Error creating command instance[]");


pCommand->ActiveConnection = pConnection;
pCommand->CommandText = SelectQuery;
pCommand->CommandType = adCmdText;

hr = pRecordset.CreateInstance(__uuidof(Recordset));
if (FAILED(hr))

 printf("Failed creating record set instancen");


//CString SQLQuery = "Select * From TestTB";
pRecordset->Open(_variant_t(pCommand), _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);

c++ sql sql-server sql-server-2008 ado

share|improve this question

edited Mar 26 at 12:39

Giorgi Gogenia

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

add a comment | 

0

i am trying to connect my C++ project to SQL Server using ADO it goes well before pRecordset->Open(...); and error encounter it says Microsoft C++ exception: _com_error at memory location'.

i tried to do such things
pRecordset->Open(SelectQuery, _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);
but in the debug window it shows _hr: DB_E_NOTABLE Table Does not exist.
i also tried to do such things
pRecordset->Open("TestTB", _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdTable); but it doesn't help.

Is this Connection problem? it would be vary usefull for me if you give me some advice. Thank you in advance.

_ConnectionPtr pConnection;
_CommandPtr pCommand;
_RecordsetPtr pRecordset;

_bstr_t strCon("ADOSQL"); //"Provider=sqloledb; Data Source=...\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True");

_bstr_t SelectQuery("Select * from TestTB");

HRESULT hr = S_OK;
CoInitialize(NULL);

//Create the Connection pointer
hr = pConnection.CreateInstance(__uuidof(Connection));
if (FAILED(hr))

 printf("Error instantiating Connection objectn");


//Open the SQL Server connection
hr = pConnection->Open(strCon, "", "", adConnectUnspecified);
if (FAILED(hr))

 printf("Error Opening Database object using ADO _ConnectionPtr n");


hr = pCommand.CreateInstance(__uuidof(Command));
if (FAILED(hr))

 printf("Error creating command instance[]");


pCommand->ActiveConnection = pConnection;
pCommand->CommandText = SelectQuery;
pCommand->CommandType = adCmdText;

hr = pRecordset.CreateInstance(__uuidof(Recordset));
if (FAILED(hr))

 printf("Failed creating record set instancen");


//CString SQLQuery = "Select * From TestTB";
pRecordset->Open(_variant_t(pCommand), _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);

c++ sql sql-server sql-server-2008 ado

share|improve this question

edited Mar 26 at 12:39

Giorgi Gogenia

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

add a comment | 

i am trying to connect my C++ project to SQL Server using ADO it goes well before pRecordset->Open(...); and error encounter it says Microsoft C++ exception: _com_error at memory location'.

i tried to do such things
pRecordset->Open(SelectQuery, _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);
but in the debug window it shows _hr: DB_E_NOTABLE Table Does not exist.
i also tried to do such things
pRecordset->Open("TestTB", _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdTable); but it doesn't help.

Is this Connection problem? it would be vary usefull for me if you give me some advice. Thank you in advance.

_ConnectionPtr pConnection;
_CommandPtr pCommand;
_RecordsetPtr pRecordset;

_bstr_t strCon("ADOSQL"); //"Provider=sqloledb; Data Source=...\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True");

_bstr_t SelectQuery("Select * from TestTB");

HRESULT hr = S_OK;
CoInitialize(NULL);

//Create the Connection pointer
hr = pConnection.CreateInstance(__uuidof(Connection));
if (FAILED(hr))

 printf("Error instantiating Connection objectn");


//Open the SQL Server connection
hr = pConnection->Open(strCon, "", "", adConnectUnspecified);
if (FAILED(hr))

 printf("Error Opening Database object using ADO _ConnectionPtr n");


hr = pCommand.CreateInstance(__uuidof(Command));
if (FAILED(hr))

 printf("Error creating command instance[]");


pCommand->ActiveConnection = pConnection;
pCommand->CommandText = SelectQuery;
pCommand->CommandType = adCmdText;

hr = pRecordset.CreateInstance(__uuidof(Recordset));
if (FAILED(hr))

 printf("Failed creating record set instancen");


//CString SQLQuery = "Select * From TestTB";
pRecordset->Open(_variant_t(pCommand), _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);

c++ sql sql-server sql-server-2008 ado

share|improve this question

edited Mar 26 at 12:39

Giorgi Gogenia

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

_ConnectionPtr pConnection;
_CommandPtr pCommand;
_RecordsetPtr pRecordset;

_bstr_t strCon("ADOSQL"); //"Provider=sqloledb; Data Source=...\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True");

_bstr_t SelectQuery("Select * from TestTB");

HRESULT hr = S_OK;
CoInitialize(NULL);

//Create the Connection pointer
hr = pConnection.CreateInstance(__uuidof(Connection));
if (FAILED(hr))

 printf("Error instantiating Connection objectn");


//Open the SQL Server connection
hr = pConnection->Open(strCon, "", "", adConnectUnspecified);
if (FAILED(hr))

 printf("Error Opening Database object using ADO _ConnectionPtr n");


hr = pCommand.CreateInstance(__uuidof(Command));
if (FAILED(hr))

 printf("Error creating command instance[]");


pCommand->ActiveConnection = pConnection;
pCommand->CommandText = SelectQuery;
pCommand->CommandType = adCmdText;

hr = pRecordset.CreateInstance(__uuidof(Recordset));
if (FAILED(hr))

 printf("Failed creating record set instancen");


//CString SQLQuery = "Select * From TestTB";
pRecordset->Open(_variant_t(pCommand), _variant_t(pConnection, true),adOpenForwardOnly, adLockReadOnly, adCmdText);

c++ sql sql-server sql-server-2008 ado

c++ sql sql-server sql-server-2008 ado

share|improve this question

edited Mar 26 at 12:39

Giorgi Gogenia

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

share|improve this question

edited Mar 26 at 12:39

Giorgi Gogenia

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges

asked Mar 26 at 12:26

Giorgi GogeniaGiorgi Gogenia

355 bronze badges