[unixODBC-dev] Problem with threading/Asta

David Keith dkeith at noThis.logisticshealth.spamremove.com
Mon Jul 26 18:59:40 BST 2004

Nick Gorham wrote:
> David Keith wrote:
>> I've put together an AstaIO daemon written in Kylix/Delphi that uses 
>> ODBC Express as it's vendor interface. I'm using FreeTDS to connect to 
>> SQL Server 2K.
>> When you start the AstaIO daemon it normally creates about 19 
>> instances as checked by using ps -A|grep Asta.
>> Because some results weren't coming back correctly in the ExecProc 
>> call I started futzing around with the Hdbc component. I set CursorLib 
>> from 'Use Driver' to 'Use ODBC'. When I did this and ran a test with 
>> the ODBC Express components, I got my result params. But when I tried 
>> to start the AstaIO daemon, only one instance showed up in the process 
>> list and the server was in a non-responsive state.
>> In reading posts on this group I've seen that you can set a 
>> 'Threading' option in odbcinst.ini. I've tried '= 0' and '= 50' but 
>> that made no difference; with the ' = 50' option I get one 
>> non-functioning instance of my server, with ' = 0' I get no instances 
>> at all. I've also tried 'Pooling = Yes' and 'Pooling = No' but that 
>> seems to make no difference either.
>> Thanks for any assistance.
> Ignoring pooling and cursor libs for the moment, How many connections 
> are being created ?
I have it set to start with 5 connections. If more are needed the server 
will create/dispose of them as required.

More information about the unixODBC-dev mailing list