DSN question

Results 1 to 2 of 2

Thread: DSN question

  1. #1
    Aniket Guest

    Default DSN question

    I want to know the difference in File DSN , System DSN and User DSN.Also please tell me the advantages and disadvantages of each and which to use?

  2. #2
    Vijaya Seshan Guest

    Default RE: DSN question

    File DSN --&#062; the contents are stored in a file.<BR>System DSN --&#062; the contents are stored in windows registry. <BR>User DSN --&#062; I don&#039;t know what this is. <BR>DSN less connection --&#062; Insterad of creating a DSN you use a connection string. This is a connection string which can be used for SQL:<BR>cnstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Persist Security Info=False;User ID=sa;Pwd=;Initial Catalog=databasename;Data Source=machinename"<BR>Just replace the databasename with the name of the database you want to access, and the machinename with the server name on which the database is.<BR>Out of all this, DSN less connection is most efficient since the contents are stored in memory. Then comes teh System DSN and then the file DSN.<BR>

Posting Permissions

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