[Sqlrelay-discussion] =?gb2312?B?u9i4tKO6IEkgZ290IHRoZSBmb2xsb3dpbmcgZXJyb3IsIGFueSBpZGVhPw==?=
Brought to you by:
mused
|
From: 邱 承 <cnm...@ya...> - 2007-08-31 14:58:46
|
The problem has been worked around. I add a stored procedure named sp_versi= on in the DB connected. That's all. I don't know why the sqlr-connect keeps= try to call this stored procedure. I guess 'sp_version' is a stored proce= dure in Sybase, but don't exist in SQL2k.=0A=0Aany idea?=0A=0A=0A----- =D4= =AD=CA=BC=D3=CA=BC=FE ----=0A=B7=A2=BC=FE=C8=CB=A3=BA "=C7=F1 =B3=D0" <cnma= rk...@ya...>=0A=CA=D5=BC=FE=C8=CB=A3=BA sql...@li...= eforge.net; cnm...@ya...; =C7=F1 =B3=D0 <qiu...@cs...>=0A=D2= =D1=B7=A2=CB=CD=A3=BA 2007/8/28(=D6=DC=B6=FE), =CF=C2=CE=E76:17:52=0A=D6=F7= =CC=E2=A3=BA I got the following error, any idea?=0A=0A=0AI used sql-relay = 0.39.2 to connect to a sql server 2k server. The following is my sqlrelay.= conf:=0A<instances>=0A <!-- Regular SQL Relay Instance -->=0A = <instance id=3D"example" port=3D"9000" socket=3D"/tmp/example.socket" dbas= e=3D"f=0Areetds" connections=3D"3" maxconnections=3D"15" maxqueuelength=3D"= 5" growby=3D"1" ttl=3D"6=0A0" endofsession=3D"commit" sessiontimeout=3D"600= " runasuser=3D"nobody" runasgroup=3D"nob=0Aody" cursors=3D"5" authtier=3D"l= istener" handoff=3D"pass" deniedips=3D"" allowedips=3D"" d=0Aebug=3D"connec= tion" maxquerysize=3D"65536" maxstringbindvaluelength=3D"4000" maxlobbin=0A= dvaluelength=3D"71680" idleclienttimeout=3D"-1" maxlisteners=3D"-1" listene= rtimeout=3D"0=0A" reloginatstart=3D"false">=0A <users>=0A = <user user=3D"user1" password=3D"password1"/>=0A = <user user=3D"user2" password=3D"password2"/>=0A = <user user=3D"user3" password=3D"password3"/>=0A = </users>=0A <connections>=0A <con= nection connectionid=3D"db1" string=3D"sybase=3D/etc/freet=0Ads;user=3Dsa;p= assword=3D***;server=3DMyServer2k;db=3Drun;" metric=3D"1" behindloadbalan= =0Acer=3D"no"/>=0A </connections>=0A </instance>=0A = =0AThen, after started by "sqlr-start -id example", I got the following err= ors:=0AServer Name:=0AJF-WEBJY-TEST2=0AProcedure Name:=0AError: Could not = find stored procedure 'sp_version'.=0ACouldn't create cursors.=0A*** glibc = detected *** free(): invalid pointer: 0xb7fd0000 ***=0A sqlr-connection-fr= eetds -id example -connectionid db1 -config /usr/local/fi=0Aworks/etc/sqlre= lay.conf=0AServer message:=0A severity(10)=0A number(252)=0A = state(62)=0A line(1)=0A =0ACould anybody help me?=0A=0A=0A=0A= =D1=C5=BB=A2=C3=E2=B7=D1=D3=CA=CF=E4=A3=AC=C8=AB=C7=F2=B5=DA=D2=BB=D3=CA=CF= =E4=C6=B7=C5=C6=A3=A1=0A=0A=0A _______________________________________= ____________________ =0A=D1=C5=BB=A2=C3=E2=B7=D1=D3=CA=CF=E4=A3=AC=C8=AB=C7= =F2=B5=DA=D2=BB=D3=CA=CF=E4=C6=B7=C5=C6=A3=A1 =0Ahttp://mail.yahoo.com.cn/ |