Subject | 回复: [firebird-support] Still can't get port 3051 to work |
---|---|
Author | Yang Jin |
Post date | 2005-08-17T05:42:54Z |
hello,
If error only found in customer's machine, please check the different enviorment. I guess the key is system setting.
Steve Harp <steve@...> 写道:
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "firebird-support" on the web.
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱
[Non-text portions of this message have been removed]
If error only found in customer's machine, please check the different enviorment. I guess the key is system setting.
Steve Harp <steve@...> 写道:
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "firebird-support" on the web.
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱
[Non-text portions of this message have been removed]