Thread: VB6 and postgresql

VB6 and postgresql

From

"Demetrakopoulos Yiannis"

Date:

26 March 2007, 15:05:23

I want to migrate a large application written in vb6 and mssql to support postgresql.

The problem is that as we do some server management within our application (dbase scripting,backups,db attach,db syncs etc) ,we use sql-dmo. Is there any easy way (such a dll) to replace the sql-dmo calls for postgresql ?

If not how can I create or execute postgresql scripts form vb6 ?

Best Regards

Demetrakopoulos Ioannis

Anadelta Information & Medical Ssytems

Athens Greece

Re: VB6 and postgresql

From

"Shoaib Mir"

Date:

27 March 2007, 06:57:54

Have you tried using Shell.execute with psql to execute SQL script from VB6?

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 3/26/07, Demetrakopoulos Yiannis <Ioannis.Demetrakopoulos@anadelta.gr> wrote:

I want to migrate a large application written in vb6 and mssql to support postgresql.
The problem is that as we do some server management within our application (dbase scripting,backups,db attach,db syncs etc) ,we use sql-dmo. Is there any easy way (such a dll) to replace the sql-dmo calls for postgresql ?
If not how can I create or execute postgresql scripts form vb6 ?

Best Regards
Demetrakopoulos Ioannis

Anadelta Information & Medical Ssytems

Athens Greece