Re: MS products and Postgres via ODBC - Mailing list pgsql-odbc

Corey,

The app is being programmed to use the C interface to postgres, which is working, is 98% complete, and we would rather not change it.  It does not use the ODBC for various reasons.

The error is [ERROR: Relation "customermaster" does not exist] from Microsoft Query, when trying to get external data from Excel.

The table is actually called "CustomerMaster", so of course if it's looking for "customermaster", it won't find it.

If you get through the error message, into Microsoft Query, and build the query there, the SQL it outputs is this:
=================
SELECT CustomerMaster.Branch, CustomerMaster.Customer, CustomerMaster.Name, CustomerMaster.Branch, CustomerMaster.Customer, CustomerMaster.Name

FROM CustomerMaster CustomerMaster
WHERE (CustomerMaster.Branch=1) AND (CustomerMaster.Customer<=1500)
=================

Nothing is quoted, and so it will never work.  So there is something odd here that the table and columns are not quoted properly.

I've attaced the log's, though I'm not sure what use they may be.

Thanks again!
John

-----Original Message-----
From: Corey W. Gibbs [mailto:cgibbs@westmarkproducts.com]
Sent: Wednesday, April 16, 2003 5:56 PM
To: 'JohnG@smartekcentral.com'
Subject: RE: [ODBC] MS products and Postgres via ODBC

Hi John,
Ouch, I remember this problem from when I had to help convert a VB program
(and a VB programmer ;)) over to postgres. hmmm, couple of questions,
what's the app? and what's the error?
corey

-----Original Message-----
From:   JohnG@smartekcentral.com [SMTP:JohnG@smartekcentral.com]
Sent:   Wednesday, April 16, 2003 2:25 PM
To:     cgibbs@westmarkproducts.com
Subject:        RE: [ODBC] MS products and Postgres via ODBC

Corey,
        The Get External Data chokes on the names of the tables and columns. It displays them properly, but as soon as you get past the selection stage it dies.

        It appears that the table and column names are being converted to lower case.

        So short of changing all the tables and column names to lower case, is there a way to make this work?  (I have tried change them to lower case, and yes ODBC works, but then my application doesn't.)

Thanks,
John

-----Original Message-----
From: Corey W. Gibbs [mailto:cgibbs@westmarkproducts.com]
Sent: Wednesday, April 16, 2003 5:17 PM
To: 'JohnG@smartekcentral.com'; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] MS products and Postgres via ODBC

afternon JohnG,

I know from excel, if you have the ODBC driver installed and a system DSN made, you will have no problems using the Get External Data menu entry to query from a PG database.  Dunno about Word, but it's probobly very similar

since they both can use MS Query data sources

hope this helps
corey

-----Original Message-----
From:   JohnG@smartekcentral.com [SMTP:JohnG@smartekcentral.com]
Sent:   Wednesday, April 16, 2003 1:50 PM
To:     pgsql-odbc@postgresql.org
Subject:        [ODBC] MS products and Postgres via ODBC

Hello all,

        Is there a way, other then using an Access database or putting everything in lower case, to allow MS Word and MS Excel to access the Postgres database directly?  We would like to use Postgres instead of our current database(s) but not being able to use this directly could prevent this.

        (I think I may have seen this come up before as a quoting issue, but I'm not 100% sure on that.)

Thank you for any help you can provide.

John
 << File: ATT00039.html >>
 << File: ATT00041.html >>