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

    RAISERROR returns wrong line number of error in TRY/CATCH

    I have a stored procedure that uses the TRY/CATCH error handling. When an error occurs, the line number (ERROR_LINE) value is incorrect. Msg 50000, Level 16, State 1, Procedure MyProcedure, Line 89 Divide by zero error encountered. [/code' First, this is the CATCH block: BEGIN CATCH SET...
  2. BFarley

    Log errors at application or database level?

    My ASP.NET application uses a SQL Server 2008 database. Very few data operations would happen outside of the ASP.NET interface, and then only by system admins on rare occasions. Would there be any downside to logging errors from within ASP.NET only? My thought is that I'd use the Exception...
  3. BFarley

    NullReferenceException when using custom role provider

    I have a custom role provider & custom membership provider on my app. Membership works okay so far, but I get an error when I try to use the role provider. I've verified that the username (tcallahan) is in the database, and a member of the role ("Administrators") that I'm checking. Here's...
  4. BFarley

    Problem with custom role provider

    I created a custom role provider for my application, but it doesn't return the proper value for IsUserInRole. Section of web.config that defines the provider: <roleManager defaultProvider="MyTestAppRoleProvider" enabled="true"> <providers> <clear/> <add...
  5. BFarley

    Best authentication method for this project ...

    I started going down the path of forms authentication using SQL Server to store user/membership data, but came across a few stumbling blocks -- that led me to back up and decide whether or not that's even the best authentication method. A bit of background: Each user may have the ability to...
  6. BFarley

    Table setup questions when using HierarchyID

    We're creating a database to manage all activities associated with a contract (i.e. tasks, subtasks, and activities) and their associated costs. The new HierarchyID data type looks like it will be a GREAT way to show relationships between tasks & associated subtasks etc, and allow flexibility...
  7. BFarley

    Excel 2003: Unexpected option to save as Excel 2007

    I have several Excel 2003 (.XLS) files on a remote network drive. My local PC has Office 2003 apps, but not Office 2007. If I navigate to the remote drive, right-click on an .XLS file, and click Save As, the available file types are all Excel 2007 (.XLSX, .XLSM, .XLSL). I didn't expect to see...
  8. BFarley

    Help with sorting an array by a specific field

    I have a text file that I have to work with frequently. It's submitted by a client, and I bring it into a VB.NET application to do various things. Sample data: DATE EMP JOBNO AMT 7/25/2008 12345 XYZ12345 5.99 7/22/2008 23456 XYZ12346 4.99...
  9. BFarley

    Undo changing value of DatePicker control?

    I have a form with a Datepicker control. Once the date changes, there are some actions that need to be performed ... however, I'd like the user to be aware of these changes, and allow the user to cancel out, restoring the DatePicker's original value. This would be analogous I suppose to code...
  10. BFarley

    Remove trailing blank line in text file

    I have a comma delimited text file from which I'm reading. After I work the contents of each line & determine it's not a blank line, I write that line into a new text file. So the new file is the same as the original, except any blank lines have been removed. My problem is that there is always...
  11. BFarley

    Permissions/role for DTS user

    We have a user who only uses the SQL Server 2000 database to run one or more DTS packages that reads from tables & exports the data. The user should be able to do nothing else. In particular, we want to restrict the user from seeing - let alone modifying - any stored procedures, user-defined...
  12. BFarley

    Displaying info to user as Crystal Report loads

    I've got a form named frmReportViewer, containing a CrystalReportViewer named crvReportViewer. frmReportViewer is an all-purpose form, displaying whatever Crystal Report I tell it to programmatically on a button click event from various forms. Some sample code: Dim cur As Cursor =...
  13. BFarley

    Closing form that contains Crystal Report Viewer

    I've got a form that contains a Crystal Report Viewer control. Everything displays great! But out of all the examples I've seen, nothing shows the best way to close the form and report. I've set the ShowCloseButton property of the viewer to True, but the viewer's close button is grayed out...
  14. BFarley

    Changes not showing after ImportRow

    I'm selecting data from SQL Server and attempting to insert it into an Excel workbook, by using ImportRow to copy data between two datatables (http://support.microsoft.com/kb/305346). Both datatables are created ... and I'm able to append data from one datatable to the other. However, the...
  15. BFarley

    Query results

    I have two queries that run fairly quickly, and would like the results of each to appear in a single grid, without using a temp table. Here's how I'm doing the selection ... SELECT AcctNo, AcctName, SUM(TransAmt) AS Table1Total FROM Table1 WHERE TransDate BETWEEN '4/1/08' AND '5/1/08' GROUP BY...
  16. BFarley

    Applying payment across multiple items

    I have a process that I'm converting to T-SQL from VBA (which of course uses looping), and I wanted to see if it could be used without touching each row. Here's the situation. A payment is received. There are one or more line items against which the payment can be posted. (You may have seen...
  17. BFarley

    How to programmatically access mapped drive thru Remote Desktop?

    The problem being encountered occurs in programming, but the base issue is strictly at the server level, so that's where I'm going to start searching :) We've got a routine that requires users to log into Remote Desktop, and then copy a file from a local drive on their PC to a folder on the...
  18. BFarley

    Export to XML that's readable by Microsoft Office

    I'm able to create an XML file using WriteXml, and it looks just fine. However, when I try to open it in Office applications using VBA, it gives an error that the format is invalid. Is there any way to direct the output to persist in a format easily readable by Office VBA code? Thought for...
  19. BFarley

    Opening ADO recordset from XML created by VB.NET

    I have an XML file that was created by a VB.NET routine. When I try to open it as an ADO recordset in VBA, I get the following error: (3709) The connection cannot be used to perform this operation. It is either closed or invalid in this context. Code I'm using to attempt opening the XML as...

Part and Inventory Search

Back
Top