HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBC.INI\\[databaseName]\\SERVER.
reportDoc.Load(report); ConnectionInfo connInfo = new ConnectionInfo(); connInfo.ServerName = "Driver={SQL Native Client};Server=SQLServer;"; connInfo.DatabaseName = "myDatabase"; connInfo.UserID = "myUser"; connInfo.Password = "myPassword"; TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); tableLogOnInfo.ConnectionInfo = connInfo; foreach (Table table in reportDoc.Database.Tables) { table.ApplyLogOnInfo(tableLogOnInfo); table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName; table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName; table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID; table.LogOnInfo.ConnectionInfo.Password = connInfo.Password; // Apply the schema name to the table's location table.Location = "mySchema." + table.Location; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)