Re: MS products and Postgres via 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(at)westmarkproducts(dot)com]
Sent: Wednesday, April 16, 2003 5:56 PM
To: 'JohnG(at)smartekcentral(dot)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(at)smartekcentral(dot)com [SMTP:JohnG(at)smartekcentral(dot)com]
Sent: Wednesday, April 16, 2003 2:25 PM
To: cgibbs(at)westmarkproducts(dot)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(at)westmarkproducts(dot)com]
Sent: Wednesday, April 16, 2003 5:17 PM
To: 'JohnG(at)smartekcentral(dot)com'; pgsql-odbc(at)postgresql(dot)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(at)smartekcentral(dot)com [SMTP:JohnG(at)smartekcentral(dot)com]
Sent: Wednesday, April 16, 2003 1:50 PM
To: pgsql-odbc(at)postgresql(dot)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 >>