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!! Quote Link to comment https://forums.phpfreaks.com/topic/5704-postgresql-odbc-and-ms-access/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.