gurr

Information: Local network (TCP/IP) XP pc with MS Access Fedora Core 4 pc with Postgresql I want the XP pc through Access to be able to import the Postgres databases on the Linux machine. What I already installed and changed: Linux machine: 1. pg_hba.conf local all all trust host all all 127.0.0.1/32 trust host sameuser all 127.0.0.1 255.255.255.255 trust host test1 chris 192.168.0.0 255.255.255.0 md5 host sameuser all 192.168.0.0 255.255.255.0 md5 2. I created a postgresql user for hosts. XP pc: 1.Installed pgsqodb-08_01_200.zip 2.Configuring the ODBC driver and MS Access is to be used, I have set: Selected USER DSN with: Data Source : test1-dsn Database : test1 Server : 192.168.0.1 SSL mode : disabled Port : 5432 Username and password being entered at login Options, Datasource, page 1: Disable Genetic Optimizer: yes Keyset Query Optimization: yes Recognize Unique Indexes: yes Use Declare/Fetch: yes CommLog: yes Parse Statements: yes Cancel as FreeStmt: no MyLog: yes Unknown Sizes: Maximum Text as LongVarChar: yes Unknowns as LongVarChar: no Bool as Char: yes Max Varchar: 254 Max LongVarChar: 8190 Cache Size: 100 SysTable Prefixes: dd_; Options, Datasource, page 2: Read Only: no Show System Tables: no LF <-> CR/LF conversion: yes Updatable Cursors: yes bytea as LO: no Row Versioning: no Disallow Premature: no True is -1: yes Server side prepare: no Int8 As: default OID Options: (none checked) Connect Settings: (blank) Problem: When I open MS Access , create new db, go to where I select Machine Data Source and select test1-dsn, enter my user name and press OK. Access just hangs with this in postgres log file:CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=30002', errnum=205, sqlstate=, errmsg='Unknown connect option (Get)' !Any ideas are welcome!! !!Thanks in Advance!!