Skip site navigation (1) Skip section navigation (2)

Re: Problems with ODBC and Access

From: Steve News <earlysteve(at)earthlink(dot)net>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>,pgsql-odbc(at)postgresql(dot)org
Cc: Michelle Murrain <mmurrain(at)dbdes(dot)com>
Subject: Re: Problems with ODBC and Access
Date: 2005-02-15 19:22:35
Message-ID: 6.2.1.2.2.20050215141357.04fed818@pop.earthlink.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Joost,

I'm going to jump in here. I work with Michelle, but am having trouble 
posting to the pg list. When we look at the log files, some times we see 
strange things. I don't have them handy to cut and past here, but for 
example, I can request all rows from a table (no "where" clause"). Then in 
the log, I may see three queries. The first is correct. Then, there are two 
that on their own have added a where clause that restricts the data by 
saying record_id = {some random big integer having nothing to do with 
nothing}. Then the table opens with every dell filled with #delete#.

--steve backman

At 2/15/2005 01:33 PM, you wrote:

>Hi Michelle,
>
>Did you look at the log files that the ODBC drivers generates (if turned 
>on) and/or the PostgresQL log files?
>
>Groeten,
>
>Joost Kraaijeveld
>Askesis B.V.
>Molukkenstraat 14
>6524NB Nijmegen
>tel: 024-3888063 / 06-51855277
>fax: 024-3608416
>e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
>web: www.askesis.nl
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.306 / Virus Database: 265.8.8 - Release Date: 2/14/2005


In response to

Responses

pgsql-odbc by date

Next:From: Eric EDate: 2005-02-15 19:42:38
Subject: Re: Problems with ODBC and Access
Previous:From: Joost KraaijeveldDate: 2005-02-15 18:33:09
Subject: Re: Problems with ODBC and Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group