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: BuGlen
  • Content: Threads
  • Order by date
  1. BuGlen

    Detect redirect of a WebRequest

    I'm writing a console utility to download specific files from web sites. The problem I'm running into is that some web admins have taken it upon themselves to not return a 404 error of the URI of the file is incorrect. Instead they redirect the request to another page on the site to provide...
  2. BuGlen

    A RegEx grouping challenge

    I'm studying RegEx patterns for use in C# and I'm trying to find out if a subgroup scenerio is possible. I'm parsing an INI file and I'd like to return a single matches collection that contains the section, key, and value information for each entry. Here's what I have for patterns so far...
  3. BuGlen

    Select Case & Parameter Arrays

    I'm having a bit of problem with the Select Case logical expression in my formula. I have several parameter parameter fields that return arrays of values (using the Allow Multiple Values option). I'm trying to assign a group name based on which parameter array the item is found. Here's my...
  4. BuGlen

    Change datasource on deploy?

    We have CR 10 and CR Enterprise Server. When developing reports in the CR designer, I would like to set the datasource to the development SQL server and be able to change the source before deploying it to the enterprise server. This is standard practice in any development area in our...
  5. BuGlen

    Reporting Services Forum(s)?

    A question for the forum admins: Can you please set up forums for SQL Server Reporting Services? It's a relatively new product (January of 2004), but it's quickly becoming a hot topic in the Business Intelligence community. Two forums would probably be appropriate (one for setup & admin, and...
  6. BuGlen

    Workflow + Multiple Transform Data Tasks

    I have a package that is used to update tables on a Report server from a Production server and then creates a report from the data on the Report server. The steps are as follows: 1. Execute SQL Task - Clear local tables 2. Transform Data Tasks (3) - Update 3 local tables with data from remote...
  7. BuGlen

    Book recommendations please...

    I've just about completed an introductory book on VB.Net and I'm looking for some advised on good books for learning advanced topics going foward. My experience has been mainly with VBA/VB6 and client side web VBScript over the past 6 years. Since .Net introduces much more OOP into the VB...
  8. BuGlen

    MS Access connections to SQL Server

    Hey There, I've heard from some people (DBAs and Developers) at work that there are potential issues with using Access to create reports from linked tables to SQL Server. I've searched Google, but I couldn't find any technical articles on any known issues. I did find one that mentioned a...
  9. BuGlen

    Export to dynamicly created excel file?

    I have a DTS package that uses a query to export data to an Excel file. Everything works fine as long as the Excel file exists and the column names are pre-defined. What I would like to do is be able to create the Excel file during the DTS execution and define the columns based on the columns...
  10. BuGlen

    Folder Contents to Memo Field?

    I have a project that incorporates a memo field for richtext content. Through experimentation and research, I've been able to develop a method to convert the RTF content to HTML using the Word object. In many cases, this reduces the size of the RTF content by up to 95%, which includes the...
  11. BuGlen

    Stubborn Word VBA PageSetup.Orientation property

    I'm working on a project in Access that uses Word to print a report that contains fields with rich text. The rich text file is being created dynamically by combining the content from each of the fields and reformatting the rtf codes accordingly. Since the rtf document is being created...
  12. BuGlen

    Query: Parent / Child reference in same table

    Good Afternoon, I'm trying to find a query that will return a result set from a table that has the parent / child relationship in the same table. The table contains articles of information for a knowledge base application which is structured around a tree type interface. Each of the records...
  13. BuGlen

    ATI 9600 Pro (slight glitch)

    Hello, I just put together a new system with an ASUS A7N8X-E Deluxe MB and a Saphire (ATI) 9600 Pro video card, and it recently had a minor glitch. When I booted up the computer one day, the video showed what could only be described as "jail bars" of distortion / static on the screen (about 6...
  14. BuGlen

    Multiple updates in DTS

    I have this update query in my DTS package to null out blank values: ----- update catalog_import set vendor_sku = null where vendor_sku < '!' update catalog_import set vendor_desc_text = null where vendor_desc_text < '!' update catalog_import set uom = null where uom < '!' update...
  15. BuGlen

    XSLT Designer Tools?

    Has anyone found any good visual xslt designer tools? Something that could read data from ODBC sources would be a good bet as well. - Glen Know thy data.
  16. BuGlen

    DTS Text Import - Blanks vs. Nulls

    I'm setting up a DTS package to retrieve a file via FTP and import the data from tab delimted to a table. Everything works fine except that empty fields in the delimited file contain a space. I would like to convert that empty field to a null value on import. Does anyone have an ideas on how...
  17. BuGlen

    Batch SP Performance

    I have a batch process that imports data uploaded by vendors into a table for comparison and reporting. I created three SPs to handle the task but I could use some advice on making it more efficient. Here's the gist of the process (apologies in advance for the long post): Vendor data can...
  18. BuGlen

    Opinions on selective data replication

    Hello good people of Tek-Tips! I'm planning a project to create a snapshot of data from our CRM database and place it into an MSDE database for reporting purposes. Here's the basic concept: Pull specific fields from Problem Report, Change Request, and Service Order records that are currently...
  19. BuGlen

    Allow user to create private DB

    I'm working on moving our knowledge base application from an Access frontend/backend solution to a VB.Net frontend / MSDE 2000 backend solution. The MSDE database will be on a central server to which all users can access. In the current application, the user is able to create private DBs and...
  20. BuGlen

    MSDE and IIS 6.0 on same box

    I'm putting together a &quot;light&quot; application server box. It's configured with duel 1 GHz processors, 512 MB RAM, and about 50 GB RAID (mirrored) drives with Windows 2003 Enterprize edition. My questions is, has anyone here tried to run MSDE and IIS 6.0 on the same box? If so, what are...

Part and Inventory Search

Back
Top