SQL Server 2005 Integrated Security

Post Author: mudEyes

CA Forum: Data Connectivity and SQL

Hello all,

I've just changed SQL 2000 to 2005 and want to use integrated security when connecting my CRViewer tables via an ADO connection in VB6 but i'm having no joy, I thought this would do it -

For intTablePtr = 1 To intNumberOfTables If blnIntegratedSecurity Then CRReport.Database.Tables(intNumberOfTables).SetLogOnInfo strServer, strDatabase Else CRReport.Database.Tables(intNumberOfTables).SetLogOnInfo strServer, strDatabase, strUser, strPassword End If Next intTablePtr CRReport.Database.LogOnServerEx _ pDllName:="p2ssql.dll", _ pServerName:=strServer, _ pConnectionString:=strConnection

but i can't get it working. Can anyone help me sort it out?