I'm attempting to use the query below in an Infopath Data Connection to SQL Server. When I click on Test SQL Statement button it errors with the following error mesage:
The ADO Adapter failed to get the schema.
[0x80004005][Microsoft OLE DB Provider for ODBC Drivers] [Microsoft][ODBC SQL Server Driver]Unspecified error ...