RE: Re: Replace MSSQL by PostgreSQL ? - Mailing list pgsql-general

Hi, Pieter,
    there is no problem with ODBC, but
you have to move your database architecture to PostgreSQL.
There are some problems with the the lack of SQL compatibleness between MS &
PG (of course - no standard).

MS use getdate() to get current_timestamp etc.

I stopped porting because I have table 'name' on MS, but on PG is it
impossible.

regards,

Jan Pruner


> -----Original Message-----
> From: Per-Olof Pettersson [mailto:pgsql@peope.net]
> Sent: Monday, May 28, 2001 5:15 AM
> To: Pieter Grimmerink; pgsql-general@postgresql.org
> Subject: [GENERAL] 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?
> >
> > Best regards,
> >
> > Pieter
> >
> >
> >
>
> Hi
>
> First, try to get the latest driver. It shows support for
> 7.x. You can
> find it at http://odbc.postgresql.org/
>
> Next, you need to configure the datasource. By default it is
> read-only.
> And there are some other issues for how it is supposed to interpret
> TEXT-types and the like.
> http://www.sevainc.com/Access/PostgreSQL_ODBC_Configuration.html
>
> These links are taken from
> http://techdocs.postgresql.org/oresources.php
>
> Best regards
> Per-Olof Pettersson
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>