Thread: VB6 - convertion from Access database to PostgreSQL
I have been asked to take a VB6 application that use an Access database and convert it to use PostgreSQL.
From what I can see the VB application connects using DAO and also JET/ADO!
Not sure why it has both
If I do convert it to PostgreSQL do I have the option of standard ADO access or do I have to use DAO?
Also, what are the performance considerations?
May thanks
Jonathan Blitz
On 29/01/2008 07:44, Jonathan Blitz wrote: > If I do convert it to PostgreSQL do I have the option of standard ADO > access or do I have to use DAO? You can use the ADO provider for ODBC, and the PostgreSQL ODBC driver - I've used this for quite some time without problems. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
Many thanks. Now all I have to do is to figure out what price to quote them. :) -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Raymond O'Donnell Sent: Tuesday, January 29, 2008 12:44 PM To: Jonathan Blitz Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] VB6 - convertion from Access database to PostgreSQL On 29/01/2008 07:44, Jonathan Blitz wrote: > If I do convert it to PostgreSQL do I have the option of standard ADO > access or do I have to use DAO? You can use the ADO provider for ODBC, and the PostgreSQL ODBC driver - I've used this for quite some time without problems. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
On 29/01/2008 15:25, Jonathan Blitz wrote: > Now all I have to do is to figure out what price to quote them. :) Make sure it has plenty of zeros at the end! :-) Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------