ODBC, Win2K, CygWin, and PostgreSQL - Mailing list pgsql-cygwin
| From | Steve Long |
|---|---|
| Subject | ODBC, Win2K, CygWin, and PostgreSQL |
| Date | |
| Msg-id | 004001c13c84$52f48230$cd0a3d42@slongt20 Whole thread Raw |
| Responses |
Re: [ODBC] ODBC, Win2K, CygWin, and PostgreSQL
|
| List | pgsql-cygwin |
i have installed the latest cygwin, cygipc, postegresql, and postgres ODBC on a wintel platform (Win2K Pro, intel x86). everything postgres related works fine within the cygwin environment.
while a cygwin process is running with postgres and ipc-daemon running under it, i then launch from Win2K on the same machine a windoz application which uses ODBC to connect to the postgres instance under cygwin. however, i have been unable to successfully connect to the postgres instance from the windoz app thru odbc.
aside from defining the odbc connection thru the win2k odbc manager, is there anything else i need to do? the error message in the log says, "bindings were not allocated properly."
the pg_hba.conf allows any user from any ip/subnet (host all 0.0.0.0 0.0.0.0 trust).
below is a log from the odbc session.
tia!
conn=13908040, SQLDriverConnect( in)='DRIVER=PostgreSQL};
UID=Administrator;CONNSETTINGS=;SHOWSYSTEMTABLES=1;ROWVERSIONING=0;
SHOWOIDCOLUMN=1;FAKEOIDINDEX=0;PROTOCOL=6.4;READONLY=0;PORT=5432;
SERVER=slong-t20;DATABASE=template1;', fDriverCompletion=2
Global Options: Version='07.01.0005', fetch=1024, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1
extra_systable_prefixes='pg_; dd_;', conn_settings=''
conn=13908040, query=' '
conn=13908040, query='set DateStyle to 'ISO''
conn=13908040, query='set ksqo to 'ON''
conn=13908040, query='select oid from pg_type where typname='lo''
[ Large Object oid = 0 ]
conn=13908040, query='select version()'
Command response: 'C 2.95.3-5CSELECT'
STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Bindings were not allocated properly.'
------------------------------------------------------------
hdbc=13908040, stmt=13923200, result=13923072
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='select version()'
stmt_with_params='select version()'
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='SQL_CUR00D47380'
----------------QResult Info -------------------------------
fields=13923160, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=1, inTuples=0
CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg='(NULL)'
------------------------------------------------------------
henv=13903648, conn=13908040, status=0, num_stmts=16
sock=13903672, stmts=13922720, lobj_type=0
---------------- Socket Info -------------------------------
socket=460, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=13914512, buffer_out=13918616
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=13908040, SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;
Global Options: Version='07.01.0005', fetch=1024, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1, bools_as_char=1
extra_systable_prefixes='pg_; dd_;', conn_settings=''
conn=13908040, query=' '
conn=13908040, query='set DateStyle to 'ISO''
conn=13908040, query='set ksqo to 'ON''
conn=13908040, query='select oid from pg_type where typname='lo''
[ Large Object oid = 0 ]
conn=13908040, query='select version()'
Command response: 'C 2.95.3-5CSELECT'
STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Bindings were not allocated properly.'
------------------------------------------------------------
hdbc=13908040, stmt=13923200, result=13923072
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='select version()'
stmt_with_params='select version()'
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='SQL_CUR00D47380'
----------------QResult Info -------------------------------
fields=13923160, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=1, inTuples=0
CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg='(NULL)'
------------------------------------------------------------
henv=13903648, conn=13908040, status=0, num_stmts=16
sock=13903672, stmts=13922720, lobj_type=0
---------------- Socket Info -------------------------------
socket=460, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=13914512, buffer_out=13918616
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=13908040, SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=template1;
SERVER=slong-t20;PORT=5432;UID=Administrator;PWD=;READONLY=0;
PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;
SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=13908040, SQLDisconnect
conn=13908040, SQLDisconnect
pgsql-cygwin by date: