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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Josh Berkus
Sent: Thursday, June 12, 2003 4:25 AM
To: Lee Matthews; 'pgsql-novice@postgresql.org'
Subject: Re: [NOVICE] PGSQL vs. SQL Server questions
<-- snipped -->