Re: database migration problems

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/