Jump to content

Archived

This topic is now archived and is closed to further replies.

gurr

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 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!!

Share this post


Link to post
Share on other sites

×

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.