Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Coupling Outlook to SQL Server Expand / Collapse
Author
Message
Posted Thursday, January 20, 2005 12:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 258, Visits: 251
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kterry/couplingoutlooktosqlserver.asp


Post #156795
Posted Monday, January 31, 2005 11:31 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209
seems to be a good article
but
is this query correct

CREATE TABLE [tblCpls] (
[cplNum] [int] NULL ,
[cplName] [varchar] (4000) NULL ,
[cplDesc] [varchar] (1000) NULL,
CONSTRAINT [PK_tblList] PRIMARY KEY CLUSTERED
(
[cplnum]
) ON [PRIMARY]
)
) ON [PRIMARY]
GO

how can u create a Clustered index on nullable column ??







My Blog: http://dineshasanka.spaces.live.com/
Post #158689
Posted Tuesday, February 1, 2005 12:41 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209
I am really intersted on this article
but how can find those IDs in my enviroment

strOlStoreID = "18DE200A0C99D6DC800AA002FC45A06000000504B435654303100D"
strOlEntryID = "5B7D1118DE200A0C99D6DCCCBA91795B7D11145A06000000504B435654300000"










My Blog: http://dineshasanka.spaces.live.com/
Post #158700
Posted Tuesday, February 1, 2005 2:11 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188

Great article Terry, I enjoyed reading it.

I'm interested in the following:

"I did come across a driver that could be used to directly access exchange as a linked server (I hoped)"

What driver was this?

Why did it not work?

Why is it limited to having Exchange and SQL Server on the same physical machine?

 



Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #158708
Posted Tuesday, February 1, 2005 2:36 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 13, 2007 8:36 PM
Points: 10, Visits: 1
That's the "Exchange OLE-DB driver"; It has that and a number of other limitations. The example code Microsoft published in an MSDN article for using the driver has some glaring ommissions (e.g., the code snippets shown just plain will not work!!).

This article Kevin did is a good illustrative article of what is possible using ActiveX script in Microsoft SQL Server.

Between this article and the Lotus Notes ODBC driver article of a few days ago, I'd say this season is shaping up to be a SQL Server messaging extravaganza at SQL Server Central!!




Respectfully,

Steve
logicom-inc..com
Post #158712
Posted Tuesday, February 1, 2005 7:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 258, Visits: 251
I am really intersted on this article
but how can find those IDs in my enviroment

strOlStoreID = "18DE200A0C99D6DC800AA002FC45A06000000504B435654303100D"
strOlEntryID = "5B7D1118DE200A0C99D6DCCCBA91795B7D11145A06000000504B435654300000"

----------------
First, yes you're right, that column should be not null (I just auto-generated a template of QA, and changed col names, without really looking at it).
If you navigate to the particular folder you're interested in, storeid and entryid are properties, accessible that way. Our resident outlook guru gave me the following code to get them (just cut and paste into notepad and save as vbs file, then run):

Dim objOutlook
Dim NmSpace
Dim myfld
Dim objFilesys
Dim objtxtfile
Dim txtIDS

Set objOutlook = WScript.CreateObject("Outlook.Application")

Set NmSpace = objOutlook.GetNameSpace("MAPI")

Set myfld = NmSpace.PickFolder

Set objFilesys = WScript.CreateObject("Scripting.FileSystemObject")

Set objtxtfile = objFilesys.CreateTextFile("C:\IDinfo.txt")

txtIDS = "The Store ID: " & myfld.StoreID & Chr(13) & Chr(10) & "The Entry ID: " & myfld.EntryID

WScript.Echo txtIDS

objtxtfile.WriteLine txtIDS


objtxtfile.Close



Post #158775
Posted Tuesday, February 1, 2005 8:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 7, 2010 8:19 AM
Points: 327, Visits: 123

Very good article Terry!!!

Do you know where to get properties/elements to be able to read data elements for the inbox?

Is is also possible to delete items in the inbox via ActiveX code from SQL Server?

 

 

Post #158789
Posted Tuesday, February 1, 2005 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 11:12 AM
Points: 3, Visits: 2

Very Interesting and wonderful article. 

But I have a question on the EntryID and StoreID.   From the article, it is my understanding that you need the EntryID and StoreID of the Form that you want to query information on.

The script you posted here, wouldn't that just get the EntryID and StoreID of just the public folder.   Or is that all we need.

Thanks.

Post #158813
Posted Tuesday, February 1, 2005 10:16 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 13, 2007 8:36 PM
Points: 10, Visits: 1
In answer to the Id questions: Outlook Spy!!

Dmitry Streblechenko offers an eval version.

Many developers use it...



Respectfully,

Steve
logicom-inc..com
Post #158840
Posted Wednesday, February 2, 2005 11:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 258, Visits: 251
Whether or not you can delete probably has more to do w/ permissions than anything else, but yes there is a Delete method (and a Remove method, depending on what your trying to get rid of).

Outlook comes w/ an object model available under Help (at least w/ Outlook 2003 which we have here), which gives you all properties, methods, objects etc.



Post #159148
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse