VB6 - convertion from Access database to PostgreSQL

This is a multi-part message in MIME format.

------=_NextPart_000_0002_01C8625B.828A5930
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit



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


------=_NextPart_000_0002_01C8625B.828A5930
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>

Re: 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

Re: VB6 - convertion from Access database to PostgreSQL

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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: VB6 - convertion from Access database to PostgreSQL

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings