0 Replies Latest reply: Jan 5, 2006 2:52 AM by N_Green _ RSS

    Monarch And SQL 2005

    N_Green _

      Hi

       

      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.