Very Computer

1. I am creating a new query using ADOX and no matter

I am creating a new query using ADOX and no matter
what I do I cannot see the query in the Database window.
I have even pasted the example from the MSDN and change code.
What am I doing wrong ?

//Maybe:
m_pCatalog->Procedures->Append("MyProcedure", _variant_t((IDispatch
*)m_pCommand));

but no matter.

Command and CommandText Properties Example (VC++)
The following code demonstrates how to use the Command property to
update the text of a procedure.
// BeginCommandTextCpp
#import "c:\Program Files\Common Files\system\ado\msadox.dll" \
no_namespace
#import "c:\Program Files\Common Files\system\ado\msado15.dll"

#include "iostream.h"
#include "stdio.h"
#include "conio.h"

//Function declarations
inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
void ProcedureTextX(void);

//////////////////////////////////////////////////////////
// //
// Main Function //
// //
//////////////////////////////////////////////////////////
void main()
{
if(FAILED(::CoInitialize(NULL)))
return;

ProcedureTextX();

::CoUninitialize();

//////////////////////////////////////////////////////////
// //
// ProcedureTextX Function //
// //
//////////////////////////////////////////////////////////
void ProcedureTextX()
{
HRESULT hr = S_OK;

// Define ADOX object pointers.
// Initialize pointers on define.
// These are in the ADOX:: namespace.
_CatalogPtr m_pCatalog = NULL;

// Define ADODB object pointers.
ADODB::_ConnectionPtr m_pCnn = NULL;
ADODB::_CommandPtr m_pCommand = NULL;

try
{
//Open the Connection
TESTHR(hr = m_pCnn.CreateInstance(__uuidof(ADODB::Connection)));
TESTHR(hr = m_pCatalog.CreateInstance(__uuidof(Catalog)));
TESTHR(hr = m_pCommand.CreateInstance(__uuidof(ADODB::Command)));
m_pCnn->Open("Provider=Microsoft.Jet.OLEDB.4.0;"
"data source=c:\\Program Files\\Microsoft Office"
"\\Office\\Samples\\Northwind.mdb;","","",NULL);

//Open the catalog
m_pCatalog->PutActiveConnection(_variant_t((IDispatch *)m_pCnn));

//Get the Command
m_pCommand = m_pCatalog->Procedures->GetItem("CustomerById")->GetCommand();

//Update the CommandText
m_pCommand->PutCommandText("PARAMETERS [CustId] Text;select "
"CustomerId, CompanyName, ContactName "
"from Customers where CustomerId = [CustId]");

//Update the Procedure
m_pCatalog->Procedures->GetItem("CustomerById")->PutCommand(
_variant_t((IDispatch *)m_pCommand));

catch(_com_error &e)
{
// Notify the user of errors if any.
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());

printf("\n\tSource : %s \n\tdescription : %s \n
",(LPCSTR)bstrSource,(LPCSTR)bstrDescription);

catch(...)
{
cout << "Error occured in include files...."<< endl;

Thanks in anticipation.

2. 19102-NY-ROCHESTER-Software Development-Visual Basic-Visual C++-MS ACCESS-ORACLE

3. Creating MSDE database using ADO/ADOX with VC++

4. Update with image

5. Oh~ I'm so sorry!!Please help me again.

6. Create any desktop database using ADOX/ADO

7. desc command in jdbc

8. Create any desktop database using ADO/ADOX

9. creating a new table in Oracle data base using ADOX

10. Select statement return error when creating a table using ADOX

11. In SQL Server select statement return error when creating table using ADOX

12. Create Tables using ADOX