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

From Lee Matthews
Subject Re: PGSQL vs. SQL Server questions
Date
Msg-id 51F7D18A1EFED4118BF300B0D02DE9B1BC07C1@MELBEXCHANGE1
Whole thread Raw
In response to PGSQL vs. SQL Server questions  (Lee Matthews <Lee_Matthews@pa.com.au>)
List pgsql-novice
That's great news.
I was hoping so...as none of the select queries I am using are particularly
complex...and I am using the properties of the recordset object to do
updates. Although I suspect it will be a little slower than ADO which I am
using with SQL Server.
I will dowload the ODBC doco and do a bit of research.
Thanks for the reply
Lee

-----Original Message-----
From: Mel Jamero [mailto:mel@gmanmi.tv]
Sent: Thursday, 12 June 2003 6:02 PM
To: josh@agliodbs.com; Lee Matthews; pgsql-novice@postgresql.org
Subject: RE: [NOVICE] 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@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: "Benjamin Wragg"
Date:
Subject: Understanding the explain statement
Next
From: Robert Treat
Date:
Subject: Re: Converting IBM DB2 TRIGGERs to PostgreSQL