We have a large database with camel case names for schemas, tables, columns, etc. I'm able to connect via ODBC with MS Access, but not with Excel (MSQuery). The names are not quoted and lowercase folding kicks in - so all tables are 'not found'. If I manually edit the MSQuery sql and double-quote all names, i can get the queries to work - but each and every query must be manually edited. Obviously unworkable.
Is it possible for the odbc driver to return schema, table and column names to MSQuery in double-quoted form so queries are built correctly? Alternatively, could the odbc driver insert double-quotes on-the-fly once it sees uppercase characters in the names?
This would help us immensely!!!
Thanks in advance,
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
pgsql-odbc by date
|Next:||From: Merlin Moncure||Date: 2005-07-26 19:51:02|
|Subject: Re: Lowercase folding - simple patch?|
|Previous:||From: Bob Caryl||Date: 2005-07-26 18:05:53|
|Subject: Re: Ok... I got most of it working but . . .|