Hi Frank,

Thank you for your reply. I'm still having problems connecting to the SQLServer version of WebSchedule2 rather than the Access version. I got some help from Infragistics and was able to create the SQL Server database running the query but I now cannot connect to it. I can't find it in Server Explorer or in App_Data, Add existing item. I also cannot find it when running the smart tag for SQLDataSource. I do see it when I run SQL Server but can't find it anywhere else.

The problem may be something I caused. I recently did a clean install of Windows 7 and all my software. Prior to that I had 2 versions of SQLServer (2005 & 2008) so insteal of my Server Name being ComputerName\SQLExpress it was ComputerName\MSSMLBIZ. I found MSSMLBIZ in my web.config and changed it to SQLExpress but it doen't help.

So I need to figure out how to connect to WebSchedule2 that I just created. 

Hi Frank,

I'm still getting help from Infragistics.

I’m making a little more progress. I may have found the database. I found WebSchedule2.mdf in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLExpress\MSSQL\DATA.

But I still cannot get to it using the smart tag in SQLDataSource, Add Existing Item in App_Data, Add Connection in Server Express. I also cannot copy it to App_Data.

I either get Access Denied or cannot find it when trying the above. I even changed my user to Admin and still get the same problem.

I haven't used the smart tag, I've coded my data connection in the code-behind.

Then in my aspx page I have an asp:Placeholder which gets replaced by teh viewer control later, the WebScheduleInfoControl, and the WebSceduleSqlClientProvider.  These have minimal options set here, most of the work is done in code-behind:

<asp:PlaceHolder runat="server" ID="CalendarViewPlaceholder"/>

<igsch:WebScheduleInfo ID="WebScheduleInfo1" runat="server" EnableSmartCallbacks="true" EnableUnassignedResource="False" EnableMultiResourceView="true" EnableMultiResourceCaption="false" EnableRecurringActivities="true" AppointmentFormPath="~/WebSchedule/AppointmentAdd.aspx" ReminderFormPath="~/WebSchedule/Reminder.aspx"/>

<ig_scheduledata:WebScheduleSqlClientProvider ID="WebScheduleSqlClientProvider1" runat="server" />

in the code-behind, I have this declaration

private static String connString = ConfigurationManager.AppSettings["InteractiveImpactConnectionString"];

which gets the connection string for my database from web.config.  It looks like this:

"Data Source=mysqlserver.name;Initial Catalog=databaseName;User Id=theuserName;Password=thePassword;"

so then in Page_Load I set it all up

protected void Page_Load(object sender, EventArgs e)

{

WebScheduleSqlClientProvider1.Connect(connString);

WebScheduleSqlClientProvider1.WebScheduleInfo = WebScheduleInfo1;

WebScheduleInfo1.ActiveResourceName = CurrentUser.ResourceName;

WebScheduleInfo1.LoggedOnUserName = CurrentUser.ResourceName;

CreateCalendarControl();

}

Creating the calendar control itself is done like this:

private void CreateCalendarControl()

{

System.Globalization.DateTimeFormatInfo format = new System.Globalization.DateTimeFormatInfo();

WebScheduleViewBase myCalendarViewControl = CalendarUtility.GetCalendarViewControl  ((CalendarUtility.CalendarViewType)CalendarView);

myCalendarViewControl.EnableAppStyling = Infragistics.WebUI.Shared.DefaultableBoolean.True;

//myCalendarViewControl.StyleSetPath = "~/ig_res";

//myCalendarViewControl.StyleSetName = "XpSilver";

myCalendarViewControl.ID = "theView";

myCalendarViewControl.WebScheduleInfo = WebScheduleInfo1;

myCalendarViewControl.Width = new Unit("900px");

myCalendarViewControl.Height = new Unit("400px");

WebScheduleInfo1.WorkDayStartTime = new Infragistics.WebUI.Shared.SmartDate(DateTime.Today.Date.AddHours(7.0F));

WebScheduleInfo1.WorkDayEndTime = new Infragistics.WebUI.Shared.SmartDate(DateTime.Today.Date.AddHours(17.0F));

CalendarViewPlaceholder.Controls.Clear();

CalendarViewPlaceholder.Controls.Add(myCalendarViewControl);

}