| From: | "Steve Quezadas" <steveeq2(at)tripperjones(dot)com> |
|---|---|
| To: | <pgsql-general(at)hub(dot)org> |
| Subject: | Postgres ODBC woes |
| Date: | 2000-09-27 23:48:30 |
| Message-ID: | 004601c028dd$70addda0$0a01a8c0@internetconnect.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I am new to postgres and I am having trouble hooking it up to a Microsoft
Access database via ODBC. I am able to CONNECT to the postgres database
server and have both tables appear in the "tables" section of Access. But
once I double click on one of the tables in MIcrosoft Access (which is an
empty table), all I get is a completly blank table where I can't even insert
a record. When I try double clicking on the other table (which has a single
record in it), Access complains "ODBC--call failed" without another
explanation dialogue box following it. I don't know why it would fail like
that.
Here are a few questions:
1) Where are the postgres log files? I see pg_log in /usr/local/pgsql/data,
but it seems to be encrypted or something
2) I notice in /usr/local/pgsql there is a file called "odbcinst.ini". Am I
supposed to alter this file?
3) Where in the Postgres manuals does it describe how to install an ODBC
connection. I can't seem to find it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Barnes | 2000-09-28 00:33:31 | RE: full text indexing |
| Previous Message | Steve Quezadas | 2000-09-27 23:46:55 | Postgres ODBC woes |