Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
SageGuy125
Posts: 61
Registered: 07-09-2009
0

FRX ODBC Error Running 1 Report

I have an FRX user that tried to run an FRX report he ran 3 weeks ago & prior just fine.  Now when he runs it he receives:

 

01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

 

It seems it is only for the one particular report.  The user says he has not changed the report.  The user has tried the report on another computer and receives the same error.

 

I had installed 3 Windows updates (no SQL updates) onto the MAS 500/FRX server, but have since removed them and rebooted the server.  The problem persists.  I Googled the error and it says somethign about SQL colation but I currently am unable to make sense of it.

 

The server that MAS 500/FRX is running on is Windows 2008 & the SQL version is 2005 Express.

 

Can someone please help me understand what is happening here?  Thank you.