Received: from md3.vsnl.net.in (md3.vsnl.net.in [202.54.6.35]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA89191 for ; Fri, 15 Oct 1999 21:33:42 -0400 (EDT) (envelope-from lakshmianand@vsnl.com) Received: from aptiva ([210.212.251.24]) by md3.vsnl.net.in (8.9.3/8.9.3) with SMTP id HAA03054 for ; Sat, 16 Oct 1999 07:01:19 GMT Message-ID: <00e601bf1776$6cab2b00$0301a8c0@aptiva> From: "Lakshmi Anand K." To: Subject: ODBC Problem - Please help Date: Fri, 15 Oct 1999 06:23:32 +0530 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0031_01BF16D5.CDD50C80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_0031_01BF16D5.CDD50C80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Err . . . Am new to postgres and this list. I am using the ODBC Driver from Insight Corp Version 6.40.00.04 and Postgres Version 6.5.1-2. I am having Win 98 clients and want to access Postgres via ODBC. Now, am able to access it with psql from the server. When I try to use it from Access, VFP, VB it creates problems. Access 2000: It simply says cannot open the table in datasheet view. VB: Am able to access as dynaset or snapshot but when I try to use SQLPassthru, then I get error messages that the call failed. VFP: Am able to access properly but get error messages often. It seems as if garbage statements with parse errors are sent to the backend. I have attached a sample log file. Please help. *-*-* Lakshmi Anand K. ------=_NextPart_000_0031_01BF16D5.CDD50C80 Content-Type: application/octet-stream; name="psqlodbc_4294639205.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc_4294639205.log" conn=3D31981688, SQLDriverConnect( = in)=3D'DSN=3DTET;UID=3Dpostgres;PWD=3D;Database=3Dtest;', = fDriverCompletion=3D1 DSN info: = DSN=3D'TET',server=3D'server',port=3D'5432',dbase=3D'test',user=3D'postgr= es',passwd=3D'' = readonly=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D31981688, query=3D' ' conn=3D31981688, query=3D'set DateStyle to 'ISO'' conn=3D31981688, query=3D'set geqo to 'OFF'' conn=3D31981688, query=3D'set ksqo to 'ON'' conn=3D31981688, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D31981688, = SQLDriverConnect(out)=3D'DSN=3DTET;DATABASE=3Dtest;SERVER=3Dserver;PORT=3D= 5432;UID=3Dpostgres;PWD=3D;READONLY=3D1;PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;S= HOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D' conn=3D31981688, query=3D'SELECT Config, nValue FROM MSysConf' ERROR from backend during send_query: 'ERROR: msysconf: Table does not = exist.' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D31981688, stmt=3D31996216, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'SELECT Config, nValue = FROM MSysConf' stmt_with_params=3D'SELECT Config, nValue FROM = MSysConf' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01E83938' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = msysconf: Table does not exist.' ------------------------------------------------------------ henv=3D33030276, conn=3D31981688, status=3D1, num_stmts=3D16 sock=3D33030292, stmts=3D33030332, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D244, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D31988016, buffer_out=3D31992116 buffer_filled_in=3D42, buffer_filled_out=3D0, = buffer_read_in=3D42 conn=3D31981688, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D31981688, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D31981688, query=3D'godisgreat' ERROR from backend during send_query: 'ERROR: parser: parse error at or = near "godisgreat"' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D31981688, stmt=3D31996216, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D-1, statement=3D'godisgreat' stmt_with_params=3D'godisgreat' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01E83938' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = parser: parse error at or near "godisgreat"' ------------------------------------------------------------ henv=3D33030276, conn=3D31981688, status=3D1, num_stmts=3D16 sock=3D33030292, stmts=3D33030332, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D244, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D31988016, buffer_out=3D31992116 buffer_filled_in=3D55, buffer_filled_out=3D0, = buffer_read_in=3D54 conn=3D31996216, SQLDriverConnect( = in)=3D'DSN=3DTET;UID=3Dpostgres;PWD=3D;DATABASE=3Dtest;SERVER=3Dserver;PO= RT=3D5432;READONLY=3D1;PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;= ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D;', = fDriverCompletion=3D1 DSN info: = DSN=3D'TET',server=3D'server',port=3D'5432',dbase=3D'test',user=3D'postgr= es',passwd=3D'' = readonly=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D31996216, query=3D' ' conn=3D31996216, query=3D'set DateStyle to 'ISO'' conn=3D31996216, query=3D'set geqo to 'OFF'' conn=3D31996216, query=3D'set ksqo to 'ON'' conn=3D31996216, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D31996216, = SQLDriverConnect(out)=3D'DSN=3DTET;DATABASE=3Dtest;SERVER=3Dserver;PORT=3D= 5432;UID=3Dpostgres;PWD=3D;READONLY=3D1;PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;S= HOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D' conn=3D31996216, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'godisgreat' = order by attnum' [ fetched 3 rows ] conn=3D32011492, SQLDriverConnect( = in)=3D'DRIVER=3D{PostgreSQL};UID=3Dpostgres;PWD=3D;Server=3Dserver;Databa= se=3Dtest;', fDriverCompletion=3D1 Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D32011492, query=3D' ' conn=3D32011492, query=3D'set DateStyle to 'ISO'' conn=3D32011492, query=3D'set geqo to 'OFF'' conn=3D32011492, query=3D'set ksqo to 'ON'' conn=3D32011492, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D32011492, = SQLDriverConnect(out)=3D'DRIVER=3D{PostgreSQL};DATABASE=3Dtest;SERVER=3Ds= erver;PORT=3D5432;UID=3Dpostgres;PWD=3D;READONLY=3D1;PROTOCOL=3D6.4;FAKEO= IDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONN= SETTINGS=3D' conn=3D32011492, query=3D'SELECT Config, nValue FROM MSysConf' ERROR from backend during send_query: 'ERROR: msysconf: Table does not = exist.' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D32011492, stmt=3D32127736, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'SELECT Config, nValue = FROM MSysConf' stmt_with_params=3D'SELECT Config, nValue FROM = MSysConf' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01EA3AF8' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = msysconf: Table does not exist.' ------------------------------------------------------------ henv=3D33030276, conn=3D32011492, status=3D1, num_stmts=3D16 sock=3D32010852, stmts=3D32010892, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D268, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D32017820, buffer_out=3D32021920 buffer_filled_in=3D43, buffer_filled_out=3D0, = buffer_read_in=3D42 conn=3D31996216, SQLDisconnect conn=3D32011492, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D32011492, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D32011492, query=3D'godisgreat' ERROR from backend during send_query: 'ERROR: parser: parse error at or = near "godisgreat"' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D32011492, stmt=3D32061996, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D-1, statement=3D'godisgreat' stmt_with_params=3D'godisgreat' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01E93A2C' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = parser: parse error at or near "godisgreat"' ------------------------------------------------------------ henv=3D33030276, conn=3D32011492, status=3D1, num_stmts=3D16 sock=3D32010852, stmts=3D32010892, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D268, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D32017820, buffer_out=3D32021920 buffer_filled_in=3D54, buffer_filled_out=3D0, = buffer_read_in=3D54 conn=3D32011492, query=3D'godisgreat' ERROR from backend during send_query: 'ERROR: parser: parse error at or = near "godisgreat"' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D32011492, stmt=3D32061996, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D-1, statement=3D'godisgreat' stmt_with_params=3D'godisgreat' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01E93A2C' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = parser: parse error at or near "godisgreat"' ------------------------------------------------------------ henv=3D33030276, conn=3D32011492, status=3D1, num_stmts=3D16 sock=3D32010852, stmts=3D32010892, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D268, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D32017820, buffer_out=3D32021920 buffer_filled_in=3D54, buffer_filled_out=3D0, = buffer_read_in=3D54 conn=3D32011492, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D32011492, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 30 rows ] conn=3D32011492, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'godisgreat' = order by attnum' [ fetched 3 rows ] conn=3D32011492, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'godisgreat' = order by attnum' [ fetched 3 rows ] conn=3D32011492, query=3D'select c.relname, i.indkey, i.indisunique, = i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid =3D = i.indexrelid and d.relname =3D 'godisgreat' and d.oid =3D i.indrelid' [ fetched 0 rows ] conn=3D31996216, SQLDriverConnect( = in)=3D'DRIVER=3D{PostgreSQL};UID=3Dpostgres;PWD=3D;DATABASE=3Dtest;SERVER= =3Dserver;PORT=3D5432;READONLY=3D1;PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOI= DCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D;', = fDriverCompletion=3D0 Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D31996216, query=3D' ' conn=3D31996216, query=3D'set DateStyle to 'ISO'' conn=3D31996216, query=3D'set geqo to 'OFF'' conn=3D31996216, query=3D'set ksqo to 'ON'' conn=3D31996216, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D31996216, SQLDriverConnect(out)=3D'(null)' conn=3D31996216, query=3D'SELECT "godisgreat" ,"name" ,"test" FROM = "godisgreat" ' [ fetched 2 rows ] conn=3D31996216, SQLDisconnect conn=3D32011492, SQLDisconnect conn=3D31981688, SQLDisconnect ------=_NextPart_000_0031_01BF16D5.CDD50C80--