ODBC, Win2K, CygWin, and PostgreSQL

From: "Steve Long" <steve-long(at)mediaone(dot)net>
To: <pgsql-cygwin(at)postgresql(dot)org>, <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC, Win2K, CygWin, and PostgreSQL
Date: 2001-09-13 18:45:56
Message-ID: 004001c13c84$52f48230$cd0a3d42@slongt20
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-odbc

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

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Robert J. Sanford, Jr. 2001-09-14 14:50:46 performance optimizations?
Previous Message Jason Tishler 2001-09-11 13:34:25 Re: installing postgresql on win2000

Browse pgsql-odbc by date

  From Date Subject
Next Message Mike Renfro 2001-09-13 19:07:10 Re: secure ODBC connection
Previous Message Douglas Bates 2001-09-13 17:08:44 Installation of pgAdmin