Subject | Still can't get port 3051 to work |
---|---|
Author | Steve Harp |
Post date | 2005-08-17T01:10:24Z |
Hi All,
I have to get Firebird 1.52 working on port 3051 because Interbase 7.1
is on port 3050. Here's what I've done.
1. Modified firebird.conf to set RemoteServicePort = 3051
2. Modified firebird.conf to set OldParameterOrdering = 0 (I've tried
0 and 1 and niether has any effect).
3. Restarted Firebird service after each change.
4. Configured by TIB_Connection.Server property to be '127.0.0.1/3051'
5. Modified application to add unit file with
IB_Constants.IB_GDS32 := 'FBCLIENT.DLL'; as first unit file in uses
statement of dpr.
6. Renamed gds32.dll to make sure that fbclient.dll was being used.
7. Made sure that no other copies of gds32.dll exist on customer's
machine.
8. Made sure that both my computer and my customer's computers are
both running the same version of Firebird, the same application
executable, and the same database (FDB) file.
My application appears to be getting connected. However, when trying
to prepare (TIB_DSQL.Prepare;) my stored procedures after connection,
I get an error:
************************************
* SQL Error: 08/16/2005 09:06 PM *
************************************
Error Code: 335544569
Error Message:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
parameter mismatch for procedure SPUPDATECABINET
STATEMENT:
TIB_DSQL: "<TApplication>.DM.spUpdateCabinet."
Error Codes:
335544569
1
335544512
SQL Code: -902
SQL Message:
SQL ERROR CODE:-902
SQL ERROR MESSAGE:
Unsuccessful execution caused by a system error that
precludes
successful execution of subsequent statements
SQL:
execute procedure spUpdateCabinet(? /* pID */ ,
? /* pName */ ,
? /* pWidth */ ,
? /* pHeight */ ,
? /* pDepth */ ,
? /* pCubeWTFactor */ ,
? /* pCubeWT2 */ ,
? /* pDoorSF */ ,
? /* pDrawerSF */ ,
? /* pSidesSF */ ,
? /* pShelveSF */ ,
? /* pTopBottomSF */ ,
? /* pFrontEdgeLF */ ,
? /* pDoorEdgeLF */ ,
? /* pDrawerEdgeLF */ ,
? /* pSupportRailCnt */ ,
? /* pShelfClipCnt */ ,
? /* pBack */ ,
? /* pDoorCnt */ ,
? /* pShelveCnt */ ,
? /* pDrawerCnt */ ,
? /* pHingeCnt */ ,
? /* pBumperCnt */ ,
? /* pDrawerSlideCnt */ ,
? /* pDelete */ );
**************************************************
How can this erro occur on my customer's computer everytime the
application starts and never on my machine? What else could be different?
Thanks,
Steve
I have to get Firebird 1.52 working on port 3051 because Interbase 7.1
is on port 3050. Here's what I've done.
1. Modified firebird.conf to set RemoteServicePort = 3051
2. Modified firebird.conf to set OldParameterOrdering = 0 (I've tried
0 and 1 and niether has any effect).
3. Restarted Firebird service after each change.
4. Configured by TIB_Connection.Server property to be '127.0.0.1/3051'
5. Modified application to add unit file with
IB_Constants.IB_GDS32 := 'FBCLIENT.DLL'; as first unit file in uses
statement of dpr.
6. Renamed gds32.dll to make sure that fbclient.dll was being used.
7. Made sure that no other copies of gds32.dll exist on customer's
machine.
8. Made sure that both my computer and my customer's computers are
both running the same version of Firebird, the same application
executable, and the same database (FDB) file.
My application appears to be getting connected. However, when trying
to prepare (TIB_DSQL.Prepare;) my stored procedures after connection,
I get an error:
************************************
* SQL Error: 08/16/2005 09:06 PM *
************************************
Error Code: 335544569
Error Message:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
parameter mismatch for procedure SPUPDATECABINET
STATEMENT:
TIB_DSQL: "<TApplication>.DM.spUpdateCabinet."
Error Codes:
335544569
1
335544512
SQL Code: -902
SQL Message:
SQL ERROR CODE:-902
SQL ERROR MESSAGE:
Unsuccessful execution caused by a system error that
precludes
successful execution of subsequent statements
SQL:
execute procedure spUpdateCabinet(? /* pID */ ,
? /* pName */ ,
? /* pWidth */ ,
? /* pHeight */ ,
? /* pDepth */ ,
? /* pCubeWTFactor */ ,
? /* pCubeWT2 */ ,
? /* pDoorSF */ ,
? /* pDrawerSF */ ,
? /* pSidesSF */ ,
? /* pShelveSF */ ,
? /* pTopBottomSF */ ,
? /* pFrontEdgeLF */ ,
? /* pDoorEdgeLF */ ,
? /* pDrawerEdgeLF */ ,
? /* pSupportRailCnt */ ,
? /* pShelfClipCnt */ ,
? /* pBack */ ,
? /* pDoorCnt */ ,
? /* pShelveCnt */ ,
? /* pDrawerCnt */ ,
? /* pHingeCnt */ ,
? /* pBumperCnt */ ,
? /* pDrawerSlideCnt */ ,
? /* pDelete */ );
**************************************************
How can this erro occur on my customer's computer everytime the
application starts and never on my machine? What else could be different?
Thanks,
Steve