Recent content by VitoMark

I just found a solution: I run the service under a Network user acoount, not under local system. Now it works.

Hello, I encountered the same problem, Cannot create ActiveX Compontent, after converting my windows-app to a Windows service. I'm still searching for a solution...

Hello, If you don't have to know the value of @x outside the query, you should omit @x and you should add after the GROUP BY clause a HAVING Clause: ... HAVING (Sum (ISNULL(AL2."Quantity Added", 0)) - Sum (ISNULL(AL2."Quantity Taken",0))) < 5 Otherwise you could use f.i. Declare @x int Set @x...

Hi, Now I'm able to index Office documents and PDF documents. This is what I did: - Applied SP3 for SQL Server 2000 - ADOBE Acrobat reader installed on SQL Server - ADOBE filter installed (cfr. http://www.adobe.com/support/downloads/thankyou.jsp?ftpID=2611&fileID=2457); you have to put...

Any idea if I can use Full-text indexing from SQL-server 2000 on imported PDF-documents? TRhe documents are imported with adodb.stream. I suppose it's impossible... Are there any workarounds?

I think I found the solution. Some of the Word documents where out-dated (Word-2). After re-saving them in a newer Word-2000 format the problem was solved.

I would like to do a full-text search using SQL Server 2000 on a bunch of documents (.DOC, .XLS). But I always get an empty resultset. How did I setup the full-text search? 1) I created an SQL-table with an image-type and a sysname-type column respectively for the content of a document, and...

Did you already received a solution for this problem? I've uploaded documents (.DOC) with ADODB.stream into an SQL-table (not external). I've added the table to a catalog and populated the catalog I've used a column with the extension of the document But my Contains-query always returns 0 rows...

Thanks. I just solved my problem by using "Iif" in steda of "If". So I handle this with an expression.

Hello, I've a problem that could be solved if your problem is solved: Which modification did you supply to these codelines to let it work? I always receive (in a similar xase) an error "expression expected" <ItemTemplate> <%# if Container.DataItem("Customer_ID") = "" then %> <tr...

Good news! We solved the problem: upgrade SQL Server 2000 with service pack 3A.

Hello, Thanks for your answer. A little bit more information. Whatever query I use, Whatever database I'm in, I only receive this error (sp_setuserbylogin not found) when I'm using the @query parameter on 2 of our 6 SQL server 2000 machines. I don't have any idea where this stored procedure...

Hello Wyldcard9, This is wat I try tu use (f.i. from master database): EXEC xp_sendmail @recipients = 'mark.jansen@vito.be', @subject = 'SQL email test', @query='select count(*) from sysobjects', @message = 'Paul says HELLO from SQL'. It's the @query-parameter that causes the error. We...

When using XP_Sendmail with @Query I recieve this error message: ODBC error 2812 (42000) Could not find stored procedure 'sp_setuserbylogin' Any idea what's happening?

When checking out a file from VSS using Visual Basic (VS 6 - sp 5), I detect very long waiting times (Not responding...) I have to end the task after several minutes Any idea what happens?