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 derfloh 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. octothorpe

    Melty

    The word was used in literature long before Taco Bell ever got hold of it, but I'm sure they're responsible for its popularity - kids are much more likely to see a Taco Bell commercial than read a book.
  2. octothorpe

    Authenticate SQL login programmatically

    Got it. exec sp_password @password, @password, @user Normally this is used to set the password, but just like ALTER LOGIN (which it calls), supplying the OLD_PASSWORD argument makes it work just as if the user were changing their own password. If the correct password is supplied, it succeeds...
  3. octothorpe

    Authenticate SQL login programmatically

    The connections are coming from a web server. Currently, all the connections are made passing the users' credentials in the database connection string. I've been asked to try getting the middle tier to connect with a single login, but since all the permissions are tied to the SQL user account...
  4. octothorpe

    Authenticate SQL login programmatically

    Hmm, maybe I wasn't clear. This is using SQL Authentication. Each of the users are set up in SQL and everything about their rights is tied to their SQL user, which can be impersonated by the application account (execute as). I've been tasked with making the application use a single logon for...
  5. octothorpe

    Authenticate SQL login programmatically

    I'm hoping there is a way to verify a user's password (SQL Server account) within SQL without logging in as that user. Instead, I'd like to connect with a pre-established application account (to take maximum advantage of connection pooling), then impersonate the user. Example: declare @user...
  6. octothorpe

    Security Poll.

    1) Firefox (haven't had any spyware since switching). 2) Firefox. 3) eTrust Innoculan/Vet 4) None (happens ISP side). 5) Sygate Personal Firewall. 6) None. 7) None.
  7. octothorpe

    Pulling @@Identity Variable

    strSQL = "INSERT INTO tblIncident (IncDesc, IncDate, StatusID, ClientID, ISStaffID) Values ('" & Replace(Problem.Text, "'", "''") & "', GetDate(),1," & strID & ",5) SELECT scope_identity()" Use the ExecuteScalar method instead of ExecuteNonQuery. Cast the result of the ExecuteScalar method...
  8. octothorpe

    Linux not appropriate for critical security applications

    On a related note: http://www.ccur.com/corp_news_pressrelease.asp?pressreleaseid=336 I personally find it hard to believe that any OS built upon the x86 hardware platform, which is very interrupt driven, could be reliable enough for real-time systems. Of course, I suppose that with the...
  9. octothorpe

    Message Logging

    dkediger: Yes. It hasn't been really enforced by the courts yet (no cases), but give it some time.
  10. octothorpe

    ISIS/TWAIN Scanning

    Since both ISIS and TIFF have been covered by patents in the past (ISIS may still be), you probably won't find much outside of commercial packages. Pegasus ( www.jpg.com ) has some solutions for both, TwainPRO and ScanXpress (ISIS). I have used ScanXpress in the past, but not TwainPRO. I...
  11. octothorpe

    Using CSS to alter hyperlink color

    If you declare classes for them, you can give specific links a certain color. HTML: <a class="header" href="url.html">Blah</a> CSS: a.header { color: #000; } Forgive me if my syntax is a little off.
  12. octothorpe

    Some points for discussion related to C#

    To address the differences between string and StringBuilder... The System.String is "immutable", meaning that when you create a string (e.g., string hello = "hello world";) a fixed length memory structure is created to hold that string. That value cannot be changed. If you manipulate a...
  13. octothorpe

    Some points for discussion related to C#

    You can't declare scope in an interface because everything *must* be public to be implemented. Since an interface can only have stubs, it can't be inherited from, only implemented. Private and protected members can't be accessed because they are class/inheritance specific and an interface is...
  14. octothorpe

    Server Capacity Guidelines

    This is very application specific. If you are serving up static pages, each server will be able to handle more than if you were serving up dynamic content. If you are unable to satisfy the load, then one of three things is true: 1) You need more bandwidth. 2) You need more horsepower. 3) Your...
  15. octothorpe

    Truetype fonts not clear on monitor screen

    Monitor type? ClearType is indented for LCD monitors and won't look good on any CRT. Even then, because of the way the human eye interprets colors, the anti-aliasing of ClearType may look great to one person but total garbage to another. It's very subjective.
  16. octothorpe

    C$ Windows Share

    <insert obligatory "don't mess with the registry" disclaimer here> Putting the following code into a .reg file and running it as an administrator will make those default shares go away without removing the ability to publish authorized shares: Windows Registry Editor Version 5.00...
  17. octothorpe

    Wi-Fi Food For Thought

    mattKnight: The relative security of WEP isn't relevant. Most people on this board will agree that hacking anything is wrong, no matter how weak the security is. Enabling WEP, no matter how easy it is to break, is a "keep out" sign, and nobody is going to "accidentally" hack into a WEP enabled...
  18. octothorpe

    c# 2002 v 2003

    Can't say that I've ever had trouble opening a 2002 project in 2003. There are a few differences in the underlying framework, which you can read up on at http://www.gotdotnet.com/team/changeinfo/default.aspx -- but the most noticeable changes are IDE enhancments, IMO.
  19. octothorpe

    Counting Instances of a Character in a String

    Correction: int count = foo.Length - foo.Replace( ";", "" ).Length;
  20. octothorpe

    Counting Instances of a Character in a String

    int count = foo.Length - foo.Replace( ";", "" ); That should work too, but I don't know what solution runs the fastest.

Part and Inventory Search

Back
Top