database migration problems - Mailing list pgsql-odbc

From Steven Sluter
Subject database migration problems
Date
Msg-id 20030106110455.S4778@sidehack.sat.gweep.net
Whole thread Raw
List pgsql-odbc
Hello-

I am attempting to migragte databases from MSDE to PostGreSQL for our
photo lab software.  I am getting several errors in the mylog file, and
was wondering if someone could help me out.  I am wondering if the
ODBC configuration is correct, or if there are problems in the program
itself.

I am connecting from a windows nt 4.0 box.  The database server is
FreeBSD 4.5 running postgresql-7.2.1_1.


Here is the first error I get in the mylog.log file.  It seems to suggest
some problem with the connection string I am using, though I am unsure.


[298]CC_connect: returning... [298]szConnStrOut =
'DSN=PostgreSQL;DATABASE=test_dp2;SERVER=192.168.0.1;PORT=5432;UID=steve;PWD=;
ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=1;
ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;
MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;
Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;
BoolsAsChar=0;Parse=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;
LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0'
len=500,1024 [298]PGAPI_DriverConnect: returning 0

[298][SQLError][298]**** PGAPI_Error: henv=0, hdbc=209350000 hstmt=0
[298]**** PGAPI_ConnectError: hdbc=209350000 <512> [298]enter CC_get_error
[298]enter CC_create_errormsg [298]msg = '' [298]exit CC_create_errormsg
[298]exit CC_get_error [298]CC_Get_error returned nothing. [298]****
PGAPI_Error exit code=100





The second error seems to be a problem with one of the querrys from the
client program:


[298][SQLColAttributes][298]PGAPI_ColAttributes: entering..col=1 11 len=0.
[298]colAttr: col 0 field_type = 1042 [298]AUTO_INCREMENT=0
[298][SQLColAttributes][298]PGAPI_ColAttributes: entering..col=2 1 len=33.
[298]colAttr: col 1 field_type = 1042 [298]PGAPI_ColAttr: COLUMN_NAME =
'username' [298][SQLColAttributes][298]PGAPI_ColAttributes:
entering..col=2 15 len=33. [298]colAttr: col 1 field_type = 1042
[298]PGAPI_ColAttr: TABLE_NAME = 'usertasks'
[298][SQLColAttributes][298]PGAPI_ColAttributes: entering..col=2 17
len=129. [298]colAttr: col 1 field_type = 1042
[298][SQLColAttributes][298]PGAPI_ColAttributes: entering..col=2 16
len=129. [298]colAttr: col 1 field_type = 1042
[298][SQLColAttributes][298]PGAPI_ColAttributes: entering..col=2 1212
len=0. [298]colAttr: col 1 field_type = 1042 [298][SQLError][298]****
PGAPI_Error: henv=0, hdbc=0 hstmt=209387808 [298]**** PGAPI_StmtError:
hstmt=209387808 <512> [298]SC_get_error: status = 32, msg = #this request
may be for MS SQL Server# [298] szSqlState = 'HYC00',len=37, szError='this
request may be for MS SQL Server' [298]**** PGAPI_Error exit code=0
[298][SQLError][298]**** PGAPI_Error: henv=0, hdbc=0 hstmt=209387808
[298]**** PGAPI_StmtError: hstmt=209387808 <512> [298]SC_Get_error
returned nothing. [298]**** PGAPI_Error exit code=100



Any information/help you can give me would be greatly appreciated.


Steve Sluter
Printmakers, Inc.

pgsql-odbc by date:

Previous
From: "Jim Holliday"
Date:
Subject: Re: bug in info.c file - incorrect SQL
Next
From: "Pablo Aranda"
Date:
Subject: Replacing Oracle 8i