Forum Discussion
danevald
Oct 20, 2023Copper Contributor
ODBC from Access to SQL Server database - query timeout expired
I am having issues connecting to a database located on a SQL Server 2022. When creating the connection all test gives OK. But when trying to connect, it fails with: ODBC--call failed "Query tim...
Tom_van_Stiphout
Oct 21, 2023Steel Contributor
Use the ODBC applet (under Control Panel) to create a File DSN using the same ODBC driver. On the last page of the wizard you can test the connection. Does that work?
danevald
Oct 22, 2023Copper Contributor
It's the same as creating it through Access, and the test completes successfully.