PDA

View Full Version : PostgreSQL and MySQL support


mseminatore
09-14-2005, 01:48 PM
I'd really like to see support for databases other than MS SQL Server.

Rather than using an ISQL interface why not provide an ODBC step in the tool? Then as long as a proper DSN was setup on the machine you could use any database for which a driver existed.

kinook
09-14-2005, 04:04 PM
You can access any database that has an ODBC driver or OLEDB provider using the new ADO action in VBP 6 [1]. The attached sample should be close for the PostgreSQL's OLEDB [2] provider. If you have an ODBC driver for it, that would work too (specify ODBC in the Provider field and your DSN name).

[1] http://www.kinook.com/Forum/showthread.php?threadid=1218
[2] http://pgfoundry.org/projects/oledb/