Re: Replace MSSQL by PostgreSQL ?

Pieter Grimmerink wrote:
>
> 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?
>
>

You could try, it isn't difficult nor time consuming to test it. The
only thing is that the SQL syntax of MS SQL differs from that of
PostgreSQL, so if you can't change the app I don't give you much chance.

Success,

Nils