[thelist] RE: Problems using asp/inc pages in windows 2000

[Claire Brummell]

An Example of the code I'm using is:
SQLAccounts="SELECT FirstName, LastName, Emailaddress, Extension FROM
personnel WHERE Department = 'Accounts' ORDER BY FirstName"
set connAccounts = server.createobject("ADODB.Connection")
connaccounts.open "Personnel"
set accounts=connaccounts.execute(SQLaccounts)
Where Personnel is an Access ODBC connection set up for the database


-----Original Message-----
From:	Claire Brummell [mailto:cbrummell at prismleisure.com]
Sent:	Wednesday, July 25, 2001 07:32
To:	thelist at lists.evolt.org
Subject:	[thelist] RE: Problems using asp/inc pages in windows 2000


Regarding this original problem:
I have managed to build a web front-end for our company intranet that
includes in it a couple of ODBC links to a local database.  I ran this
through PWS on a windows 98 Machine without any problems and the whole thing
was running sweet as a nut.  I then came to transfer it to one of our
servers which is running windows 2000 server, and that is where my problem
began....  The problem I have is that the pages including the ODBC links
either won't show up at all, or do, just pulling no information. I have
managed to verify that the ODBC Data Source is set up correctly (by using MS
Query to connect to it and retrieve the data), but unfortunately I am now a
little stuck as to what is causing the problem - anyone got any ideas?
I've tried the various ideas that you guys have thrown at me - the
IUSR_<servername> permissions, checking the properties on the database etc.
to no avail - has anyone got any more ideas?