Search results for query: *

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?

Other solution could be, building a varchar string, containing the query to be executed. With EXEC() you can run this query: <i> Declare @strSql varchar(1000) Set @StrSql = 'SELECT sName, sStuff, iOtherStuff FROM tTable WHERE (' + @sName + 'IS NULL) OR (sName = ''' + @sName + ''') ORDER BY ' +...

When I try to remove the read only property of a SQL 2000 database , using Enterprise manager (properties of a database), I receive this error message: Error 5004: Tu use ALTER DATABASE, the databse must be in a writable state in which a checkpoint can be executed. I can remove the read only...

I have an SQL-table (SQL Server 2000) containing a BLOB-field, datatype IMAGE, filled with a MS/WORD-document. When extracting this field, I have an exact copy of the original Word-document. Now I try to link - using ADO - this BLOB-field to a Crystal reports, but the BLOB-field in CR is always...

Problem with navigation bar solved for Windows 2000: Navigation bar only showed when taskbar = autohide. To display navigation bar with taskbar <> autohide,i've modified de datareport properties (Windowstate=vbMaximize, WIdth/Height, Min-Maxbuttons true)

I encountered the same problem when converting a Win/nt application to Windows 2000 (using VB data reports). Any idea how I can fix this? Another problem: page-scrolling buttons on the data report aren't displayed on Windows 2000. Any idea?