troubleshooting Question

Explain the relationship between authentication mode="???", identity impersonate="???", connectinString="???" and SqlConnection("??")

Avatar of megnin
megninFlag for United States of America asked on
.NET ProgrammingASP.NETVisual Basic.NET
21 Comments1 Solution667 ViewsLast Modified:
Please provide example code or explanation of how to use SQL Authentication on an extranet.  ASP.Net 2.0, VB.Net, SQL 2000 please.  Correct usage for "???" below would be extremely helpful.

web.config:
<connectionStrings>
<add name="MyDbConn" connectionString="???" providerName="System.Data.SqlClient" />
</connectionStrings>

<authentication mode ="???" />
<identity impersonate ="???" />

CodeBehind.vb:
Dim DBConn As New SqlConnection("???")
Dim DBCmd As New SqlCommand
Dim DBAdap As New SqlDataAdapter
DBConn.Open()

This will be on an external (public) web site and a login.aspx web form needs to insert values into a local SQL Server 2000 database.

Thanks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros