If I run the following code in the VB6 IDE, it works as I would expect it to:
connStr = "ODBC;DSN=thales;DATABASE=
MsgBox "Pre-Open database"
Set db = OpenDatabase("", False, False, connStr)
MsgBox "Post-Open database" ' <-- never makes it here
but if I compile it to an .EXE and try to run it, it never makes it to the second msgbox, instead I get an error after about 60 seconds (see attached image)
This is code that has worked for ages, but now all of a sudden isn't. As far as I know, there haven't been any updates installed on the server, which is running SQL 2005. Testing the ODBC datasource tests OK.