From: | "Pieter Grimmerink" <p(dot)grimmerink(at)home(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Replace MSSQL by PostgreSQL ? |
Date: | 2001-05-26 13:33:13 |
Message-ID: | tgOP6.193224$Uo2.4834570@zwoll1.home.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a windows application using a MSSQL (the free 2gig version) database.
When the application is first started, I have to select 'sql server' and
then I need to
give the sql setup (servername, user+pass) in an ODBC datasource setup
dialog.
Now I am wondering, would there be a chance I could use PostgreSQL on my
linux
server, with an ODBC windows driver, and let this application create and use
a postgresql database instead, without having to make changes to the
application
itself?
Or do I have a way to positive idea about ODBC interfaces...
Right now I tried to get this working, I installed postgresql 7.1, and the
postgresql ODBC
driver for windows, but I can't even import database tables from postgresql
in MSAccess.
But this could very well be because the highest version I can select in the
driver is the 6.4/6.5
protocol.
The only way to convince people to move from MSSQL to PostgreSQL would be
when they don't notice the difference ;-)
Should I go on with this, or don't I have a chance?
Best regards,
Pieter
From | Date | Subject | |
---|---|---|---|
Next Message | Culley Harrelson | 2001-05-26 13:41:58 | database size including indexes |
Previous Message | Madness | 2001-05-26 11:02:20 | altering data type in a column |