Recent content by qztm51

I've never tried to use "Like", or maybe it's the single quotes...anyway... You could try something like: =IIF(left(Fields!FFOSV1.Value, 3) = "F20", "bla bla", "") Hope this helps,

Mike, Thank you for your response. I think you are correct about the Debug feature not working on functions. I had read the books online, but seeing the Debug greyed-out and also reading comments on other web sites made me think it was possibly permissions. I guess it was wishful thinking...

Somebody please help! I have a user defined function in SQL Server 2000 that I need to debug. When I go into Query Analyzer and right click on the function in the Object Browser, the Debug option is there, but it is greyed out. I have opened the Query Analyzer through both Enterprise...

I have Index Server 3.0 running on a Windows 2000 server with IIS 5.0. In addition to the default Web Catalog, I have created a catalog - CustomerName and added directories for the files to be indexed. I have edited a query.idq file and query.htx file that properly return records when I used...

Gladys, Got it! Thank you for your help.

I am trying to do this because I need to set up an ODBC connection to an MS Access database on the file server. If I set up a mapped drive using a drive letter, the SQL server cannot access file server to make the ODBC connection unless I am logged on to the server. To the best of my knowledge...

I need to set up a mapped drive on a Windows 2000 server running SQL Server that points to a Windows 2000 file server. The SQL Server needs to be able to access the other server to retrieve data to run a DTS package unattended so it can't be a drive letter mapping. I have done this in the past...

FYI - I figured it out - when the DSNs were orignially created, the workbook path was set using a mapped network drive for the path instead of the UNC path.

I hope I have this in the right place... I am receiving the following error when my asp page tries to access an Excel file being used as a database. [Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to...

I have created a VB 6.0 app for running a report that uses the Crystal Report Control (CR v. 8.5). The report accesses a SQL Server 7.0 database. Within the SQL Server database, I have a table which stores the document paths for up to 6 documents/record. When I run the report I need to have...