Codejock Developer Community : Multiple resources using Custom Provider.. http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 00:55:21 +0000 Thu, 03 Apr 2008 00:46:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10003 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Multiple resources using Custom Provider.. : Have a look at this posting...]]> http://forum.codejock.com/forum_posts.asp?TID=10003&PID=32993&title=multiple-resources-using-custom-provider#32993 Author: Stilki
Subject: 10003
Posted: 03 April 2008 at 12:46am

 
Have  a look at this posting on multiple resources and multiple schedules.
Even though it is using Access databases, the sample(s) attached show you how to load schedules. The backend database does not matter.
 
https://forum.codejock.com/forum_posts.asp?TID=7473&PID=24699#24699

]]> Thu, 03 Apr 2008 00:46:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=10003&PID=32993&title=multiple-resources-using-custom-provider#32993 <![CDATA[Multiple resources using Custom Provider.. : Hi all,I am so lost and...]]> http://forum.codejock.com/forum_posts.asp?TID=10003&PID=32809&title=multiple-resources-using-custom-provider#32809 Author: mc2x
Subject: 10003
Posted: 30 March 2008 at 1:46am

Hi all,

I am so lost and I don't know what to do anymore. Been searching the forum for the last three days about calendar activex but unfortunately my problem doesn't seem to have a clear solution.

My problem is about using custom data provider in the calendar
control. I wanted to use mssql as my data provider. I currently
have "schedules", "calendarevents", and "calendarrecurrencepatterns"
tables in my mssql. Data from calendarevents table have a parent
record from the schedules table. What I basically want is to show
the events from the calendarevents table under their corresponding
schedules. I have seen that this has no problem using the built-in
data providers as shown in the examples. But in mssql as the data
provider I find it rather confusing.

strcon = "Provider=custom;DSN=Calendar_SQLServer"

This is the connection string I'm using. Even though I have schedules
table in mssql I don't know why the statement:

    Dim pSchedules As CalendarSchedules
    Set pSchedules = pRes.DataProvider.Schedules

pSchedules.Count always return 0 when in fact I have around 5 records
in the schedules table. What I'm doing is that I manually loop thru
the schedules table and add the schedules manually to the resource
array.

This is where my main problem begins. After I have added the schedules
to the resource array, how in the world do I show the events under
that schedules in the calendar? I hope anyone could shed some light on me.

Thanks in advance.]]> Sun, 30 Mar 2008 01:46:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=10003&PID=32809&title=multiple-resources-using-custom-provider#32809