I seem to be having problems trying to use the ODBC text driver. I am not entirely sure what the problem is but I have an idea it might have something to do with this: It looks like the driver is placing single quotes around all the fields and other similar items (which is not valid SQL).
SELECT 'field1', 'field2' FROM 'dbo'.'table1'
Does anyone have any ideas? Solutions? Or even some tips using the ODBC text driver?