From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: applixware-list@applix.com, Postgres Interfaces Mailing List <pgsql-interfaces@postgresql.org>
Subject: Re: AWL: postgres odbc woes, continued .......
Date: Fri, 15 Jan 1999 02:26:14 +0000
Message-ID: <369EA745.BA3B2E5C@alumni.caltech.edu> (raw)
References: <369D5D0E.AA522E2C@quoll.com>
> Any thoughts would be greatly appreciated.
I'm having trouble running the development tree version of psqlODBC.
Picking up the odbc source code from the v6.4 Postgres tarball and
inserting it into src/interfaces/odbc gives me back a driver which seems
to work.
Byron, do you have any ideas on what might have changed? I vaguely
recall that the newest code is using v6.4 protocol, and the v6.4 tarball
code was using the v6.3.2 protocol?? I've enclosed my log files.
TIA
- Tom
Attachments:mylog_tgl2539.log (text/plain, 665B) download
globals.extra_systable_prefixes = 'dd_;'
CC_connect: entering...
CC_connect(): DSN = 'Test', server = 'localhost', port = '', database = 'test', username = 'tgl', password='no$way'
connecting to the server socket...
connection to the server socket failed.
CONN ERROR: func=SQLConnect, desc='Error on CC_connect', errnum=101, errmsg='Could not connect to the server'
**** SQLError: henv=0, hdbc=134613032, hstmt=0
calling CC_get_error
enter CC_get_error
enter CC_create_errormsg
msg = 'Could not connect to the server'
exit CC_create_errormsg
exit CC_get_error
CC_get_error: status = 101, msg = #Could not connect to the server;
Could not connect to remote socket.#
psqlodbc_tgl2539.log (text/plain, 1.2K) download
DSN info: DSN='Test',server='localhost',port='5432',dbase='test',user='tgl',passwd='no$way'
readonly='0',protocol='',showoid='',fakeoidindex='',showsystable=''
conn_settings=''
translation_dll='',translation_option=''
conn = 134613032, SQLConnect(DSN='Test', UID='tgl', PWD='no$way')
Global Options: Version='06.40.0002', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
CONN ERROR: func=SQLConnect, desc='Error on CC_connect', errnum=101, errmsg='Could not connect to the server'
------------------------------------------------------------
henv=134613016, conn=134613032, status=0, num_stmts=16
sock=134619360, stmts=134627608, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=4, errormsg='Could not connect to remote socket.'
buffer_in=134619400, buffer_out=134623504
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, byronn@insightdist.com
Subject: Re: AWL: postgres odbc woes, continued .......
In-Reply-To: <369EA745.BA3B2E5C@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox