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 Chriss Miller 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: *

  • Users: plevey
  • Content: Threads
  • Order by date
  1. plevey

    Running IIS causes client browser on same machine to keep hitting google-analytics

    I have recently installed IIS on my home machine ( Windows XP SP3) and built a simple web site to allow family members to browse 'photos etc stored on an external hard drive from their own devices via WLAN. What I have found is that when IIS is running and I try to browse the internet from the...
  2. plevey

    How to focus default item in listbox prompt

    thread401-1392169 Cognos 8.4 Report Studio Using a listbox to prompt for Fiscal Year. Current fiscal year should be highlighted (selected) by default, but still allow user to select another year. In other words I'd like an example script which focuses the list item based on some sort of...
  3. plevey

    Extracting data from a Progress SQL database truncates varchar columns

    Extracting data from a Progress SQL database truncates varchar columns. Environment : Windows 2000 SP 4 MS SQL Server 2000 Microsoft SQL Server 2000 - 8.00.760 Standard Edition (Build 2195: Service Pack 4) ODBC Driver is DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E 99% of the time all is...
  4. plevey

    Pass parameter to ReportNet event driven report

    I've successfully run a Report Studio report from a command line using the trigger.bat file but does anyone know how, or if it's possible, to pass a parameter e.g. invoice number so that I can trigger the production of an invoice from another application. If fishing was easy it would be called...
  5. plevey

    Export data to DB2 fails

    I'm trying to use DTS to export data to DB2 but get 'The number of failing rows exceeds the maximum specifed' Not very helpful. The Transform Data task Destination tab correctly retrieves the columns from the DB2 table but a decimal(5,0) column is shown as numeric. I can import data from DB2...
  6. plevey

    How to read insert data from spreadsheets

    I need to insert data into an SQL table by reading multiple Excel spreadsheets. I've figured out how to code the loop but decided to test with a single sheet. When I run the following code in Query Analyser I get: Server: Msg 7202, Level 11, State 2, Line 32 Could not find server 'Excel' in...

Part and Inventory Search

Back
Top