Custom Filter for .msg files

I have an app that is automatically storing e-mails from Outlook in an image
field in SQL 2000. I have found where certain types of files have built in
filter support for searching, but .msg is not included as one of these.
Is anyone aware of anyway to do searches on the .msg file type within SQL.
BOL references the ability to create custom filters, but I am unable to find
the reference.
TIA,
J. Clay
did you try the following?
open up hkey_classes_root, locate msg, add a sub key to .msg called
PersistentHandler, add a string value called (Default)
with the value {5645C8C2-E277-11CF-8FDA-00AA0X0A14F93}
this uses mimefilt.dll which should be on most modern os's - win2k and
above.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"J. Clay" <JClay@.NoSpam.nospam> wrote in message
news:ew8U6WNUFHA.628@.TK2MSFTNGP09.phx.gbl...
> I have an app that is automatically storing e-mails from Outlook in an
image
> field in SQL 2000. I have found where certain types of files have built
in
> filter support for searching, but .msg is not included as one of these.
> Is anyone aware of anyway to do searches on the .msg file type within SQL.
> BOL references the ability to create custom filters, but I am unable to
find
> the reference.
> TIA,
> J. Clay
>
>
|||No. (Wouldn't have known how!) I will give it a try though and report
back.
Thank you very much!
Jim
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O$osm5NUFHA.3280@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> did you try the following?
> open up hkey_classes_root, locate msg, add a sub key to .msg called
> PersistentHandler, add a string value called (Default)
> with the value {5645C8C2-E277-11CF-8FDA-00AA0X0A14F93}
> this uses mimefilt.dll which should be on most modern os's - win2k and
> above.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "J. Clay" <JClay@.NoSpam.nospam> wrote in message
> news:ew8U6WNUFHA.628@.TK2MSFTNGP09.phx.gbl...
> image
> in
SQL.
> find
>
>
|||Actually MIME IFilter is capable of extracting text, but it does not deal
with attachments. In order to have full access to the information inside
..msg file I suggest using MSG IFilter, developed by Alna:
http://www.alna.com/vid.php4?mid=93&cat_id=4&prod_id=2.
Best regards,
Michailas
"J. Clay" <JClay@.NoSpam.nospam> wrote in message
news:OTUOX9NUFHA.3596@.TK2MSFTNGP14.phx.gbl...
> No. (Wouldn't have known how!) I will give it a try though and report
> back.
> Thank you very much!
> Jim
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O$osm5NUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> SQL.
>
>
|||Thanks Michailas - I think that is what I am looking for. I will make some
inquiries.
Regards,
Jim
"MT" <mtraubas@.alna.lt> wrote in message
news:%23E4qd1hUFHA.3716@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Actually MIME IFilter is capable of extracting text, but it does not deal
> with attachments. In order to have full access to the information inside
> .msg file I suggest using MSG IFilter, developed by Alna:
> http://www.alna.com/vid.php4?mid=93&cat_id=4&prod_id=2.
> Best regards,
> Michailas
>
> "J. Clay" <JClay@.NoSpam.nospam> wrote in message
> news:OTUOX9NUFHA.3596@.TK2MSFTNGP14.phx.gbl...
an[vbcol=seagreen]
these.[vbcol=seagreen]
to
>
>

Custom Assembly error

I have created a custom assembly to automatically display parameter names in
a textbox an a report. The parameters display through the previ
When I run my report through 'DebugLocal' mode.
it breaks here:
Public Class ParameterList
Public Shared Function GetParameterNames()
Dim rs As New ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim report As String = "/Commission Reports/Detailed Broker
Commission Bordereaux"
Dim forRendering As Boolean = False
Dim historyID As String = Nothing
Dim values As ParameterValue() = Nothing
Dim credentials As DataSourceCredentials() = Nothing
Dim strParam As String = ""
Dim Parameters() As ReportParameter
Parameters = rs.GetReportParameters(report, historyID, forRendering,
values, credentials)
If Not (Parameters Is Nothing) Then
Dim rp As ReportParameter
For Each rp In Parameters
strParam = rp.Prompt & strParam
Next rp
End If
Return strParam
End Function
End Class
break point : rs.Credentials = System.Net.CredentialCache.DefaultCredentials
The message reads :
"Request for the permission of type
'System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
failed."
What can I do?
Any help would be appreciated.
ThanksOn Jun 29, 3:28 am, DylCole <DylC...@.discussions.microsoft.com> wrote:
> I have created a custom assembly to automatically display parameter names in
> a textbox an a report. The parameters display through the previ
> When I run my report through 'DebugLocal' mode.
> it breaks here:
> Public Class ParameterList
> Public Shared Function GetParameterNames()
> Dim rs As New ReportingService
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim report As String = "/Commission Reports/Detailed Broker
> Commission Bordereaux"
> Dim forRendering As Boolean = False
> Dim historyID As String = Nothing
> Dim values As ParameterValue() = Nothing
> Dim credentials As DataSourceCredentials() = Nothing
> Dim strParam As String = ""
> Dim Parameters() As ReportParameter
> Parameters = rs.GetReportParameters(report, historyID, forRendering,
> values, credentials)
> If Not (Parameters Is Nothing) Then
> Dim rp As ReportParameter
> For Each rp In Parameters
> strParam = rp.Prompt & strParam
> Next rp
> End If
> Return strParam
> End Function
> End Class
> break point : rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> The message reads :
> "Request for the permission of type
> 'System.Security.Permissions.EnvironmentPermission,
> mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
> failed."
> What can I do?
> Any help would be appreciated.
> Thanks
This link might be helpful.
http://odetocode.com/Articles/216.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Jun 29, 3:28 am, DylCole <DylC...@.discussions.microsoft.com> wrote:
> > I have created a custom assembly to automatically display parameter names in
> > a textbox an a report. The parameters display through the previ
> >
> > When I run my report through 'DebugLocal' mode.
> > it breaks here:
> >
> > Public Class ParameterList
> >
> > Public Shared Function GetParameterNames()
> > Dim rs As New ReportingService
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > Dim report As String = "/Commission Reports/Detailed Broker
> > Commission Bordereaux"
> > Dim forRendering As Boolean = False
> > Dim historyID As String = Nothing
> > Dim values As ParameterValue() = Nothing
> > Dim credentials As DataSourceCredentials() = Nothing
> > Dim strParam As String = ""
> >
> > Dim Parameters() As ReportParameter
> > Parameters = rs.GetReportParameters(report, historyID, forRendering,
> > values, credentials)
> >
> > If Not (Parameters Is Nothing) Then
> > Dim rp As ReportParameter
> > For Each rp In Parameters
> > strParam = rp.Prompt & strParam
> > Next rp
> > End If
> > Return strParam
> > End Function
> >
> > End Class
> >
> > break point : rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> >
> > The message reads :
> >
> > "Request for the permission of type
> > 'System.Security.Permissions.EnvironmentPermission,
> > mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
> > failed."
> >
> > What can I do?
> >
> > Any help would be appreciated.
> >
> > Thanks
>
> This link might be helpful.
> http://odetocode.com/Articles/216.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
> Thanks Enrique,
This helped (on my machine). However, when I try and put my assembly on
another machine, it doesnt work. Do you have another way to display the
parameter names on a report? if not I will figure it out eventually.
Thanks again