[FMS] SQL error... advise please

[jimlad]

Hey guys

 

when trying to run a report we have run many times before we get this

 

http://i.imgur.com/0QTQMK5.jpg

 

any ideas?

[matt40k]

Guessing you've got a new server. Contact your LA\Capita. MS-SQL Server been installed wrong.

[jimlad]

nope no new changes to hardware or software. report working last week...

 

i am thinking the whole turn it on and off at the end of the day. the error is likey to server side rather than client ?

[matt40k]

Seriously? Could be something else, FMS is well known for having weird errors, but collation errors can be nasty. Worth a call to your LA\Capita. FMS isn't one of those systems that you can get away with date issues. Make sure you update the post once you've got it resolved.

[jinnantonnixx]

Have you had any updates in the meantime? That collation fault if normally a coding error. The code should have DATABASE_DEFAULT around the collation "=" operator. Obviously you can't change that.

 

It might be worth checking that your ODBC drivers are up-to-date.

Edited March 4, 2014 by jinnantonnixx

[jimlad]

Have you had any updates in the meantime? That collation fault if normally a coding error. The code should have DATABASE_DEFAULT around the collation "=" operator. Obviously you can't change that.

 

It might be worth checking that your ODBC drivers are up-to-date.

 

Ok once the users are off I will check everything and do a server reboot. Hope it's one of those ones that go away.

[vikpaw]

Any joy?

Is it the same as usual client? Any changes on the client side? Including the user doing it..?

[ICT_Pro]

Add user as local administrator on this computer who is having this problem.