Okaloosa
County FL has a small election scheduled for this Tuesday. They are running
GEMS 1.17.17 under Win 2000 and cannot get pre-election reports to work. It
gives the following error when previewing or printing the
reports:
Failed to connect to
database
Error (527) - Error
in File:
SQL server
error.
The
problem seems identical to the one
reported by Cathi Smothers back in August 2001. Dmitry mentions a work
around, “login as
administrator on W2K machine and create a new System DSN under ODBC settings.
After that Crystal reports will work without errors.” I
also see mentioned a new GEMS install pack, but I cannot use it due to
certification limitations.
I want
to try the workaround, but I need specific instructions on how to setup and
configure the new system DSN. I found the ODBC settings in Control Panel, and
got to the System DSN tab. Clicking ADD button takes me to the select a driver
for the data source screen.
- Do I
select Microsoft Access Driver (.mdb) or SQL Server, or some other driver
from the list.
- What
do I do next?
As
others have reported, I am able
to print the pre-election reports on my laptop running Win
2K.
Mark
Mark
S Earley
Support
Services Specialist
Diebold
Election Systems
850
422-2100 office/fax
850
322-3226 cell