Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using an old piece of software from Ceridian called Source this is a HR Payroll piece of software. I cannot phone their support as we no longer have a contract but use the software for archive data. Most of the program works but when I use the print then Preview function we are getting error messages:

SQLGETSQLQUERY: Cannot open SQL server. and Error in Main CrwSetPrintJobFormulaAndLocation.

This is running on Server 2003.

I have searched everywhere for a solution but to no avail, any ideas?

share|improve this question
You can't expect us to be able to help you with the provided information. There are far to many things it could be and its unlikely anyone but a very small set of people could answer this. – Ramhound Dec 13 '12 at 12:47
I placed this on here with the off chance that somebody may have come across this problem, or at least an educated suggestion like techie007 has posted. – Matt Dec 13 '12 at 14:36

Those are pretty vague internal errors.

It appears the SQLGETSQLQUERY method failed because it can't "open" the SQL server.

  • Does the SQL server exist?
  • Is it at the place it expects it to be?
  • Do the tables exist?
  • Are they corrupted?

It also appears that something is getting an "Error" when attempting to set the CrwSetPrintJobFormulaAndLocation property.

  • Do you have any printers installed?
  • Do you have any now missing printers referenced in the payroll program?

Really though, I think you'll need to call their support (and pony up the cash if it's important enough).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.