gurr Posted March 24, 2006 Share Posted March 24, 2006 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.conflocal all all trusthost all all 127.0.0.1/32 trusthost sameuser all 127.0.0.1 255.255.255.255 trusthost test1 chris 192.168.0.0 255.255.255.0 md5host sameuser all 192.168.0.0 255.255.255.0 md52. I created a postgresql user for hosts.XP pc:1.Installed pgsqodb-08_01_200.zip2.Configuring the ODBC driver and MS Access is to be used, I have set: Selected USER DSN with: Data Source : test1-dsn Database : test1Server : 192.168.0.1 SSL mode : disabledPort : 5432Username 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: yesCancel 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 Sourceand 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!! Link to comment https://forums.phpfreaks.com/topic/5704-postgresql-odbc-and-ms-access/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.