Search:

Type: Posts; User: ober0330

Page 1 of 13 1 2 3 4

Search: Search took 0.34 seconds.

  1. Replies
    3
    Views
    440

    Re: [RESOLVED] Update result value?

    Well considering that I refuse to force my users to use IE and I wouldn't dream of using .NET, I'm fine with pulling that info out of a LDAP table based on the login that they use.

    Plus, you're...
  2. Replies
    3
    Views
    440

    Re: Update result value?

    Nevermind, I got the result. There is a 'mssql_rows_affected' function that returns the number of rows affected by the last result.

    :wave:
  3. Replies
    3
    Views
    440

    [RESOLVED] Update result value?

    I have a bunch of data where I'm allowing people to mass-modify records.

    Example:
    Contract A - active
    Contract B - active
    Contract C - not active

    The 'active' field is a select box and they...
  4. Re: [RESOLVED] some tables not allowing update/insert

    The crazy thing is that the functionality provided by the trigger is both inefficient and bad design. So add bad design on top of a flawed method of getting work done and you create a nightmare.
    ...
  5. Re: some tables not allowing update/insert

    I wasted a ton of time on this yesterday.. should have come here first. It was the trigger. Thank you all!
  6. Re: some tables not allowing update/insert

    Oh wait, you meant trigger... not SP. Looking at the one trigger now.
  7. Re: some tables not allowing update/insert

    Hmm... didn't think of that. There are 43 stored procedures in the DB... any way to query those without looking through all 43??
  8. Re: some tables not allowing update/insert

    And if it helps, I'm using a global sa role in my connection string.
  9. Re: some tables not allowing update/insert

    SQL statement: UPDATE DTPROJECTTRACKING SET Time_Unit = 1 WHERE CONTRACT_ID = '08132'

    Here is the table:

    CREATE TABLE [dbo].[DTPROJECTTRACKING] (
    [Contract_ID] [nchar] (32) COLLATE...
  10. [RESOLVED] some tables not allowing update/insert

    So I have MSSQL Version 8 (I think that's 2003). This database is used with an old .NET application that I'm currently rewriting in PHP. Most of that is irrelevant, however.

    I use one user to do...
  11. Replies
    4
    Views
    672

    Re: Simple layout class

    Ugh... I can't see how anyone would willing code in this crap. Why do I need all these files and project crap? I just want a basic connection to a database and some simple class support. WHERE'S...
  12. Replies
    4
    Views
    672

    Re: Simple layout class

    anybody?
  13. Replies
    4
    Views
    672

    Simple layout class

    Alright, I'll give you a little background. I'm a PHP Developer being forced into an ASP.NET world... all I want to do is create a simple OOP approach to layout (header/footer/session management...
  14. Re: VBA Open Form when Excel Workbook opened

    Actually, I found somewhere else how to add a function to a module and then create a custom button to run that. :)

    Thanks.
  15. VBA Open Form when Excel Workbook opened [Resolved]

    Anyone know how to trigger a form/macro to automatically load when you open an Excel sheet?

    I hate VBA... but it's all I have ATM.
  16. Thread: Stupid Access

    by ober0330
    Replies
    8
    Views
    605

    Re: Stupid Access

    Speakin to the choir, friend, speakin to the choir ;)
  17. Thread: Stupid Access

    by ober0330
    Replies
    8
    Views
    605

    Re: Stupid Access

    I already have the database created. But there was a table that I missed when I ran the DTS. I just want the CREATE TABLE SQL from Access for that table. And if nothing else, just for my own...
  18. Thread: Stupid Access

    by ober0330
    Replies
    8
    Views
    605

    Stupid Access

    Running Access 2K3 and moving a database to MSDE. All I need to do is get the CREATE TABLE statement out of Access for a table. I don't want to transfer the data, just the structure.

    Can someone...
  19. Replies
    3
    Views
    660

    Re: Run procedure at specific time

    Ok... but every minute after 7AM, that's going to run. How do I only get it to run once? I'd have to set it so that if it's 7:00 and not worry about the seconds.
  20. Replies
    3
    Views
    660

    Run procedure at specific time

    I have an application that runs 24/7 and there is a procedure in that project that can be run by the press of a button. However, it needs to be pushed at 7AM every morning and I want to automate...
  21. Replies
    47
    Views
    2,201

    Re: [RESOLVED] MSDE same as using MDB?

    I guess I'm just trying to avoid a beefy process in the background along with having IT come out and take care of all the updates.
  22. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    And I think that's why I'll be using MSDE. I'm not going to create the hassle that would be involved with installing SSX.

    I really do appreciate all the input though (from both of you), it's been...
  23. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    True. And that's probably all correct. It's just that the PCs I'm setting up are in a very tight/controlled environment and they run very expensive test software and I'd like to keep the...
  24. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    What if I don't need all the new functionality? I just need a very simple data storage tool that isn't Access.

    *sigh*... I just hate the idea of installing all that upgrade stuff on the PCs I'll...
  25. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Then why are they 2 different products? Seems kind of ridiculous.

    Besides, why should I install SQL Server Express when it requires .NET 2, MSXML6 and XP SP2 to even function? MSDE works...
  26. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    So let me get this straight:

    With that method, all I have to do is create the MDF file in SQL Server express and then include the MDF in the install of my VB app? And I have full functionality to...
  27. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Ok, I rebooted and it's all up and functional now. Nevermind. Thanks for the help!
  28. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    ***... Ok, I downloaded it, put the batch file in the folder, changed the locations, and it ran like it installed it. The files were created and I have the master database, etc. When I try to...
  29. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    OK, new question... how do I use Enterprise Manager to connect to a MSDE instance? Do I register a new server???
  30. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Ok, nevermind... I found it and I'm installing right now. Thanks for your help... it's been invaluable!
  31. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Ok... and I guess the MSDE executable is something I can download from microsoft.com?

    And I don't need stored procedures... I just need a few tables that I can grab data from, update, and insert...
  32. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Hmm... and you can use that database just like you were running it off of the full SQL Server (queries of all types?).

    What setup.exe file are you talking about? And I have the Enterprise...
  33. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Unless you're referring to the "Linked Servers" thread, I don't see what you're getting at.

    Besides, I plan to do the update of the global server through VB, since I don't really have control...
  34. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    OK.... I will in a bit. S*** just hit the fan here.
  35. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Yes, that's correct. Can you point me to where you made these comments?
  36. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    The project is 90% done, but I'm doing some database re-write and upgrade from Access to MSDE. I downloaded and installed SQL Server Express yesterday and I'm about to test the connection to the...
  37. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Thanks for the input. I assume connecting to and dealing with Express is the same as Enterprise?

    EDIT: And I changed my location :p
  38. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Sup sal? :)

    Well, I guess the thing is that I don't want to have a server running in the background all the time, unless you can tell me how to start and stop it. I just want a database that I...
  39. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Anyone?
  40. Replies
    47
    Views
    2,201

    Re: MSDE same as using MDB?

    Well, the problem is that the software running locally will often be running without a connection to the global server, hence the need for the local version. It's not a question of global vs. local,...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width