Cannot see AND Windows system DSN's using DBD-ODBC

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



Relevant Pages

  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)
  • Re: sqlstring -- a library to build a SELECT statement
    ... > short-circuiting behaviors regarding them (the resultant bytecode will ... How to best add further sql function support? ... > database does not support a given function (or operator, ... > case-insensitive in MS SQL Server but case-sensitive in PostgreSQL). ...
    (comp.lang.python)
  • RE: SQLCMD fails with login timeout expired.
    ... I understand tht you could connect to SQL Express properly by 2005 ... management tool but you cannot connect it via sqlcmd. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL server 2005 SP2 failing on cluster
    ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ... Computer: FRESHCLUSTSQL01 ...
    (microsoft.public.sqlserver.clustering)