Hi there...
I'm using an ActiveX Script Task and I'm trying to connect a local server
with trusted connection, i.e., not a Database User but the Windows user.
How to do it?

Set ADOcon = CreateObject("ADODB.Connection")

ADOcon.Provider = "sqloledb"
ADOcon.Properties("Data Source").Value = "LOCAL SERVER"
ADOcon.Properties("Initial Catalog").Value = "DatabaseName"
'*****ADOcon.Properties("User ID").Value = "Eduardo"
'*****ADOcon.Properties("Password").Value = "a"
ADOcon.Open

Thank you for the help...
Eduardo

Your sample would be

ADOcon.ConnectionString = "Provider=SQLOLEDB;Data Source=(local);Initial
Catalog=MyDatabase;Integrated Security=SSPI"



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote