From: | Oskar Berggren <beo(at)sgs(dot)o(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SQL server application porting headache |
Date: | 2002-06-22 15:58:28 |
Message-ID: | 3D149EA4.8060507@sgs.o.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a Windows application (not written by myself) that uses ODBC to
connect to the database. It was developed using MS Access and SQL Server
as the database. However, we would like to run it using PostgreSQL
as database engine. While trying to do this I have run into some
problems:
1. The PostgreSQL ODBC driver from odbc.postgresql.org doesn't
seem to support dynasets (which I believe require keyset-driven
cursors). Is there any work on supporting this?
Using the driver from openlinksw.com I was able to get it up and
running. But this driver is not open. It is expensive however.
2. With the openlink ODBC driver I succesfully got the application
to connect to the database. But now I run into case-sensitivity
problems. The first query that fail look like this:
SELECT "OperatorID" FROM "IntParams" WHERE OperatorID=0;
^^^^^^^^^^
notice no quotes here
Since the table in question was created using the following
statement:
CREATE TABLE "IntParams" ("OperatorID" int4);
the query above obviously fails on the second reference to
OperatorID, claiming that "Attribute operatorid not found."
I'm using PostgreSQL 7.2.1. Is there a way around this problem?
I don't think it is possible to change the application, since
it is a rather special tool written by another company as closed
source. I suppose that if one could make identifiers case-
insensitive even when quoting them, it would work. Is there a
way to do that?
regards,
Oskar
From | Date | Subject | |
---|---|---|---|
Next Message | Werner Schalk | 2002-06-22 17:11:43 | Creating a user fails |
Previous Message | Peter Dimov | 2002-06-22 13:13:10 | Re: URGENT: Performance tuning |