Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 3.38 seconds.

  1. Re: Security Question: MS SQL direct access using windows authentication

    When I first migrated my clients to the PC world, I used VB6 and MS SQL. For security all database interaction was through stored procedures and users were only granted EXECUTE permission on those...
  2. Replies
    53
    Views
    868

    Re: Unable to Access MySQL Remotely

    @optionbase1 - I was not trying to educate you on best practice and did not have the time to read all the posts and replies in detail. I apologize if I came off that way!

    My post was to David...
  3. Replies
    53
    Views
    868

    Re: Unable to Access MySQL Remotely

    @optionbase1 - then it's VPN tunnel time - open DB ports are not cool, imo
  4. Replies
    53
    Views
    868

    Re: Unable to Access MySQL Remotely

    @dday - opening a database port on a public server is risky. Can you at least set your filewall to only allow your home IP address in? I am assuming you have a static home IP address, of course.
    ...
  5. Re: Security Question: MS SQL direct access using windows authentication

    I have written enterprise applications for decades and putting "user" info into a WHERE clause is common. Sometimes it's user roles info so I can filter rows. Fiscal Years, Departments - whatever....
  6. Replies
    39
    Views
    1,349

    Re: [RESOLVED] Decent javascript IDE

    I use VS 2019 to manage my whole web project - I can set break points in the back end VB.Net code as needed. And I run the app in FireFox and am so familiar with the debug tool in FireFox that I...
  7. Replies
    4
    Views
    254

    Re: sql bacpac creation

    This link has a link to a codeplex site with sample code for doing what you want, I believe.

    ...
  8. Replies
    4
    Views
    254

    Re: sql bacpac creation

    Are you saying you want to run a SQL BACKUP to create a .BAK files from an existing database?

    "Backup Database DBName to Disk='C:\SQLBackup\DBName.bak"

    Drive and folder need to be "local" to...
  9. Replies
    39
    Views
    1,349

    Re: [RESOLVED] Decent javascript IDE

    I have a different opinion of form designers, fwiw...

    When I started with VB6 in 2001-ish, I realized that building forms was stupid. I hired three programmers and the "senior" one was building...
  10. Replies
    39
    Views
    1,349

    Re: [RESOLVED] Decent javascript IDE

    @tg - TLDR - oh well - I had fun anyway!

    Drag and drop IDE for form building is weak, imo - as was noted by others above...
  11. Replies
    39
    Views
    1,349

    Re: [RESOLVED] Decent javascript IDE

    Why are we whining about drag and drop. Drag and drop was solved by jQuery a decade ago. I can only imagine the newer libraries do it even better.

    I've completely migrated a huge enterprise-wide...
  12. Re: Security Question: MS SQL direct access using windows authentication

    I would make VIEW's that contain the security in the WHERE clauses and then grant rights to those VIEW's - maybe even through schemas
  13. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    ...permits this segue!

    Party crashers at the pool party just barged in!

    Let's see how long you can keep that one afloat!
  14. Replies
    4
    Views
    322

    Re: New to Word Mail Merge

    I was hoping to make the Word Doc look something like the following:



    That {token} would be what I was hoping you embedded in the Word doc and the query would just auto-connect the NameField...
  15. Replies
    4
    Views
    322

    New to Word Mail Merge

    I want to take a Word document that a client gave me and produce letters through a mail merge with a SQL query.

    Is there a way to specify a field name in the body of the word document as a "free...
  16. Re: My AV protection doesn't like reading USB business card

    USB "sticks" are NOT allowed on a properly run network these days. Sorry - the person would submitted the resume has to come up with a way to deliver it safely.
  17. Re: sql to join two records in 2 different tabve

    I always use UNION ALL. UNION will remove non-distinct rows from the final result set.
  18. Thread: image vb.net

    by szlamany
    Replies
    4
    Views
    279

    Poll: VS 2015 Re: image vb.net

    I find it interesting that the first post from someone named noPOLLion happens to be a poll, lol!
  19. Replies
    11
    Views
    701

    Re: Server Side Storage

    I am not using ASP.NET Core - I'm just using VS 2019 against IIS with .Net 3.5 (I'm using old SDK's for things like OpenXML).

    I have a Global.asax file that VS gave me that has all kinds of SUB's...
  20. Re: How can i return json without decimal points

    That data with decimal points can be "quoted" like the string values are. It is expecting an integer value for those unquoted numeric values.

    How do you control the "quoting" of some fields over...
  21. Replies
    11
    Views
    701

    Re: Server Side Storage

    There are several methods on the server to hold data - I use the APPLICATION pool mostly. Since I need that pool to persist data, I trap the APPLICATION end event and "write" that pool to a text...
  22. Re: Any troubleshooting ideas to solve CR causing VS crash?

    I know dymo had a huge issue a few weeks ago with some driver problems with Windows 10. If dymo was involved I was going to ask you to google your errors with "dymo" added...
  23. Re: Any troubleshooting ideas to solve CR causing VS crash?

    Are you going to a dymo label printer?
  24. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    From what I can see he has only been needling you so far. Has that been a pattern of his?
  25. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    Wonder how long you both can keep this thread going?
  26. Re: Allow users to build WHERE clauses

    I am going to mark this thread resolved - lots of good ideas where given.

    I've just finished all the basic plumbing and handshakes back and forth - utilized my "web-site local grid" filtering to...
  27. Re: Allow users to build WHERE clauses

    Wow - thanks to @GaryMazzone, I now know that sp_executeSQL can handle "parameters" in the string variable - very nice!
  28. Re: Allow users to build WHERE clauses

    This needs further investigation - thank you very much.
  29. Re: Allow users to build WHERE clauses

    That is kind of my exact situation.

    How do you pass a random bunch of parameters to the SPROC?

    Or do you just allow a series of SPROC params to be used - like @SelectCol1, @SelectValue1,...
  30. Re: Allow users to build WHERE clauses

    I could offer this as an immediate soluion - novice users would fail quickly.

    I was headed in this direction - select the column, then enter the values. Currently when I do the client-side...
  31. [RESOLVED] Allow users to build WHERE clauses

    I need to allow users to build a WHERE clause.

    Basically I am in a STORED PROCEDURE that allows any table to be selected from - by specifying the table name in a parameter to the SPROC. The SPROC...
  32. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    It was free sheet music, so I didn't care about the typo! FDL!
  33. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    Part 3
  34. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    Part 2
  35. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    Interesting
  36. VS 2019 Re: Anything better than AsyncFileUpload or AjaxFileUpload

    I used IFRAME's in the past to do uploads that did not refresh the page. This method started failing in Chrome. I recently enhanced it to do an AJAX POST with FormData() to do the upload.

    JS...
  37. Replies
    50
    Views
    6,633

    Re: Can't Find SQL Server-REVIVED

    As for #1...

    If you are on a remote machine and you are trying to connect to an instance on some server and it's failing...

    And you are trying this connection with SSMS.

    Then you must, just...
  38. Replies
    16
    Views
    862

    Re: Single Room Air Conditioner

    Portable units MUST have two hoses. Those with one hose are bad performers, as ALL the heated air SENT out that single exhaust hose must get pulled back into the house - and that comes in any drafty...
  39. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    Here is one of those rare math jokes - and it's visual as well, lol!
  40. Thread: Post Race!

    by szlamany
    Replies
    65,329
    Views
    7,573,208

    Re: Post Race!

    All business in the front, party in the back!
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width