July 5, 2003 at 3:34 am
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
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