|
Home > Archive > IIS Index Server > March 2005 > Incorrect syntax near '<end of input>' SQL 42000 -2147217900
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Incorrect syntax near '<end of input>' SQL 42000 -2147217900
|
|
| Colin P 2005-03-17, 5:55 pm |
| I have a VB6 program which uses ms remote to query an Indexing Service
catalog on a remote machine. It works fine against remote machine 1, but
returns the above error against remote machine 2. Both are Win2k Pro
workstations. In comparing both machines I have checked user rights, MDAC
(2.8), IIS, Indexing Service and MSDFMAP.INI but I have not yet found the
cause of the differing results. To my newbie eye it looks as though my
entire Query is being rejected by machine 2. Can anyone help?
--
Colin P
| |
| Colin P 2005-03-18, 5:56 pm |
| Further information: definitely the problem is local to machine 2, presumably
in installation or configuration. The VB6 program can run locally as well as
remotely; it works fine on machine 1, but returns the above error when run
locally on machine 2.
Any ideas appreciated.
"Colin P" wrote:
> I have a VB6 program which uses ms remote to query an Indexing Service
> catalog on a remote machine. It works fine against remote machine 1, but
> returns the above error against remote machine 2. Both are Win2k Pro
> workstations. In comparing both machines I have checked user rights, MDAC
> (2.8), IIS, Indexing Service and MSDFMAP.INI but I have not yet found the
> cause of the differing results. To my newbie eye it looks as though my
> entire Query is being rejected by machine 2. Can anyone help?
> --
> Colin P
| |
| Colin P 2005-03-23, 8:51 pm |
| Got it! I had left unknown SQL values disabled with the SQL=" " entry in
MSDFMAP.INI. Well... I am a newbie to Indexing Service. Maybe this posting
will help someone else.
Thanks.
"Colin P" wrote:
> I have a VB6 program which uses ms remote to query an Indexing Service
> catalog on a remote machine. It works fine against remote machine 1, but
> returns the above error against remote machine 2. Both are Win2k Pro
> workstations. In comparing both machines I have checked user rights, MDAC
> (2.8), IIS, Indexing Service and MSDFMAP.INI but I have not yet found the
> cause of the differing results. To my newbie eye it looks as though my
> entire Query is being rejected by machine 2. Can anyone help?
> --
> Colin P
|
|
|
|
|