[unixODBC-dev] Problem with threading/Asta

Nick Gorham nick at easysoft.com
Mon Jul 26 18:53:49 BST 2004

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 ?

Nick Gorham
Easysoft Limited

More information about the unixODBC-dev mailing list