Message-ID: <378DE6F2.51FDFCFB@solipsys.com>
Date: Thu, 15 Jul 1999 09:49:38 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
Subject: [Fwd: [INTERFACES] ODBC problem]
Content-Type: multipart/mixed; boundary="------------6D177BB10D505D4B5C10716B"

This is a multi-part message in MIME format.
--------------6D177BB10D505D4B5C10716B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


--------------6D177BB10D505D4B5C10716B
Content-Type: message/rfc822
Content-Disposition: inline

X-Mozilla-Status2: 00000000
Message-ID: <378DDB56.4E915913@solipsys.com>
Date: Thu, 15 Jul 1999 09:00:06 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Terence Chan <kin.chan@technologist.com>
Subject: Re: [INTERFACES] ODBC problem
References: <000401bece8a$7235f4e0$9d4fb8d2@terence.cetec.com.hk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Terence Chan wrote:

> Thanks,
>
> Yes, the file tblItem is belongs to user postgres. And I have also tried the
> chmod 777 the file and still can't access it.
>

Its because the table is called "tblItem", notice the mixed case.  If you want
to access this in pg, you need to use quotes around the table name to preserve
the case.  The odbc does this for you.

Byron


--------------6D177BB10D505D4B5C10716B--