Re: postres, odbc and adox

Isn't adox really for access db's?...

Microsoft ActiveX Data Objects Extensions for Data Definition Language
and Security (ADOX) is designed for use with the Microsoft Jet Database
Engine. So, using ADOX with OLE DB providers other than the Microsoft
Jet OLE DB Provider may cause unexpected behavior or incorrect results.
The exact behavior is dependent on the nature of the database for which
the provider is written. If a provider is accesses a database system
whose model is totally different from that of Jet, the behavior of ADOX
could be unpredictable (for example, Jet does not support the concepts
of CATALOG or SCHEMA)....

http://support.microsoft.com/default.aspx?scid=kb;

-----Original Message-----
From: Tom Cook [mailto:tomandkellycook(at)hotmail(dot)com]
Sent: 13 September 2002 15:27
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] postres, odbc and adox

I'm hoping that you can help me. I have written a MS C++ application
that
uses ADO and ADOX to communicate to the ODBC drivers. I am trying to
use
the PostGres ODBC driver but I am having problems in using the
ADOX::_CatalogPtr and inserting the connection:

m_pCatalog->PutActiveConnection("Provider=MSDASQL.1;Persist
Security Info=False;User ID=postgres;Data Source=PostgreSQL");

The ADO side of things works fine but if I want to do anything with ADOX

such as create a table, when I attempt to build the catalog based on a
postgres connection string, I get a _com_error. Do you have any idea as
to
how to handle this? Does the your postgres ODBC driver not support
ADOX?
Could I be doing something wrong?

Many thanks for your help,
Tom

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)