Steven Perreau wrote:
Hello.
I'm having terrible trouble with www.troubleticketexpress.com
<http://www.troubleticketexpress.com/> getting their SQL module to
work. I have done a support case with them, they say it's a permissions
issue and not their script helpdesk support software.
I am running MS SBS on Windows 2003 SP2
IIS 6.0
SQL 2000 with SP4
DBD-ODBC V1.15
ActivePerl V5.10.0.1002
I have a DB created in SQL.
I have an ODBC System DSN created using MS Control Panel (in there a few
of them for other things already)
The ODBC DSN works fine and tests ok inside control panel.
I have tried lots of options for the IIS Aplication Pools, using Local
Service, Local System, specified account, making sure that account has
DB_OWNER access and a correct MS logon inside SQL...
I just don't know where to go.
The perl script reports:
Error: No ODBC DSN records found on this server.
Please configure DSN prior to running this program.
Which is rubbish... but obviously it cannot seen ANY of the 5+ System
DSN's that are present.
What am I doing wrong?
Regards,
Steven Perreau
Is this a 64 bit windows machine? I only ask because on 64 bit windows
there are 2 driver managers and 2 lists of system dsns. If you are using
32-bit code you need to define the DSNs with the 32-bit ODBC driver
manager and vice versa.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
