DSN and SQL access

Results 1 to 2 of 2

Thread: DSN and SQL access

  1. #1
    Join Date
    Dec 1969

    Default DSN and SQL access

    If I have three SQL users in a db for three different levels of security, should I have three seperate DSNs to connect to SQL server?<BR><BR>How about if I used my dbo login to set up the system DSN but used the three other accounts in conjunction with the DSN in the connection string?<BR><BR>What is the best practice?

  2. #2
    Join Date
    Dec 1969

    Default RE: DSN and SQL access

    Strictly speaking a dsn is not the best way to access a database at all, it adds extra over head to the network traffic.<BR><BR>If you need multiple user security access through asp, simply use a dsn-less connection:<BR><BR>strConnection = "Driver={SQL Server};server=servername;database=databasename;ui d=username;pwd=password"<BR><BR>or, if you set up a trusted connection<BR><BR>strConnection = "Driver={SQL Server};server=servername;database=databasename;tr usted_connection=yes"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts