-
Title
Query Builder JOIN query gave error "The identifier that starts with 'ODBC;DRIVER=SQL Server;SERV -
Description
I build a query via the Query Builder and tries to execute it in the Editor. When I run the query from the Query Builder, I get the following error:
SQL Server Database Error:
The identifier that starts with ODBC;DRIVER=SQL Server;SERVER=devrds01;UID=;APP=Toad for Data Analysis;WSID=SCRTITJSCHAMBER;DATABASE=shaw_data;Trusted_Connectio is too long. Maximum length is 128.
The identifier that starts with ODBC;DRIVER=SQL Server;SERVER=devrds01;UID=;APP=Toad for Data Analysis;WSID=SCRTITJSCHAMBER;DATABASE=shaw_data;Trusted_Connectio is too long. Maximum length is 128.
CVAR is not a recognized function name. -
Cause
The error indicates the heterogeneous query is executed on a SQL Server connection. It needs to be executed on an Access connection. The query builder automatically connects to an Access connection when a heterogeneous query is generated so we usually only see this problem if the query is copied and pasted into the SQL Editor that is connected to SQL Server.
-
Resolution
Connect to Access via the Toad Sample Database and execute the query that you copied into the editor with that connection.