Thread: database migration problems

database migration problems

From
Steven Sluter
Date:
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.

Re: database migration problems

From
Hiroshi Inoue
Date:
Steven Sluter wrote:
>
> 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


AFAIK neither is harmful.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/