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