Hello,
We have an unusual setup at where we have an MSACCESS application(access 97) front end on a NT4 server that links to an SQL 2005 database running on a HP Proliant Server 2003 server. This works well mostly but when we have to import a large file into the SQL server it times out after about 15 minutes with the following error:
Connection failed:
SQLState: ‘01000’
SQL Server Error: 768
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()).
Connetion failed:
SQLState: ‘08001’
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SSL Security error
Now we have a domain trust setup between the NT4 application server domain and the Server 2003 domain. This is to Authenticate NT users and seems to work fine.
I guess there is a timeout setting that probably needs to be increased but cannot find any information of what it might be.
If anyone could advise me I would be very grateful.
Thanks,
Roland
