Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    25

    Exclamation Unanswered: DNS or DNS-less connections?

    Hi all,

    To connect a database which one of the following should I use:

    "Driver={SQL Server};DSN=;SERVER=" & SERVER &
    ";UID=" & UID & ";PWD="
    & PWD & ";DATABASE=" & DATABASE & ";"


    "Provider=SQLOLEDB.1;Persist Security
    Info=False;AutoTranslate=no;User ID=" & UID &
    ";Password=" & PWD
    & ";Initial Catalog=" & DATABASE & ";Data
    Source=" & SERVER

    Knowing that the application is client/server, that users have W95, W98, W2K and that the database is in SQL Server 7.0 SP3.

    Thanks in advance.

    God Bless.

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    use the first one

  3. #3
    Join Date
    Aug 2002
    Posts
    25
    Why?

Posting Permissions

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