Monday, 25 April 2011

M359 SQL Anywhere and Interactive SQL in Windows 7 Java Errors

The Open University provides course software to load and manipulate databases, their choice of program is SQL Anywhere and when trying to query anything using Windows 7 the version used just dumps huge stack traces.

This seems to be a common problem for a lot of Windows 7 users, here are the instructions for getting it to work for anyone who comes across this issue on future presentations.

You need to run the programs in compatability mode. To do this Go start > programs > m359 > right click on the "Start M359 Server" shortcut and click properties.

choose the compatability tab then check the "run this program in compatability mode" checkbox, select windows vista service pack 2.

under privilege level at the bottom, check "run this program as an administrator".

Do the same for the Interactive SQL shortcut in the same location. Once done, close down the server, fire it up again manually and it should all work.

1 comment:

Daniel Harper said...

Thanks, just what I was looking for