I am able to connect to my sql server from Monarch and query the tables ok.
When I try and open up a Stored View which requires some procesing on the SQL server I always get the following message
Jet Database internal error:(3146) ODBC--call failed.
Here is my connection string
ODBC;DSN=trav;UID=Username;APP=Monarch for Windows;WSID=MyWorkstation;DATABASE=DBName;Network=DBMSSOCN;AutoTranslate=No;QueryLog_On=Yes;QueryLogTime=0;StatsLog_On=Yes;UseProcForPrepare=2;QuotedId=No;AnsiNPW=No
Can anyone tell me what I am doing incorrectly.