Re: PGSQL vs. SQL Server questions

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(at)gmanmi(dot)tv]
Sent: Thursday, 12 June 2003 6:02 PM
To: josh(at)agliodbs(dot)com; Lee Matthews; pgsql-novice(at)postgresql(dot)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(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 -->