[ADodb-general] ADodb, IIS 6.0, MS SQL 2k sp4, & PHP 5.1.2

[Lars R. N. <Lar...@jd...>]

Good morning, afternoon, or evening all.

This is my first crack at using ADodb so please be gentle.  I am running
into what I perceive to be a problem.  Almost certainly something I did
wrong, or haven't done, but none the less....

Background:

I have an IIS 6.0 web server which has been tested and is working
correctly.

I have PHP 5.1.2 installed and configured on the server.  PHP has been
tested as working using (  Today is <?print strftime("%m/%d/%Y");?>  )

I have a MS SQL 2000 database running locally on the web server, from
the command line I can connect to it via (C:\osql -S localhost -U
snortuser -d IDSDB)  followed by entering my password when prompted.

I have extracted the latest ADodb zip file (as of Monday Jan. 30, 2006)
into the e:\WWW\adodb where WWW is the root directory of the web server.

I edited the adodb.inc.php file to read (
if(!define('ADODB_DIR'))define('ADODB_DIR','E:\WWW\adodb');  )  but have
otherwise not changed anything in the adodb.inc.php configuration file.

The problem I am having is, if I add to my above test.php file the
following code, I always receive the FAIL message which tells me, unless
I'm reading this wrong, that I am NOT connecting to the database.
(test.php follows)

<?php
Include('adodb/adodb.inc.php');
$conn =3D &ADONewConnection("mssql");
$conn->Connect('localhost','snortuser','somepasswordhere',IDSDB')or
die('FAIL');

Followed by some database queries.....

Anyone who is able to provide insight as to where I should be looking to
perhaps resolve this problem, including a web based idiots guide to php
& adodb would be appreciated.

Thank you for your time.

--------------------------------------

Lars R. Noldan

JDR Solutions, LLC

Network Administrator