Problems using Insights ODBC with Microsoft Project - Mailing list pgsql-interfaces

From Pontus Lidman
Subject Problems using Insights ODBC with Microsoft Project
Date
Msg-id Pine.GSO.3.96rindlow.981001154531.20362B-100000@tinkerbell.lysator.liu.se
Whole thread Raw
List pgsql-interfaces
I get this error:

An unexpected error occurred
The database could not be initialized because it is not configured
correctly, it does not support required functionality, or it is not
installed on your computer.
Contact your system administrator for the database

when trying to save my project using the Machine ODBC in Microsoft Project
98. I'm using postgres 6.3 and a PsqlODBC about two weeks old.

The beginning (I hope that's the relevant part) of the psqlodbc.log is
attached below.

conn=31791936, SQLDriverConnect( in)='DSN=PostgreSQL;',
fDriverCompletion=1
DSN info:
DSN='PostgreSQL',server='193.45.212.122',port='5432',dbase='template1',user='pontus',passwd='pontus'

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings=''
          translation_dll='',translation_option=''
conn=31791936,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=template1;SERVER=193.45.212.122;PORT=5432;UID=pontus;PWD=pontus;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
Global Options: fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=4094
                disable_optimizer=1, unique_index=0, use_declarefetch=1
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn=31791936, query=' '
conn=31791936, query='set DateStyle to 'ISO''
conn=31791936, query='set geqo to 'OFF''
conn=31791936, query='BEGIN'
conn=31791936, query='declare SQL_CUR31850560 cursor for select oid from
pg_type where typname='lo''
conn=31791936, query='fetch 100 in SQL_CUR31850560'
    [ fetched 0 rows ]
conn=31791936, query='close SQL_CUR31850560'
conn=31791936, query='END'
CONN ERROR: func=SQLGetConnectOption, desc='fOption=108', errnum=5,
errmsg='Driver does not support getting this connect option'
            ------------------------------------------------------------
            henv=31786560, conn=31791936, status=1, num_stmts=16
            sock=31786576, stmts=31786624, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=400, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=31798232, buffer_out=31802336
            buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
STATEMENT ERROR: func=SQLSetStmtOption, desc='fOption=5, vParam=0',
errnum=10, errmsg='Driver does not support setting this statement option'

------------------------------------------------------------
                 hdbc=31791936, stmt=31916248, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(null)'
                 stmt_with_params=''
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info
-------------------------------
CONN ERROR: func=SQLSetStmtOption, desc='fOption=5, vParam=0', errnum=5,
errmsg='Driver does not support getting this connect option'
            ------------------------------------------------------------
            henv=31786560, conn=31791936, status=1, num_stmts=16
            sock=31786576, stmts=31786624, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=400, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=31798232, buffer_out=31802336
            buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2



pgsql-interfaces by date:

Previous
From: Andrea Antibo
Date:
Subject: jdbc driver
Next
From: "Apyo s.r.o."
Date:
Subject: bug in postodbc