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 ?

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

Quote:
}

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

Quote:
}

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

Quote:
}

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

Quote:
}
}

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:
                m_pCnn->Open("Provider=Microsoft.Jet.OLEDB.4.0;data
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