Q: Fixing 'qodbc3:unable to execute statement' when querying SQL Server 2008? While testing features of QGIS I tried to query each table using right click and query but I can't query sql server 2008 database :
Error:
An error occured when executing the query.
The data provider said:
[microsoft][odbc sql server driver][sql server] invalid object name 'table_test'
qodbc3:unable to execute statement

but it works fine with postgis.
Also, is there any why to join table and do the query?


A: you need to define ODBC connection from Admintools -> "Data sources" use name as provider/DNS , then tell QGIS to use it.
Also dont enable "only look in the geometry_columns table" 

A: I think you need to have a geometry_columns table in the database in order to connect. Nathan has some more details on this post
