Advertisement

09.10.2008 at 08:42AM PDT, ID: 23719655 | Points: 500
[x]
Attachment Details

Database Connection with impersonation using classic ASP?

Asked by twcadmin in Active Server Pages (ASP), Web Languages/Standards, MS SQL Server

Tags:

I have an intranet site using integrates windows authentication and I know this works becuase I can get the username of logged on users correctly. Right now, my classic asp applications use a userID and password in the connection string to the database, but I want to use impersonation so the logged on users credentials are passed instead of me specifying a userid and password in the connection string like I do with my .NET apps. My problem is that I cant figure out how to specify that in the conenction string.

Start Free Trial 
1:
2:
3:
4:
5:

Right now I have
ConnString = "Provider=SQLOLEDB; Data Source=DBServer; InitialCatalog=MyDatabase; User ID=DBUser; Password=DBuserpassword"
 
But I dont know the correct syntax for impersonation using classic asp NOT .net. Maybe something like
ConnString = "Provider=SQLOLEDB; Data Source=DBServer; InitialCatalog=MyDatabase; Impersonation=true"
[+][-]09.10.2008 at 10:07AM PDT, ID: 22440494

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.10.2008 at 10:47AM PDT, ID: 22440949

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.10.2008 at 10:55AM PDT, ID: 22441055

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.10.2008 at 10:58AM PDT, ID: 22441093

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.10.2008 at 03:02PM PDT, ID: 22443635

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.11.2008 at 05:20AM PDT, ID: 22448825

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.15.2008 at 05:55AM PDT, ID: 22478034

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.15.2008 at 06:21AM PDT, ID: 22478222

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.24.2008 at 07:35AM PDT, ID: 22560130

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628