I am creating a new query using ADOX and no matter 
Author Message
 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 ?

m_pCatalog->Procedures->Append("MyProcedure", _variant_t((IDispatch

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" \
#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()




// //
// ProcedureTextX Function //
// //
void ProcedureTextX()

// 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;

//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)));
"data source=c:\\Program Files\\Microsoft Office"

//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
_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


cout << "Error occured in include files...."<< endl;


Thanks in anticipation.

Sun, 31 Oct 2004 15:04:23 GMT  
 I am creating a new query using ADOX and no matter
I solve my problem.

Must be:
source=C:\\Ax970011\\MDB\\ax970011.mdb;jet oledb:System
Database=c:\\AX970011\\Ax970011.mdw;User Id=Admin","","",NULL);

All work fine!

Mon, 01 Nov 2004 11:25:32 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Creating a Access database using ADOX and C#

2. create autonum field using adox

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

4. Am I creating new threads or ultra waste???

5. I am new to programming and am lost

6. C# , i am trying to create a file on the server using C#

7. Dynamically Creating parameterized queries using VC++

8. Dynamically Creating parameterized queries using VC++

9. Dynamically Creating parameterized queries using VC++

10. ADOX create foreign key

11. Creating table with ADOX

12. How to Create Link with ADOX?


Powered by phpBB® Forum Software