Re: PGSQL vs. SQL Server questions

Hi Lee,

Josh's reply was very insightful indeed... =) Anyway, as for your last
question:

Yes, there's and ODBC compliant driver for PostgreSQL and it's been working
fine for us, at least in the last 2 years. (XP, NT, 2000, '98, Red Hat
Linux)
And yes, you simply need to vary the connection string to connect to either
SQL Server or Postgres.

HTH.
>> Is an OBDC compliant driver for PGSQL that will enable my COM objects to
>> work against both PGSQL and SQL Server by merely varying the connection
>> string?

>I can't answer that one; Postgres has an ODBC driver, but how smoothly you
can
>transition your COM objects depends on too many factors to count. I
suggest
>that you test it.

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Josh Berkus
Sent: Thursday, June 12, 2003 4:25 AM
To: Lee Matthews; 'pgsql-novice(at)postgresql(dot)org'
Subject: Re: [NOVICE] PGSQL vs. SQL Server questions

<-- snipped -->