You are viewing limited content. For full access, please sign in.

Question

Question

OLE Idispatch Exception code 0.. Error executing SQL command

SDK
Updated October 16, 2014
asked on October 14, 2014

This has been a working system until now; the OLE error above happens on the BeginSearch command line (see code section below). No problem connecting to LF.

It started bombing first on certain folders with large number of sub folders and files, now it bombs on any folder in Laserfiche.

 

====================================================

  mbarcode = '*' + mbarcode + '*'
  OSearch.Command='{LF:LOOKIN="&mdir", SUBFOLDERS=1} & {LF:name="&mbarcode",type="DBF"}'
  OSearch.BeginSearch(.T.)

====================================================

0 0

Replies

replied on October 14, 2014

Do those same queries work when you enter them verbatim in the Laserfiche client?

0 0
replied on October 14, 2014

Thanks for the response.

Not sure how to run in client, I only know SDK commands. 

But just now we are getting general database error (9008) inside Laserfiche trying to create a new folder. 

0 0
replied on October 14, 2014 • Show version history

This page of the user guide covers "advanced searches", which is where you can enter search syntax directly into the search form.

It could be that you are seeing that same general database error, just reported differently.  There should be more information in the event viewer on the Laserfiche server machine.

0 0
replied on October 16, 2014

We ran into the 4G filegroup limit on our express version of MSSQL.

Thanks for the help.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...