[freetds] two questions about executing stored procedures

Kall, Bruce A. kall at mayo.edu
Wed Jan 5 11:12:02 EST 2005


Jim,

I'd be glad to try this.  Not coming from any type of Sybase background, 
I have a couple of configuration questions.

I have compiled the download from freetds-0.64.dev.20050103 and 
installed it on my Linux machine. In the freetds/src/dblib/unittests 
dir, I do a

make check-TESTS (as there is not test.sh as is described in the README)
and it gets this far:

make check-TESTS
found JDBC.tempdb for guest in "../../../PWD"
Start
About to logon
About to open "JDBC"
make: *** [check-TESTS] Interrupt

running rpc does about the same thing:

./rpc
found JDBC.tempdb for guest in "../../../PWD"
Start
About to logon
About to open JDBC.tempdb

Being new to sybase stuff, it seems like JDBC is some Sybase machine
> # This is a Sybase hosted database server, if you are directly on the
> # net you can use it to test.
> [JDBC]
>         host = 192.138.151.39
>         port = 4444
>         tds version = 5.0

I can't even ping 192.138.151.39

Is there something else I need to set up to get this test to run?

Bruce



Lowden, James K wrote:
> Hi Bruce, 
> 
> OK, let's take this back on-list, shall we?  The fellow who worked on
> the parameter passing will be interested in your experience.  
> 
> The thing to do next is to make the problem reproduceable and isolate it
> from PHP.  Can you adapt src/dblib/unittests/rpc.c to illustrate the
> problem?  
> 
> I know that's pushing a lot of work your way.  It's not without cause.
>>From experience I can tell you that once the problem is set in clear
> relief with a broken test case, it hardly ever takes more than a week to
> fix.  
> 
> Eventually, I'll add generalized stored-procedure calling to bsqldb, so
> we can test arbitrary calls and combinations.  But that's not going to
> happen for a while. 
> 
> --jkl
> 
> -----Original Message-----
> From: Kall, Bruce A. [mailto:kall at mayo.edu] 
> Sent: Tuesday, January 04, 2005 10:58 AM
> To: Lowden, James K
> Subject: Re: [freetds] two questions about executing stored procedures
> 
> 
> Jim,
> 
> I downloaded last night's build, freetds-0.64.dev.20050103, and set it 
> up on my system with the same problem.  I added a print statement to see
> 
> why it is failing and this is what it prints:
> 
> Conn is [Resource id #7]<BR>
> row size [628]  buf_element_size[0]
> php: dblib.c:308: buffer_add_row: Assertion `row_size <= 
> buf->element_size' failed.
> Aborted
> 
> 
> Unless you already knew this, the buffer_element_size is the one coming 
> in to buffer_add_row as zero which causes the assert to fail.
> 
> If there is anything else I can try, please let me know.
> 
> Bruce
> 
> 
> Lowden, James K wrote:
> 
>>Bruce, 
>>
>>I don't use Linux or RPMs, or PHP for that matter, so I'm not much of
> 
> a
> 
>>resource for you, I'm afraid.  
>>
>>Reading your error messages, I would think the situation is roughly
>>thus:
>>
>>PHP is linked to the prior sybdb (4.0).  
>>The installer is about to add the current one (5.0).
>>The installer wants to remove the old one, finds the dependency, and
>>stops.  
>>
>>There's no particular need to remove 4.0 to install 5.0 as far as
>>FreeTDS goes.  If PHP is linked to /usr/lib/libsybdb.so.4.0.0 (and not
>>merely /usr/lib/libsybdb.so, which I assume is symbolic link that will
>>be overwritten), PHP could continue to use 4.0.  
>>
>>However, to get the new behavior from FreeTDS, you'll want to
> 
> deinstall
> 
>>PHP, too, and relink it with the new FreeTDS.  
>>
>>AFAICT, your question relates more to your package management system
> 
> and
> 
>>which PHP package you want.  I've always found that area a little
>>Byzantine and, fortunately, I've been able to avoid it.  
>>
>>HTH.  I hope you get it working and let us know how you fare.  
>>
>>--jkl
>>
>>-----Original Message-----
>>From: Kall, Bruce A. [mailto:kall at mayo.edu] 
>>Sent: Monday, January 03, 2005 9:51 AM
>>To: Lowden, James K
>>Subject: Re: [freetds] two questions about executing stored procedures
>>
>>
>>Jim,
>>
>>Sorry to bug you, but have you had a chance to determine what this 
>>conflict is and a possible fix for it?
>>
>>Thanks,
>>Bruce
>>
>>
>>kall at mayo.edu wrote:
>>
>>
>>>Jim,
>>>
>>>I made a rpm from this and tried to install it.  When I went to
>>
>>install 
>>
>>
>>>the rpm it said:
>>>
>>>error: Failed dependencies:
>>>       libsybdb.so.4 is needed by (installed) php-mssql-4.3.8-2.1.1
>>>
>>>freetds is installing:
>>>
>>>/usr/lib/libsybdb.so
>>>/usr/lib/libsybdb.so.5
>>>/usr/lib/libsybdb.so.5.0.0
>>>
>>>
>>>but the latest version of php-mssql needs /usr/lib/libsydb.so.4
>>>(php-mssql-4.3.9).
>>>
>>>What am I missing and/or how can I fix this problem?
>>>
>>>Thanks,
>>>Bruce
>>>
>>>Lowden, James K wrote:
>>>
>>>
>>>
>>>>>From: Kall, Bruce A.
>>>>>Sent: Thursday, December 23, 2004 11:38 AM
>>>>>
>>>>>I'm attempting to execute a store procedure on a Sybase system from
>>>>
>>>>
>>>>php
>>>>
>>>>
>>>>
>>>>>on my Linux box using freetds.  This stored procedure requires a 
>>>>>combination of required parameters, some of which have to be null.
>>>>
>>>>
>>>>
>>>>Welcome, Bruce. 
>>>>I believe the very bug you have happened upon is addressed in the
>>
>>latest
>>
>>
>>>>Release Candidate:
>>>>
>>>>   
>>>>
>>
>>
> http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-0.63RC5.tar.gz
> 
>>>>Please try that and let us know how you fare. 
>>>>--jkl
>>
>>
>>-----------------------------------------
>>The information contained in this transmission may contain privileged
> 
> and confidential information and is intended only for the use of the
> person(s) named above. If you are not the intended recipient, or an
> employee or agent responsible for delivering this message to the
> intended recipient, any review, dissemination, distribution or
> duplication of this communication is strictly prohibited. If you are not
> the intended recipient, please contact the sender immediately by reply
> e-mail and destroy all copies of the original message. Please note that
> we do not accept account orders and/or instructions by e-mail, and
> therefore will not be responsible for carrying out such orders and/or
> instructions.
> 
>>If you, as the intended recipient of this message, the purpose of
> 
> which is to inform and update our clients, prospects and consultants of
> developments relating to our services and products, would not like to
> receive further e-mail correspondence from the sender, please "reply" to
> the sender indicating your wishes.  In the U.S.: 1345 Avenue of the
> Americas, New York, NY 10105.
> 
>>
> 
> 


More information about the FreeTDS mailing list