When setting up an LCConnection like in the example below one have to put in userid and password in clear text. Is it a way to set it up so that the agent uses the current users (e.g. in Active Directory) access level to the database source? Set lccon = New LCConnection("oledb") With lccon .provider = "sqloledb" .server = "sqlserver" .Database = "database" .Metadata = "dbo.personell" .Userid = "userid" .Password ="password" .writeback = True End With
Return to top
LCConnection and UserID (Ole Martin Mykl... 7.Jun.07)
. . 
Print this page
