I am using the Microsoft OLE DB Provider for ODBC Drivers in MS SQL 2005, I am having an error when I reference a table name that includes an underscore .
The error I get is:
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "L" does not contain the table "D.dbo.ID_POS". The table either does not exist or the current user does not have permissions on that table.
Is there any way I can fix that error wihtout using the OPENQUERY command?