Received: from jupiter.tzv.fal.de (jupiter.tzv.fal.de [192.108.34.1])
	by hub.org (8.10.1/8.10.1) with ESMTP id e5L9Jl170570
	for <pgsql-interfaces@postgresql.org>;
	Wed, 21 Jun 2000 05:19:47 -0400 (EDT)
Received: from eno.tzv.fal.de (IDENT:root@eno [192.108.34.36])
	by jupiter.tzv.fal.de (8.9.3/8.9.3) with ESMTP id LAA23165
	for <pgsql-interfaces@postgresql.org>;
	Wed, 21 Jun 2000 11:19:45 +0200 (MET DST)
Received: (from eg@localhost) by eno.tzv.fal.de (8.9.3/8.8.7) id LAA05470
	for pgsql-interfaces@postgresql.org; Wed, 21 Jun 2000 11:19:44 +0200
Message-ID: <XFMail.20000621111944.eg@tzv.fal.de>
X-Mailer: XFMail 1.4.4 on Linux
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Date: Wed, 21 Jun 2000 11:19:44 +0200 (CEST)
Organization: TZV FAL
From: eg@tzv.fal.de
To: pgsql-interfaces@postgresql.org
Subject: ODBC case sensitive table names?
X-Archive-Number: 200006/94

Hello everyone,
in the process of migrating a VB (Windows) application with access to
PostgreSQL/Linux we ran across the problem of case sensitive Column names:

select * from SomeTable;

works fine with psql

but when sent via ODBC we get an 'illegal tablename' back.
 
as many table names start with a capital letter in VB we would hate to
convert them manually.

Any ideas?

Postgresql 7.0.1
ODBC 6.5
WIN NT

Eildert Groeneveld
=========================================
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel   : (49)(0)5034 871155
Fax   : (49)(0)5034 92579
www   : http://www.tzv.fal.de/~eg/ 
e-mail: eg@tzv.fal.de
=========================================