Post reply

how 2 use windows authentication

  • January 27, 2004 at 10:23 pm

    #491858

    P Rajanikanth:

    The connection string you are using is a DSN-less style string, so you don't need the "dsn=" at the end.  So I'm assuming that the following connection string will authenticat a SQL Server login named RK with a password of PWD:

    driver=SQL Server;server=houston;uid=RK;pwd=PWD;database=tracker

    If so, then the following string will request Windows authentication instead, using the network credentials of the currently logged-in user:

    driver=SQL Server;server=houston;uid=;pwd=;database=tracker

    A slightly fuller explanation is available here:  http://support.microsoft.com/default.aspx?kbid=194641

    Cheers,

    Chris

  • January 28, 2004 at 12:33 pm

    #492052

    Thanks chris

    I found very useful website with connection strings

    http://www.connectionstrings.com

    its very useful

    Thanks for ur response.

    cheers

    Rajani

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

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