Received: from linux.wilsoft.nl (root@apollo-hrn0451.multiweb.net [195.114.253.199]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA39398 for ; Sat, 4 Mar 2000 03:40:06 -0500 (EST) (envelope-from wvdakker@wilsoft.nl) Received: from pentium (pentium.wilsoft.nl [10.2.0.5]) by linux.wilsoft.nl (8.9.3/8.9.3) with ESMTP id JAA20055 for ; Sat, 4 Mar 2000 09:36:02 +0100 Message-ID: <001a01bf85b5$cd5d45c0$0500020a@wilsoft.nl> From: "W. van den Akker" To: Subject: ODBC Date: Sat, 4 Mar 2000 09:44:06 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0017_01BF85BE.2F032940" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_0017_01BF85BE.2F032940 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I've some (only one actually) problems with the conversion=20 from Access to PostgreSQL. The table and columnnames of the Access database do have sometimes capitals (ThisTable, = ThisColumn). If I convert this table or row, the table and row are created but I = cann't access them. It lookes like the postgress engine converts automaticly = all names to lowercase. If a table is created the conversion to lowercases doesn't occur. Am I doing something wrong, or need the postgress ODBC-driver be = changed? TIA Willem ------=_NextPart_000_0017_01BF85BE.2F032940 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I've some (only one actually) problems = with the=20 conversion
from Access to PostgreSQL. The table = and=20 columnnames
of the Access database do have = sometimes capitals=20 (ThisTable, ThisColumn).
If I convert this table or row, the = table and=20 row are created but I cann't
access them. It lookes like the = postgress engine=20 converts automaticly all
names to lowercase. If a table is = created the=20 conversion to lowercases
doesn't occur.
 
Am I doing something wrong, = or need the=20 postgress ODBC-driver be changed?
 
TIA
 
Willem
------=_NextPart_000_0017_01BF85BE.2F032940--