Forum Discussion
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...
I agree with George. Use SSMS to test your credentials and rights to connect to certain databases. Only after that is successful would you turn to Access to do the same.
Tom_van_Stiphout George_Hepworth credentials work great with SSMS, all tables are visible - still not with ODBC.
- 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?