ASP.NET 2005 connection string

Hello. I've been programming in classic .asp and am looking into moving
towards asp.net 2005 which the modeling layout appears to be different than
what I've been used to. Should I put the connection string to our SQL
Server in the web.config file? I've been wrapping my classic .asp apps with
https to encrypt the connection string and was wondering if I can do the
same for asp.net 2005. Also, I need to be able to have individual SQL
usernames and passwords for the connection string and not a hard coded
generic account for auditing purposes. Is this possible to say create a
login screen to capture the user's SQL login info and then pass these into
the asp.net 2005 connection string which would be stored in the web.config
file?...or should the connection string be stored in a different global file
named something like 'dbconnection.aspx'?

Thanks in advance.

J


.

Relevant Pages

  • 0113 timeout
    ... This may be a SQL error, but I suspect it's a connection string problem, ... I have an Intranet app at the company I work for. ... allow ASP, which is turned off by default. ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP.NET 2005 connection string
    ... string to our SQL Server in the web.config file? ... connection string and not a hard coded generic account for auditing ... the user's SQL login info and then pass these into the asp.net 2005 ... should the connection string be stored in a different global file ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • ASP vs ASP.NET connecting to SQL Server
    ... When I run a ASP.NET application against SQL ... However when I run an ASP application against the same SQL Server it ... For the ASP.NET application I have the connection string in the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)