pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Error
3+ messages / 3 participants
[nested] [flat]
* ODBC Error
@ 1998-07-22 21:09 Steve Pratt <steve.sheliak@virgin.net>
1998-07-22 21:44 ` Re: [INTERFACES] ODBC Error Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 3+ messages in thread
From: Steve Pratt @ 1998-07-22 21:09 UTC (permalink / raw)
To: pgsql-interfaces
I have installed PsqlODBC on a Win95 PC. On my Linux box there is a db
called mydb, owner steve.
The plan is to make use of Topspeed Clarion application generator on the WIn
pc. There is an import function in the gui to pull in the structure of an
ODBC compliant server. But the error message is as follows:
"ODBC file import:
Failed to authenticate client as Postgres user 'steve' <unknown
authentication type>: be_recvauth: unrecognized message type: 65536"
I guess it won't be Postgres' fault, but has anyone seen this type of
problem before?
Sorry if this is too far off topic, but thanks anyway
Steve
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC Error
1998-07-22 21:09 ODBC Error Steve Pratt <steve.sheliak@virgin.net>
@ 1998-07-22 21:44 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 1998-07-22 21:44 UTC (permalink / raw)
To: Steve Pratt <steve.sheliak@virgin.net>; +Cc: pgsql-interfaces
Steve Pratt wrote:
>
> I have installed PsqlODBC on a Win95 PC. On my Linux box there is a db
> called mydb, owner steve.
> The plan is to make use of Topspeed Clarion application generator on the WIn
> pc. There is an import function in the gui to pull in the structure of an
> ODBC compliant server. But the error message is as follows:
> "ODBC file import:
> Failed to authenticate client as Postgres user 'steve' <unknown
> authentication type>: be_recvauth: unrecognized message type: 65536"
>
> I guess it won't be Postgres' fault, but has anyone seen this type of
> problem before?
> Sorry if this is too far off topic, but thanks anyway
>
> Steve
BTW, this question is directly answered in our psqlodbc faq on our web
page http://www.insightdist.com/psqlodbc.
But the short of it is, you have a protocol mismatch between your
backend and the odbc driver.
Most likely, you have postgres 6.2 on the backend and the odbc driver is
speaking in 6.3 protocol.
If you are using the correct driver (something like version 6.30.0247),
then try setting the "6.2 protocol" setting on the Advanced Datasource
options for your datasource.
If you are using an ancient driver (postODBC), then upgrade to the one
on our website.
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
* ODBC error
@ 1999-12-01 12:35 Jeroen Schellart <JSchellart@uno.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Jeroen Schellart @ 1999-12-01 12:35 UTC (permalink / raw)
To: pgsql-interfaces
When I try to export a table ty my postgres server i get the follow error
message:
ODB--call failed
Next screen:
Error creating the table:
ERROR: Unable to locate the the type name 'lo' in catalog (#17)
I have tried two different tables, one large and one simple (Just one collumn)
Do yuo have a solution for this problem?
ODBC driver version: 6.40.0006
Database version: 6.5
Thnx,
jeroen Schellart
Jeroen Schellart
UnO Automatiseringdiensten BV
1e van der Kunstraat 292
2521 AV Den Haag
tel: 070-3300502
fax: 070-3300489
Attachments:
psqlodbc_204.log (text/plain, 12.4K) download
conn=149369392, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=149369392, query=' '
conn=149369392, query='set DateStyle to 'ISO''
conn=149369392, query='set ksqo to 'ON''
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E80040 cursor for select oid from pg_type where typname='lo''
conn=149369392, query='fetch 100 in SQL_CUR08E80040'
[ fetched 0 rows ]
conn=149369392, query='close SQL_CUR08E80040'
conn=149369392, query='END'
conn=149369392, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E80040 cursor for SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
conn=149369392, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=149369392, stmt=149422144, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='declare SQL_CUR08E80040 cursor for SELECT Config, nValue FROM MSysConf'
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_CUR08E80040'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=149369376, conn=149369392, status=1, num_stmts=16
sock=149375728, stmts=149383984, lobj_type=-999
---------------- Socket Info -------------------------------
socket=348, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=149375776, buffer_out=149379880
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E90110 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
conn=149369392, query='fetch 100 in SQL_CUR08E90110'
[ fetched 36 rows ]
conn=149369392, query='close SQL_CUR08E90110'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for 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) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'Adres gegevens' order by attnum'
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
[ fetched 5 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EC2088 cursor for 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) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'Adres gegevens' order by attnum'
conn=149369392, query='fetch 100 in SQL_CUR08EC2088'
[ fetched 5 rows ]
conn=149369392, query='close SQL_CUR08EC2088'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EB1FB8 cursor for select c.relname, i.indkey, i.indisunique, i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid = i.indexrelid and d.relname = 'Adres gegevens' and d.oid = i.indrelid'
conn=149369392, query='fetch 100 in SQL_CUR08EB1FB8'
[ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EB1FB8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for SELECT "Adres gegevens"."Volgnr" FROM "Adres gegevens" '
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
[ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for SELECT "Voornaam","Achternaam","Straat","Nummer","Volgnr" FROM "Adres gegevens" WHERE "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1'
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
[ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149389320, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=149389320, query=' '
conn=149389320, query='set DateStyle to 'ISO''
conn=149389320, query='set ksqo to 'ON''
conn=149389320, query='BEGIN'
conn=149389320, query='declare SQL_CUR08EA1EE8 cursor for select oid from pg_type where typname='lo''
conn=149389320, query='fetch 100 in SQL_CUR08EA1EE8'
[ fetched 0 rows ]
conn=149389320, query='close SQL_CUR08EA1EE8'
conn=149389320, query='END'
conn=149389320, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=149389320, query='BEGIN'
conn=149389320, query='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
ERROR from backend during send_query: 'ERROR: Unable to locate type name 'lo' in catalog'
conn=149389320, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table'
------------------------------------------------------------
hdbc=149389320, stmt=149561064, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
stmt_with_params='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
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_CUR08EA1EE8'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Unable to locate type name 'lo' in catalog'
------------------------------------------------------------
henv=149369376, conn=149389320, status=1, num_stmts=16
sock=149388392, stmts=149554944, lobj_type=-999
---------------- Socket Info -------------------------------
socket=332, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=149555936, buffer_out=149395656
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=149389320, SQLDisconnect
conn=149369392, SQLDisconnect
psqlodbc_246.log (text/plain, 268B) download
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
psqlodbc_253.log (text/plain, 7.9K) download
conn=28914224, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=28914224, query=' '
conn=28914224, query='set DateStyle to 'ISO''
conn=28914224, query='set ksqo to 'ON''
conn=28914224, query='BEGIN'
conn=28914224, query='declare SQL_CUR01BA0040 cursor for select oid from pg_type where typname='lo''
conn=28914224, query='fetch 100 in SQL_CUR01BA0040'
[ fetched 0 rows ]
conn=28914224, query='close SQL_CUR01BA0040'
conn=28914224, query='END'
conn=28914224, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=28914224, query='BEGIN'
conn=28914224, query='declare SQL_CUR01BA0040 cursor for SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
conn=28914224, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=28914224, stmt=28966976, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='declare SQL_CUR01BA0040 cursor for SELECT Config, nValue FROM MSysConf'
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_CUR01BA0040'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=28914208, conn=28914224, status=1, num_stmts=16
sock=28920560, stmts=28928816, lobj_type=-999
---------------- Socket Info -------------------------------
socket=352, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=28920608, buffer_out=28924712
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=28914224, query='BEGIN'
conn=28914224, query='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
ERROR from backend during send_query: 'ERROR: Unable to locate type name 'lo' in catalog'
conn=28914224, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table'
------------------------------------------------------------
hdbc=28914224, stmt=28966976, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
stmt_with_params='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
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_CUR01BA0040'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Unable to locate type name 'lo' in catalog'
------------------------------------------------------------
henv=28914208, conn=28914224, status=1, num_stmts=16
sock=28920560, stmts=28928816, lobj_type=-999
---------------- Socket Info -------------------------------
socket=352, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=28920608, buffer_out=28924712
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=29101184, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=29101184, query=' '
conn=29101184, query='set DateStyle to 'ISO''
conn=29101184, query='set ksqo to 'ON''
conn=29101184, query='BEGIN'
conn=29101184, query='declare SQL_CUR01BA0040 cursor for select oid from pg_type where typname='lo''
conn=29101184, query='fetch 100 in SQL_CUR01BA0040'
[ fetched 0 rows ]
conn=29101184, query='close SQL_CUR01BA0040'
conn=29101184, query='END'
conn=29101184, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=29101184, query='BEGIN'
conn=29101184, query='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
ERROR from backend during send_query: 'ERROR: Unable to locate type name 'lo' in catalog'
conn=29101184, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table'
------------------------------------------------------------
hdbc=29101184, stmt=28966976, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
stmt_with_params='CREATE TABLE "Sector"("s_Generation" int4,"s_GUID" bytea,"s_Lineage" lo,"Sector" varchar(10))'
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_CUR01BA0040'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Unable to locate type name 'lo' in catalog'
------------------------------------------------------------
henv=28914208, conn=29101184, status=1, num_stmts=16
sock=28930496, stmts=28931080, lobj_type=-999
---------------- Socket Info -------------------------------
socket=428, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=28932416, buffer_out=28936520
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=29101184, SQLDisconnect
conn=28914224, SQLDisconnect
end of thread, other threads:[~1999-12-01 12:35 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-22 21:09 ODBC Error Steve Pratt <steve.sheliak@virgin.net>
1998-07-22 21:44 ` Byron Nikolaidis <byronn@insightdist.com>
1999-12-01 12:35 ODBC error Jeroen Schellart <JSchellart@uno.nl>
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