From: | "Steve Quezadas" <steveeq2(at)tripperjones(dot)com> |
---|---|
To: | <pgsql-general(at)hub(dot)org> |
Subject: | Using Microsoft Access as front end to Postgres |
Date: | 2000-10-05 21:38:08 |
Message-ID: | 00f001c02f14$8e5d6270$7801a8c0@steve |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to use Microsoft Access as a front end to Postgres, but I am having some trouble with the ODBC driver. I get all sorts of weird problems. For instance, sometimes when I enter in new values in a table, if the field I type in a field that has already been typed in before (ie I type "CA" in two different rows of the "states" column), the whole row has "#Deleted" in it. Other times, I want to delete a record, and I'll get a dialogue box that says "ODBC--delete on a linked table 'test' failed" and then another one that says "Error while executing the query; ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'. You will have to retype this query using an explicit cast". I get the same exact errors if I try to change an item in a current record.
I assume there is a more reliable way to connect to database clients than this. Has anyone got a Microsoft Access front end working with Postgres? I am using Postgres 7.0.2 and ODBC driver postdrv 6.5.
I also tried going to OpenLink ODBC, but I can't find where you are supposed to put IP address of the server you want to connect to with this driver. the Help files are non-existant with this particular driver.
- Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Wade D. Oberpriller | 2000-10-05 22:03:21 | Good reference for PL/pgsql |
Previous Message | Tom Lane | 2000-10-05 20:07:04 | Re: Re: [SQL] Object syntax |