Thread: Using Microsoft Access as front end to Postgres
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
At 02:38 PM 10/05/00 -0700, Steve Quezadas wrote: >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. If there is a document that describes how to use access as a front end to postgres I too would be very interested in reading it. I want to do the exact same thing. :wq Tim Uckun Due Diligence Inc. http://www.diligence.com/ Americas Background Investigation Expert. If your company isn't doing background checks, maybe you haven't considered the risks of a bad hire.
Hey Steve,
We've been happily using MS Access 97 as a front end for pg 7.02 for about two months.
A couple of points:
1) Make sure you have the absolute latest stable ODBC driver. We had strange phantom
problems after upgrading to pg 7.02 because we did not update our ODBC driver.
2) We had a persistant problem with an error 'Out of Memory while reading tuples (#1)'.
The solution was to turn *ON* the declare/fetch option in the PostgreSQL ODBC driver on
the client systems.
3) The pgsql-interfaces list is where most ODBC issues are discussed. The declare/fetch
solution to our memory problem was from a thread a year ago between Byron Nikolaidis and
G. Anthony Reina on the INTERFACES list (found using the web search feature on postgresql.org)
Good Luck,
David Huttleston Jr
On Thu, 5 Oct 2000 14:38:08 -0700, you wrote:
> I am trying to use Microsoft Access as a front end to Postgres, but I am having some trouble with the ODBC driver. I
getall sorts of weird problems. For instance, sometimes when I enter in new values in a table, if the field I type in a
fieldthat 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
linkedtable 'test' failed" and then another one that says "Error while executing the query; ERROR: Unable to identify
anoperator '=' for types 'xid' and 'int4'. You will have to retype this query using an explicit cast". I get the same
exacterrors 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
frontend 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
toconnect to with this driver. the Help files are non-existant with this particular driver.
>
> - Steve
>
>
>
Hello Steve, Once, Friday, October 06, 2000, 3:38:08 AM, you wrote: SQ> I am trying to use Microsoft Access as a front end to Postgres, but I am having some trouble with the ODBC driver. Iget all sorts of weird problems. For instance, sometimes when I enter in new SQ> 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 differentrows of the "states" column), the whole row has "#Deleted" in it. Other SQ> 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: SQ> 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 SQ> record. SQ> I assume there is a more reliable way to connect to database clients than this. Has anyone got a Microsoft Access frontend working with Postgres? I am using Postgres 7.0.2 and ODBC driver SQ> postdrv 6.5. SQ> I also tried going to OpenLink ODBC, but I can't find where you are supposed to put IP address of the server you wantto connect to with this driver. the Help files are non-existant with this SQ> particular driver. Probably you can find answers in the POSTGRESQL & ACCESS FAQ (http://www.scw.org/pgaccess/faq.html) -- Best regards, Yury ICQ 11831432 mailto:yura@vpcit.ru
I have expreimented with MySQL and Postgresql - Now I am trying to get Postgresql to work with some visual basic frontend via ODBC. - Maybe later testing it with Cold Fusion . - Question 1)Does Postgresql with with UNIXODBC ? 2)Any good documenttations on unixodbc
Danny writes: > 1)Does Postgresql with with UNIXODBC ? > 2)Any good documenttations on unixodbc Those questions are better answered on www.unixodbc.org. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
One thing to be sure of is that the postgres tables all have a unique id # and that you tell OBDC what field it is when you connect from msaccess.
Tim McKenna
*********** REPLY SEPARATOR ***********
On 10/5/00 at 2:38 PM Steve Quezadas wrote:
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
On Sat, Oct 07, 2000 at 12:51:54AM +1100, Danny wrote: > 1)Does Postgresql with with UNIXODBC ? Yes, it does without a problem. Michael -- Michael Meskes Michael@Fam-Meskes.De Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!