SQLConnection.Open error from UI Process Application Block

  • Thread starter Thread starter BillyTheKid
  • Start date Start date
B

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?
 
I am assuming that when you say:
<appParams>
<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />
</appParams>
Click to expand...

you mean:
<add key="ConnectionString"
value="server=localhost;database=UIPStore;uid=UIP;password=U1Pr0c3ss" />
Click to expand...
</appSettings>

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



BillyTheKid said:
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?
Click to expand...
 
Back
Top