ODBC DSN in odbc.ini

samdsx · Post by **samdsx** » Fri Apr 13, 2012 2:58 pm

While creating a new SQL Server DSN in .odbc.ini, is it possible to add the below parameter to it? This is an effort to see if the ODBC SQL Server timeout never happens if this is possible. The datadirect version that is considered in this case is Data Direct 6.0.

LoginTimeout=0

Thanks!

qt_ky · Post by **qt_ky** » Fri Apr 13, 2012 8:18 pm

Yes, you can add it. That setting is for the number of seconds the driver will wait to establish the database connection. The default is 15 seconds. It does not have anything to do with individual SQL statements timing out during an already established connection.

samdsx · Post by **samdsx** » Sun Apr 15, 2012 7:28 am

Can this be added to odbc.ini when datadirect 5.0 is used too? Please let me know.

qt_ky · Post by **qt_ky** » Sun Apr 15, 2012 8:12 am

You would have to search in the DataDirect ODBC User's Guide for that release to find out for sure.

The PDF files should be available under the branded_odbc directory structure. Binary FTP them to your PC to review.