Re: PGSQL vs. SQL Server questions - Mailing list pgsql-novice

From Mel Jamero
Subject Re: PGSQL vs. SQL Server questions
Date
Msg-id 009901c330b8$f1122600$1b06a8c0@CMPMEL
Whole thread Raw
In response to Re: PGSQL vs. SQL Server questions  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
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 -->


pgsql-novice by date:

Previous
From: Robby Russell
Date:
Subject: pg_restore ignore specific tables?
Next
From: Dani Oderbolz
Date:
Subject: Re: Question regarding keyword checkboxes in database