cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Logon Dialog?

former_member1261230
Participant
0 Kudos

Hi,

When I set my reports datatable connection info it is ignored and I get the SQL connection login. I have set the integrity to true. Here is my code:-

           With crConnectionInfo

                .ServerName = Session("SiteSQLName")

                .DatabaseName = Session("DatabaseName")

                .IntegratedSecurity = True

                crConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL

            End With

            crDatabase = rptCICPrint.Database

            crTables = crDatabase.Tables

            For Each crTable In rptCICPrint.Database.Tables

                crTableLogonInfo = crTable.LogOnInfo

                crTableLogonInfo.ConnectionInfo = crConnectionInfo

                crTable.ApplyLogOnInfo(crTableLogonInfo)

            Next

This code works in another project but not the one I am currently working on.

Regards,

Roger

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

What SDK are you using? Have you updated it to recent patch release?

If it works on one PC but not your then check your DB connection properties and be sure you have access to the Database. CR respects DB security, if you don't have access then either will the report.

Don