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
=========================================