[GENERAL] WINNT ODBC not connecting to FREEBSD PostgreSQL

2000-06-07 Thread lampe
Installed PostgreSQL 7.0 on FreeBSD 4.0, went prefectly.   Installed PostgreSQL ODBC Driver/manager on NT Workstation 4.0, went perfectly.   Tried to establish a connection between ODBC and FreeBSD, the driver says the connection can not be established.   Does there need to be a port entry i

Re: [GENERAL] Cannot INDEX an Access97 ODBC

2000-06-09 Thread lampe
Thanks for the response: The column exists in the table structure and can be accessed/queried via psql with SELECT statements or via ODBC SELECT statements form Access97. The data intergrity (content) for the table and columns is fine and intact. The psql CREATE INDEX statement can't see the im

[GENERAL] RE: FIXED: Cannot INDEX an Access97 ODBC export?

2000-06-09 Thread lampe
Thanks for the info: Appears, unbeknownst to me, that UPPER case field names can't be addressed via the CREATE INDEX statement in psql mode. Renamed all my Access97 table field names to "Lower Case" and exported them to the PostgreSQL 7.0 database. Now they "can" be indexed just fine. H. So,

[GENERAL] libpgtcl.so? Called by pgaccess.

2000-06-10 Thread lampe
So... How do you arrive at locating this puppy, the "libpgtcl.so", to run pgaccess under FreeBSD 4.0 - As far as I can tell, it's not part of the pgaccess distribution located under /contrib, H. "Berry Interesting." DLampe -

[GENERAL] libpgtcl.so missing from pgaccess on FreeBSD4.0?

2000-06-15 Thread lampe
How do you locate/create the "libpgtcl.so" in order to run pgaccess under FreeBSD 4.0 - As far as I can tell, it does not appear to be part of the pgaccess distribution located under /contrib. This is called by main.tcl as a required shared library. Thanks. DLampe -