Hello,

We're running a web application on a Windows 2003 server with IIS6 and
Asp.net 1.1. The database in quesion is a Microsoft Access one.

The database _has_ to reside on our Novell 6 server. The Netware Client
is installed on the 2003 box. All rights properly set. Go...

But it doesn't... 'go'. The application refuses to work in this
configuration. It does work when the database resides locally on the
2003 box, but not when the database is on the Novell server.

Any tips are greatly appreciated.

This is the error message:

ExecuteScalar requires an open and available Connection. The
connection's
current state is Closed.
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more information

about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: ExecuteScalar
requires an open and available Connection. The connection's current
state
is Closed.

Source Error:

An unhandled exception was generated during the execution of the
current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: ExecuteScalar requires an open and
available
Connection. The connection's current state is Closed.]
System.Data.OleDb.OleDbConnection.SetStateExecutin g(OleDbCommand
attempt, String method, Boolean flag) +122

System.Data.OleDb.OleDbCommand.ValidateConnectionA ndTransaction(String

method, Int32& localState) +103
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior

behavior, String method) +61
System.Data.OleDb.OleDbCommand.ExecuteScalar() +185
CUPWeb.Classes.OleDBManager.GetString(String queryString, Object[]
ParamArray) +34
CUPWeb.Classes.RoosterManager.GetConfigValue(Strin g option, Boolean

CacheItem) +137
CUPWeb.Classes.RoosterManager.GetConfigDate(String option) +34
CUPWeb.Classes.RoosterManager.get_LeerlingOpenDatu mTijd() +11
CUPWeb.mainForm.Page_Load(Object sender, EventArgs e) +85
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

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

Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
ASP.NET Version:1.1.4322.2300


--
henkdegunst