Even I am facing the same problem and solution suggested here is not the solution I am looking for.
I have my application connect to the SQL Server using Integrated Security; in this my application gives me an error "Invalid table number" and my code is as below:
For inCtr = 0 To pobjReportObject.Database.Tables.Count - 1
'Assinging Parameters
crLogonInfo = pobjReportObject.Database.Tables(inCtr).LogOnInfo
crLogonInfo.ConnectionInfo.ServerName = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_SERVER, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
'crLogonInfo.ConnectionInfo.UserID = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_UID, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
'crLogonInfo.ConnectionInfo.Password = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_PWD, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
crLogonInfo.ConnectionInfo.DatabaseName = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_DATABASE, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
pobjReportObject.Database.Tables(inCtr).ApplyLogOn Info(crLogonInfo)
pobjReportObject.Database.Tables(inCtr).Location = crLogonInfo.ConnectionInfo.DatabaseName & ".dbo." & crLogonInfo.TableName
Next
Please suggest
|