Wrox Programmer Forums
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 9th, 2003, 09:47 AM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 205
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query Object Limitation?

I am writing a search routine using Visual Basic 6.0 to
query the Indexing Service on a remote machine. I am
having the following problems:

If I use the Indexing Service Query Object provided by
Microsoft, I am getting an error when my query has over
815 clauses in the query parameter of the query object.
Is this a limit of the Query Object or the Query language
it is using?

If I use SQL through ADO I do not run into this issue,
however I cannot find a way to set up a remote connection
using the connection object. Does anyone know how to do
this?

Can someone help me?

Thanks,
Yehuda
 
Old September 10th, 2003, 03:20 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

There's an example of ADO connection string plus links to more info here http://www.able-consulting.com/MDAC/...forIndexServer
 
Old September 10th, 2003, 08:19 AM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 205
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I know that link. However, that allows me to connect to the Index Server on my machine. I want to remotely connect to an Index Server on a different machine.

Thanks,
Yehuda
 
Old September 11th, 2003, 04:42 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 205
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just to update this. I have found a way to remotely connect via SQL. However, this is not the answer to the question. It appears to be a limitation of querying the Index Server remotely. I can workaround with a remote COM+ object, but I am hoping for an answer without having to resort to this. Can anyone provide me with any limitations of querying the Index Server remotely (I know this is a bit off topic, but there doesn't appear to be any forums on the Index Server on wrox)?

Thanks,
Yehuda





Similar Threads
Thread Thread Starter Forum Replies Last Post
Limitation of .Net Suneet Sharma General .NET 6 July 16th, 2007 02:03 PM
Limitation of Access anubhav.kumar Access 2 February 11th, 2005 08:28 AM
data type limitation nlicata SQL Server 2000 5 October 17th, 2003 05:17 AM
Query Object Limitation? Yehuda VB How-To 1 September 11th, 2003 04:43 PM
ComboBox Limitation? misterqj Access 4 August 2nd, 2003 05:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.