Hi all,

Can anyone tell me if there are any extra configuration steps to using the
Ent Lib DAAB
in an asp.net app that's being run through an SSL connection?

(Framework 1.1, EntLib June 2005, VS2003)

Thanks.

Al

Hi Alec,

Do you mean the web connection to your ASP.NET is encrypted (using SSL) or
are you refering to the connection between your webserver and your database
server? In the former case, the answer is: None; In the latter case: You'll
need transport encryption.

Best personal regards,
-- Li-fan

Show quoteHide quote

Thanks Li-fan,

It was the former case.

After a lot of trials, I've narrowed down my problem to the db.ExecuteReader
method to load into an IDataReader:

....
Dim db As Database = DatabaseFactory.CreateDatabase
Dim cmd As DBCommandWrapper
Dim dataReader As IDataReader
cmd =
db.GetStoredProcCommandWrapper("usp_OnLine_EmailAddr_for_Staff_SELECT")
cmd.AddInParameter("@ExtranetUSID", DbType.Int32, Me.intUSID)
dataReader = db.ExecuteReader(cmd)  ' <--- Fails. Triggers exception
....

As background, I have used normal xcopy deployment for project folder and
files, then set up the virtual directory on IIS, and enabled the required
use of SSL on the virtual directory.

I have not installed or run any other process for the EntLib on the server.
Should I install the msi and run the "Install Services" batch file?
Being cautious, I avoid installing anything I don't have to on the
production server.

Thanks for any pointers.

Al


Show quoteHide quote

Just to follow up on the eventual solution...

The SSL involvement was  red-herring. The real issue was with the Enterprise
Library DLL's not being registered with the production server's Framework as
a recognised resource.

(see my other message thread subject title: "DAAB ExecuteReader method
causes Exception" for a detailed break down of the scenario if you're
interested...)

Patrick Oge pointed me in the right direction of using one of the
Framework's tools, called InstallUtil.
Details of syntax on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpconinstallerutilityinstallutilexe.asp

Running this on the server for the EntLib Data DLL sorted the problem
immediately.

I'd like to know why the xcopy deployment didn't operate for this set of
DLL's though...

Al


Show quoteHide quote

Advatages of Stored Procedures?
Sql Server SCOPE_IDENTITY()
"Business Objects" and the DAL
A severe error occurred on the current command. sp_AddMergePublication
ODP .Net Connection Pool Problem on Web Application