creating a windows authentication DSN

  • Can this code be changed to use the windows Authentication instead of the SQL Server login?

    http://www.mvps.org/access/tables/tbl0014.htm

  • http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp

     

    lngResult = SQLConfigDataSource(0, _

                                               ODBC_ADD_SYS_DSN, _

                                               "SQL Server", _

                                               "DSN=" & JDS_DSN_name & Chr(0) & _

                                               "Server=" & JDS_Server_name & Chr(0) & _

                                               "Database=SvCvMarketing" & Chr(0) & _

                                               "UseProcForPrepare=Yes" & Chr(0) & _

                                               "Description=MDTS Database" & Chr(0)  & _

    "Trusted_Connection=yes" & Chr(0)  & _

    & Chr(0))

  • Cheers mate

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply