ODBC case sensitive table names?

From: eg(at)tzv(dot)fal(dot)de
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC case sensitive table names?
Date: 2000-06-21 09:19:44
Message-ID: XFMail.20000621111944.eg@tzv.fal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)tzv(dot)fal(dot)de
=========================================

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tibor Laszlo 2000-06-21 16:42:57 Re:
Previous Message Jim Caley 2000-06-20 21:39:32 Re: Postgres JDBC driver : problem with timestamps.