SQLConnection.Open error from UI Process Application Block

[BillyTheKid]

I am attempting to run the sample WebUI code out of the box from Microsoft's
User Interface Process Application Block (I succesfully ran the QuickStarts
script so the database, user, and PW are there).

It is failing on the SqlConnection.Open();

"The specified module could not be found"

The method is from SQLHelper.cs and is as follows:

public static SqlDataReader ExecuteReader(string connectionString,
CommandType commandType, string commandText, params SqlParameter[]
commandParameters)
{
//create & open a SqlConnection
SqlConnection cn = new SqlConnection(connectionString);
cn.Open();

try
{
//call the private overload that takes an internally owned connection in
place of the connection string
return ExecuteReader(cn, null, commandType, commandText,
commandParameters,SqlConnectionOwnership.Internal);
}

catch
{

//if we fail to return the SqlDatReader, we need to close the connection
ourselves
cn.Close();
throw;
}
}

The error is thrown on cd.Open();.

The web.config file has the following for the connectin string:

<appParams>
<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />
</appParams>

Anyone have any thoughts on this rather ambigous error message?

 

[Ross Porter]

I am assuming that when you say:

<appParams>
<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />
</appParams>

you mean:

<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />

</appSettings>

Also verify that your appSettings are in the Configuration container but NOT
in the <System.Web> container.

I am attempting to run the sample WebUI code out of the box from Microsoft's
User Interface Process Application Block (I succesfully ran the QuickStarts
script so the database, user, and PW are there).

It is failing on the SqlConnection.Open();

"The specified module could not be found"

The method is from SQLHelper.cs and is as follows:

public static SqlDataReader ExecuteReader(string connectionString,
CommandType commandType, string commandText, params SqlParameter[]
commandParameters)
{
//create & open a SqlConnection
SqlConnection cn = new SqlConnection(connectionString);
cn.Open();

try
{
//call the private overload that takes an internally owned connection in
place of the connection string
return ExecuteReader(cn, null, commandType, commandText,
commandParameters,SqlConnectionOwnership.Internal);
}

catch
{

//if we fail to return the SqlDatReader, we need to close the connection
ourselves
cn.Close();
throw;
}
}

The error is thrown on cd.Open();.

The web.config file has the following for the connectin string:

<appParams>
<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />
</appParams>

Anyone have any thoughts on this rather ambigous error message?