VB - SQL server and Tasks in Exchange?

[BasSchouten]

We're building an application in VB with a SQL-server database. One of the functionalities of the application is the registration of tasks for certain users. These tasks are created when someone "executes" a procedure which effectively adds the tasks to an entity called Dossiers. At the moment these tasks are records in a Task-table on the SQL-server.

The users want to see those tasks assigned to them in their Outlook Tasklist. I'v managed to create a taskrequest from VB but this results in a object in Outlook, which i can't retrieve or follow from within VB (at least I havent found a foolproof way, I'v read that the EntryId is changing when someone moves a task to a different folder)

From the VB application I have to be able to show all the tasks involved with a certain dossier, and not only the tasks asssigned to the current user of the VB-application.

Does anybody have any suggestions about where to register these tasks for easiest access from within the VB application and from Outlook?


thanks Bas Schouten
System Development & Webdesign
CBIS BV Holland

 

[BasSchouten]

Addendum to the previous post:

A few possibilities that have crossed my mind:

* could i create the Exchange Task-items from within SQL-stored procedure? (This would elimimate the task-table and move the task-data to the Exchange-database)

* will i be able to read those tasks from within a stored procedure?

Bas Schouten
System Development & Webdesign
CBIS BV Holland

 

[BasSchouten]

My continuos searched has brought me to a page on the MSDN site which explains how to link a SQL-server to an Exchange database as a "Linked server" using OLE DB For Exchange ... but alas its aboutSQL server 2000 and Exchange 2000.

we're using SQL-server 7 and Exchange 5.5
Any body know if there is such a thing as OLE DB for Exchange 5.5. ??

thanks Bas Schouten
System Development & Webdesign
CBIS BV Holland