Post reply

User or Login Authentication

  • July 5, 2003 at 3:34 am

    #81188

    Hi everyone,

    I have written an Active X in a DTS to establish connection. Below is the connection coding.

    Set myConn = CreateObject("ADODB.Connection")

    myConn.open "Provider=SQLOLEDB; Integrated Security=SSPI;Persist Security Info=False; Initial Catalog=" & dbConn.Catalog & ";Data Source=" & dbConn.DataSource

    My problem is that the DTS runs well in my PC, but...

    when i transfered this similar DTS to my client PC and ran it, i received an error message, hinting something to do with login or permission.

    Can anyone pls help me?

    Btw, what is meant by "Integrated Security=SSPI;Persist Security Info=False; ".

    Thanks alot in advance.

    cheongww

    CheongWW


    CheongWW

  • July 5, 2003 at 4:51 pm

    #464222

    Integrated security means that ActiveX will use your windows logon credentials when connecting to sql server. Persist security info=false means that the connection properties will not be maintained after the connection has been made to sql server. This is more secure.

    Seems as though the logon you are using on the client pc does not have the right level of authentication.

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

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