Jump to content

Postgresql ODBC and MS Access


Recommended Posts

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 trust
host sameuser all trust
host test1 chris md5
host sameuser all 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 :
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!!
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.