Multiple resources using Custom Provider.. |
Post Reply |
Author | |
mc2x
Newbie Joined: 26 March 2008 Location: Philippines Status: Offline Points: 3 |
Post Options
Thanks(0)
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. |
|
Stilki
Groupie Joined: 27 May 2005 Status: Offline Points: 70 |
Post Options
Thanks(0)
|
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.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |