SQL7 Full textindexing sends MTS out to lunch

SQL7 Full textindexing sends MTS out to lunch

Post by Robert Dufou » Tue, 15 Aug 2000 04:00:00



My app, a dll running under MTS,  was returning error 80040e14. In it I had
opened one recordset, looked at some values, closed it, came to open another
recordset based on a view. When I tried to open this second recordset I got
back error 80040e14. Looking in msdn I found that this error was related to
a problem with full text indexing.
After I stopped and restarted the full text indexing of the database and
then ran my program again , the error went away.

The code that I was executing had absolutely nothing to with full text
indexing but in the view it was opening one of the tables that had a full
text index associated with it.

Just love this sh.... <GGGGGGGGG>

--
Robert Dufour, MCP, MCT
President SGI IMS Inc.
www.sgiims.com

 
 
 

1. Formatting data to send to MTS components

Hi:

I am using variant array to send from my client DLL's to my MTS DLL's. I
would like to use enumerations for each element in the variant arrays to
make the code more maintainable and readable; however I need the
enumerations to be "shared" by both my client DLL's and my MTS DLL's. I do
want to make the enumerations global because there would be too many.

Any suggestions on how to share the enumerations between a client DLL and
MTS DLL only ?

Thanks in advance, please post to Group(s)

Dave

2. CMYK colours in FMP 4

3. Problem sending ADODB.Command object across MTS packages !!!

4. Creating index affects my histogram

5. Formatting data to send to MTS components

6. Job: DBA - Vancouver, WA

7. Problem sending ADODB.Command object across MTS packages !!!

8. Type Mismatch error sending array or recordset variables to MTS from ASP

9. SQL7 + MTS + ADO : Select with where clause : Locks entrire table until Transaction ended

10. SQL7 & MTS

11. how stop MTS before install SQL7 SP1?

12. SQL7 + MTS + ADO : Select with where clause : Locks entrire table until Transaction ended