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!

  • Congratulations Wanet Telecoms Ltd 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. MrMystery

    CMOS Settings

    What's the keypress sequence to get into CMOS set up mode? I need to change the disk boot sequence, but can't get into CMOS Many thanks!
  2. MrMystery

    How do I reduce the size of my databases

    Thank you VERY much Corran007!! You have saved me from adding more disks to my server - I found a table which was eating LOTS of disk space, and it turned out to be redundant, so I deleted it and have freed up loads of space! Mike
  3. MrMystery

    MS Access front end to SQL

    I have a DTS which is scheduled to run at midnight each night. It is simply a T-SQL query which refreshes the contents of a transaction table with that days new transactions. However, there are occasions where I would like to run this DTS or the T-SQL query ad-hoc. I would like to provide this...
  4. MrMystery

    Report Viewer in IIS

    Thanks for your reply. I have tried both the ODBC connection and the native SQL in the report. Both give me the same error. Any other ideas?
  5. MrMystery

    Report Viewer in IIS

    I am running IIS on Windows NT 4 Server. I have a copy of Crystal Reports 8 installed on the same server. I have an HTML page which links to a Crystal Report. The Crystal report is linked to an SQL server 'view'. I load up Internet Explorer and connect to the web page, click on the link and the...
  6. MrMystery

    Login to SQL Server

    Hi fbermudez, which management console do you mean? Can you tell me where to find this option?
  7. MrMystery

    Login to SQL Server

    I just have the Web Component services installed on my IIS server, and have the report in a hyperlink from my HTML web page.
  8. MrMystery

    Login to SQL Server

    I have Crystal 8 reports which are hosted on a web server, and are run via the Crystal Reports viewer. These reports connect to a SQL server database. When a report is first run, it requests the logon details to connect to SQL server. This isn't too bad for a simple report, as the login is only...
  9. MrMystery

    Crystal & SQL Server Stored Procedures

    I have a Crystal 8 report which connects to a SQL Server 7 stored procedure. It works fine when I run it from my own desktop, but when I place it on our intranet, where it is run via Internet Explorer / Crystal Report viewer DLL, it returns an error; "Error detected by Database DLL&quot...
  10. MrMystery

    Intranet reporting

    I have a Windows NT 4 server, with IIS installed. I have created a simple HTML page, with a link to a Crystal 8.5 .rpt file. With Crystal Enterprise installed on the server, the report will open in a Crystal Report Viewer through Internet explorer,(prompting for download of the viewer for first...
  11. MrMystery

    Web Component Server

    I have a Windows NT 4 server, with IIS installed. I have created a simple HTML page, with a link to a Crystal 8.5 .rpt file. With Crystal Enterprise installed on the server, the report will open in a Crystal Report Viewer through Internet explorer,(prompting for download of the viewer for first...
  12. MrMystery

    MS Messenger

    Does anyone know what impact MS Messenger will be having on my company's network bandwidth? Should I be preventing people from using it?
  13. MrMystery

    Enterprise v Standard

    Can someone tell me, in simple terms, what is the difference between SQL Server Enterprise and SQL Server Standard?
  14. MrMystery

    ODBC Connection to SQL Server 7

    Hi. I use SQL authentication on my SQL Server installation, and I need to distribute a Crystal Report to multiple users. I don't want them to have to enter the SQL user id and password each time they run the report. Is there any way I can store the user id and password somewhere either in the...
  15. MrMystery

    Problem seeing Replicated Public Folder with Office XP.

    Hi! Did this problem get resolved? I am having the same problem.
  16. MrMystery

    Public Folders

    My company employs MS Exchange 5.5 on Windows NT4 Servers throughout it's 200+ sites. A public folder has been created on a central server, and is being replicated to all other sites. We have discovered that some employees can't see the contents of this folder. It seems that the pattern...
  17. MrMystery

    WHERE statement

    Is it possible to build a condition into an SQL where statement to perform a different selection dependant on the value of a selection parameter? e.g. Selection Parameter = JobNo Value can be either a job number or 'ALL' If I enter a job number, then my 'WHERE' statement must only select values...
  18. MrMystery

    Removing Duplicate Records

    Brilliant! This worked a treat! Many thanks. Mike
  19. MrMystery

    Removing Duplicate Records

    All of the columns except one are the same. The one that may be different is the project manager assigned to the project. However, we are taking the view that once we are left with only 1 occurrence of each project, these will be printed out for checking by each project manager, and any errors...
  20. MrMystery

    Removing Duplicate Records

    Hi. I have a table containing project numbers which are numbered as follows 1000N 1000S 1000T 1000X through to 9999N 9999S 9999T 9999X The suffix letter indicates a department of the company. We have changed our reporting requirements to dispense with individual departments, and instead to...

Part and Inventory Search

Back
Top