Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    73

    Unanswered: DSN Connection to SQL Server

    I am using the code below to create a DSN connection if it does not exist. Is there a way to set the DSN to use NT Authentication?

    Code:
               lngResult = SQLConfigDataSource(0, _
                                               ODBC_ADD_SYS_DSN, _
                                               "SQL Server", _
                                               "DSN=" & JDS_DSN_name & Chr(0) & _
                                               "Server=" & JDS_Server_name & Chr(0) & _
                                               "Database=RMAData" & Chr(0) & _
                                               "UseProcForPrepare=Yes" & Chr(0) & _
                                               "Description=RMA Database" & Chr(0) & Chr(0))

  2. #2
    Join Date
    Apr 2004
    Posts
    73
    Figured it out

  3. #3
    Join Date
    Oct 2003
    Posts
    8
    Try specifying "Trusted_Connection=No" attribute along with the other attributes specified in SQLConfigDataSource().

Posting Permissions

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