I have an old VB6 application that was last developed on Windows 2000 linking to SQL2005. I still have these boxes but also 2 new ones:-
a windows 10 64 bit pc and a new server with sql 2014 on it.
My tables have moved to the new server (via backup on old, restore on new)
I have modified the vb6 code so as to allow selection of which server I want to run on.
I have ODBC connection established
This is perfectly OK for the windows 2000 - able to link to both old and new servers and execute the code - in particular:-
global rs_members as recordset
sqlq = "select * from mytable"
set rs_members = Dbgeneral.OpenRecordset(sqlq, dbOpenSnapshot)
This code fails with "Run-Time error 3146 ODBC call failed"when running on windows 10 vb6 (simply as Run with full compile) when linking to new 2014 sql.
It works perfectly OK when running on windows 10 linked to old server.
So persumably there is something in sql2014 that is causing the problem.