Query Index Services from VB.NET

[c***@yahoo.com]

I am trying to use the ixsso Control Library in vb.net to query index
services and I am not sure exactly how to code it. Below is what I
have so far:

Dim query As New Cisso.CissoQuery
Dim rs As New ADOR.Recordset

query.AllowEnumeration = False
query.Catalog = "PSC009.docketq"
query.Columns = "FileName, Characterization"
query.SortBy = "Rank"
query.Query = "filename = ''testpdfwithtext.pdf''"
rs = query.CreateRecordset("nonsequential")

I get the follwing error when the createrecordset is executed

An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in test[df.exe

Additional information: There is no catalog.

the PSC009.docketq is a remote index, so trying to run it from a win2k
pc with Index Services installed and running may be a problem. Any help
would greately be appreciated.

[c***@yahoo.com]

Post by c***@yahoo.com
I am trying to use the ixsso Control Library in vb.net to query index
services and I am not sure exactly how to code it. Below is what I
Dim query As New Cisso.CissoQuery
Dim rs As New ADOR.Recordset
query.AllowEnumeration = False
query.Catalog = "PSC009.docketq"
query.Columns = "FileName, Characterization"
query.SortBy = "Rank"
query.Query = "filename = ''testpdfwithtext.pdf''"
rs = query.CreateRecordset("nonsequential")
I get the follwing error when the createrecordset is executed
An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in test[df.exe
Additional information: There is no catalog.
the PSC009.docketq is a remote index, so trying to run it from a win2k
pc with Index Services installed and running may be a problem. Any help
would greately be appreciated.

As a followup, I changed the query.Catalog line to read
query.Catalog = "query://PSC009.docketq" and the error I now get

An unhandled exception of type 'System.OutOfMemoryException' occurred
in testpdf.exe

Additional information: Not enough storage is available to complete
this operation.

Any additional help would greatly be appreciated.

[Miroslav Pragl]

not enough storage seems to be the track to go after. have you checked
eventlog on server as well as your comp?

Mirek

Post by c***@yahoo.com

Post by c***@yahoo.com
I am trying to use the ixsso Control Library in vb.net to query index
services and I am not sure exactly how to code it. Below is what I
Dim query As New Cisso.CissoQuery
Dim rs As New ADOR.Recordset
query.AllowEnumeration = False
query.Catalog = "PSC009.docketq"
query.Columns = "FileName, Characterization"
query.SortBy = "Rank"
query.Query = "filename = ''testpdfwithtext.pdf''"
rs = query.CreateRecordset("nonsequential")
I get the follwing error when the createrecordset is executed
An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in test[df.exe
Additional information: There is no catalog.
the PSC009.docketq is a remote index, so trying to run it from a win2k
pc with Index Services installed and running may be a problem. Any help
would greately be appreciated.

As a followup, I changed the query.Catalog line to read
query.Catalog = "query://PSC009.docketq" and the error I now get
An unhandled exception of type 'System.OutOfMemoryException' occurred
in testpdf.exe
Additional information: Not enough storage is available to complete
this operation.
Any additional help would greatly be appreciated.

[Hilary Cotter]

try it like this

query.Catalog = "query://PSC009.docketq"
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

Post by c***@yahoo.com
I am trying to use the ixsso Control Library in vb.net to query index
services and I am not sure exactly how to code it. Below is what I
Dim query As New Cisso.CissoQuery
Dim rs As New ADOR.Recordset
query.AllowEnumeration = False
query.Catalog = "PSC009.docketq"
query.Columns = "FileName, Characterization"
query.SortBy = "Rank"
query.Query = "filename = ''testpdfwithtext.pdf''"
rs = query.CreateRecordset("nonsequential")
I get the follwing error when the createrecordset is executed
An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in test[df.exe
Additional information: There is no catalog.
the PSC009.docketq is a remote index, so trying to run it from a win2k
pc with Index Services installed and running may be a problem. Any help
would greately be appreciated.

[c***@yahoo.com]

I am sorry, but how is that different than what I have previously
posted?

Here is the code as I have currently, I have added the Util object and
added a scope, and changed the recordset object from
ADOR.Recordset to ADODB.Recordset.

Dim query As New Cisso.CissoQuery
Dim util As New Cisso.CissoUtil

Dim rs As New ADODB.Recordset


query.Catalog = "query://PSC009.docketq"
query.Columns = "FileName, Characterization"
query.SortBy = "Rank"
query.Query = "@filename = testpdfwithtext.pdf"
query.MaxRecords = 1
util.AddScopeToQuery(query, "/", "Deep")
util.ISOToLocaleID("EN-US")
rs = query.CreateRecordset("nonsequential")

and it still gives me the same error message

An unhandled exception of type 'System.OutOfMemoryException' occurred
in test[df.exe

Additional information: Not enough storage is available to complete
this operation

I am currently querying the index through a SQL Server link, but I
would prefer to do it this way, so any help would greatly be
appreciated. Thanks in advance.