Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VitoMark

    ActiveX component error in a windows service file???

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

    ActiveX component error in a windows service file???

    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...
  3. VitoMark

    Error in Query

    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...
  4. VitoMark

    Full-text indexing on PDF documents

    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...
  5. VitoMark

    Full-text indexing on PDF documents

    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?
  6. VitoMark

    Full-text search on imported documents

    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.
  7. VitoMark

    Full-text search on imported documents

    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...
  8. VitoMark

    Full text search in docs in a table possible?

    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...
  9. VitoMark

    Repeater Control and Subtotals

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

    Repeater Control and Subtotals

    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...
  11. VitoMark

    XP_Sendmail with @Query

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

    XP_Sendmail with @Query

    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...
  13. VitoMark

    XP_Sendmail with @Query

    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...
  14. VitoMark

    XP_Sendmail with @Query

    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?
  15. VitoMark

    Long waiting time while checking out

    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?
  16. VitoMark

    Stored Procedure: Sort by Variable Column

    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 ' +...
  17. VitoMark

    Removing READ-ONLY property with Enterprise manager doesn't work

    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...
  18. VitoMark

    SQL BLOB in Crystal reports - Word document

    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...
  19. VitoMark

    Failed getting rowset(s) from current data source

    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)
  20. VitoMark

    Failed getting rowset(s) from current data source

    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?

Part and Inventory Search

Back
Top