Message-ID: <36132609.DD39D8B0@mchep.osrhe.edu>
Date: Thu, 01 Oct 1998 01:49:48 -0500
From: Keith Tucker <ktucker@mchep.osrhe.edu>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Problem connecting to database engine with ODBC through Access 97
Content-Type: multipart/mixed; boundary="------------B2525AFFCCF59C412E918DE9"

This is a multi-part message in MIME format.
--------------B2525AFFCCF59C412E918DE9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I am running PostgreSQL version 6.3.2 on Linux 2.0.30 running on I486
with 40 meg RAM.  I have installed PsqlODBC version 6.30.0249 on Windows
95 OEM version 4.00.950 B with 16 MEG of RAM.  The database engine seems
to be running on the Linux box just fine, I can use psql to connect to
my database called "test".  This has one table  with 2 fields and I can
manipulate data just fine from here.  I want to connect to this database
with MS Access 97 from my win 95 machine.  The two machines are
connected with 10MBS ethernet.  The name of my database server machine
in c:\windows\host is kndata (for Kiamichi Net Database).  I can ping
this machine and telnet to it just fine.  The psqlodbc driver seemed to
install on my Win95 machine just fine.  After configuring the data
source and trying to access my database on kndata using MS Access, I get
the following message windows.  The first one is:  "ODBC--call failed".
After clicking OK, another window comes up that says (in two lines):
"Could not connect to server;
(next line) Could not connect to the remote socket (#1)".  Everything
seems to be happening as expected up to this point.  Any help would be
appreciated.  I have enclosed the commlog as requested.  Thank you in
advance.


Keith Tucker

ktucker@mchep.osrhe.edu

--------------B2525AFFCCF59C412E918DE9
Content-Type: text/plain; charset=us-ascii; name="psqlodbc.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="psqlodbc.log"

DSN info: DSN='Kiamichi Net Test Database',server='kndata',port='5432',dbase='test',user='postgres',passwd='postgres'
          readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='1'
          conn_settings=''
          translation_dll='',translation_option=''

--------------B2525AFFCCF59C412E918DE9--