Search:

Type: Posts; User: Axcontrols2

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: TCP Provider: The specified network name is no longer available

    Hope you guys don't mind me resurrecting this.
    Turns out it's that user's location. Something on that user's network seems to be dropping the connection.
    Yesterday I travelled to that location and...
  2. Re: TCP Provider: The specified network name is no longer available

    Sorry to pop this back to the top. But I just have more information from the people at the site where SQL Server is located.

    They recently upgraded all the network and telephone system on their...
  3. Re: TCP Provider: The specified network name is no longer available

    The user keys some data into a form and clicks a Save button. The error is thrown instantly. The code is pretty quick. So I don't think it could be a timeout.


    My problem is that I can't...
  4. Re: TCP Provider: The specified network name is no longer available

    The computer can run the application and do any other reads and writes without error. But if it runs that one task that updates the 3 tables inside a transaction it crashes.

    As a test I started a...
  5. TCP Provider: The specified network name is no longer available

    I have around 250 users running this app daily for many years. Never had this problem before.

    It now ONLY affects ONE user. So I'm (reasonably (slightly?)) confident that it's not an actual bug in...
  6. Re: How can my windows program reinstall itself when there's a new version?

    I have a client application. It's in two separate executables.

    1. Launcher.exe
    2. MainApp.exe

    The desktop icon that the user uses to start the program starts Launcher.exe

    Launcher.exe...
  7. Replies
    0
    Views
    258

    SQLClient Connection Pooling

    This is a strange one.

    System has been running fine for many years.

    Broadband connection at the server site was upgraded recently and since then remote sites (c# application) occasionally have...
  8. Replies
    9
    Views
    1,416

    Re: Taking the number from a string

    If you're stuck using JET then even if there was a way to strip or ignore the currency symbol I kind of suspect that JET would still do a string compare and you wouldn't get the results you want.
    ...
  9. Replies
    9
    Views
    1,416

    Re: Taking the number from a string

    I like that - I'll use it. Thanks. Works fine on MS SQL Server - but the original question mentioned "Access". I couldn't get the REPLACE syntax working on JET/OLEDB
  10. Re: SSMS - Allow remote connections to this server

    No. New installation in a new installation of Windows 10 in a new VM

    Are you then saying that, as far as you're concerned, the default is still 'UnChecked' (Remote connections are not allowed)?
  11. SSMS - Allow remote connections to this server

    After installing an instance of SQL Server Express I always went into SSMS and checked the box to allow remote connections to this server. The default was always UnChecked so I needed to go in and...
  12. Re: Using Jet.OLEDB.4.0; to read a CSV file. Problems with commas and double-quotes

    I think I'm going to mark this as resolved.

    I just did a quick test with Microsoft.VisualBasic.FileIO.TextFieldParser and it has no problem with the sample CSV I posted above.

    So I'm doing that...
  13. Replies
    12
    Views
    1,354

    Re: Rename multiple files in one directory

    I can't think of a single command that would do what you want.

    But it's trivial to read the directory (all the file names in the directory) into an array using the GetFiles() function
    ...
  14. Re: Using Jet.OLEDB.4.0; to read a CSV file. Problems with commas and double-quotes

    Thanks Chris.

    Your solution is reading the text file in to a string and parse it in code and insert the data into a grid.

    But I'm not doing that. I'm using OLEDB/JET. Using an OLEDB connection...
  15. Using Jet.OLEDB.4.0; to read a CSV file. Problems with commas and double-quotes

    I've been using JET to read CSV files for many years and never had a problem. But today I get one that contains commas AND double-quotes as part of the data. So, here's an example:-
    ...
  16. Re: Is there a Collection for ContextMenuStrips?

    That does it. Thank you very much.
  17. [RESOLVED] Is there a Collection for ContextMenuStrips?

    When a form loads I can iterate through the controls in a for each loop looking for specific types. But this never includes ContextMenuStrips.

    If, for example, I wanted to change the font used by...
  18. Replies
    5
    Views
    9,520

    Re: Strange behavior on Wine/Linux

    I have quite a large database application that currently only intended for MS Windows. I was just curious about how much work would be needed to make it work in Wine on Linux.
    I was surprised to...
  19. Replies
    5
    Views
    9,520

    Re: Strange behavior on Wine/Linux

    What I'm saying is that double.TryParse("", out d) (empty string) should return false. So that next line should never execute.

    On Windows the tryparse correctly returns false. But running that...
  20. Replies
    5
    Views
    9,520

    Re: Strange behavior on Wine/Linux

    Exactly. I agree. It "Must" always have a value. That's the reason for my question.

    Did you look at my code? Look at the line if (d.ToString() == "") That MessageBox should never show because d...
  21. Replies
    5
    Views
    9,520

    Strange behavior on Wine/Linux

    double d = 0;
    string s = ""; // Empty string

    if (double.TryParse(s, out d) == true)
    {
    if (d.ToString() == "")
    {
    MessageBox.Show("Is Empty String");
    }
    }
  22. Replies
    9
    Views
    1,651

    Re: Confusing behavior with dates (SQL Svr)

    And here I'm just using sql server management studio to issue a query.

    You can clearly see the query '>2018-12-06'

    and you can clearly see that the results includes records from July !!
    ...
  23. Replies
    9
    Views
    1,651

    Re: Confusing behavior with dates (SQL Svr)

    I deleted this post because I think the one below does a better job of explaining it.
  24. Replies
    9
    Views
    1,651

    Re: Confusing behavior with dates (SQL Svr)

    OK. This is what I've found.

    In SQL Server Management studio right click a server instance and select "Properties" and go to the "Advanced" Tab. You'll see the default language is "English".
    ...
  25. Replies
    9
    Views
    1,651

    Re: Confusing behavior with dates (SQL Svr)

    I'm not on-site anymore so don't have access to their actual server.

    But I'm setting up a VM with the same versions just so I can see if I can reproduce the problem.
  26. Replies
    9
    Views
    1,651

    Re: Confusing behavior with dates (SQL Svr)

    In the actual application the date is datetime variable and there's a function that converts that to a string in the 'YYYY-MM-DD' format. It's been running for around 10 years 24/7/365

    When the...
  27. Replies
    9
    Views
    1,651

    Confusing behavior with dates (SQL Svr)

    I'm in the UK and to avoid any date confusion I use command.parameters to build my sql queries.

    But I've 'inherited' a few legacy apps that use this syntax


    SELECT * FROM SomeTable WHERE...
  28. Replies
    12
    Views
    2,546

    Re: Alternative to OUTER JOIN (SELECT....

    I've never used a Sub Query in the column list before. Looks weird.

    But. That works. Thank you. :)

    It's an Inventory program and many years ago each inventory item had a 'Option' field which...
  29. Replies
    12
    Views
    2,546

    Re: Alternative to OUTER JOIN (SELECT....

    @FunkyDexter. First let me thank you for your input. Really appreciated.


    The 'Armada' device I'm referring to is a Western Digital 'MyCloud' storage device which has MySQL 5.1 built in. It has...
  30. Replies
    12
    Views
    2,546

    Re: Alternative to OUTER JOIN (SELECT....

    Tested that. It does work on most 'sensible' servers but on a low powered Armada device the ExecuteReader() fails with an error indicating that the /tmp/ folder isn't big enough.

    I can increase...
  31. Replies
    12
    Views
    2,546

    Re: Alternative to OUTER JOIN (SELECT....

    Sorry. You're right. I just keyed in that 'example' query without double checking. It should have been "ON" not "WHERE". Something like:

    SELECT col_a, col_b, col_c, b_id FROM TABLE_A
    LEFT OUTER...
  32. Replies
    137
    Views
    17,323

    Re: LET MS know you are using VB6

    Before VB6 I programmed mostly in C

    When VB5/6 came along it was great - In VB6 I could knock out new apps so quick I was sneaking off home an lunch time. :)

    I resisted the change to .NET for...
  33. Replies
    12
    Views
    2,546

    Re: Alternative to OUTER JOIN (SELECT....

    CREATE TEMPORARY TABLE B SELECT DISTINCT b_id FROM TABLE_B;
    SELECT col_a, col_b, col_c, b_id FROM TABLE_A
    LEFT OUTER JOIN B ON B.b_id = TABLE_A.id


    I tried that - thought it would work. But no....
  34. Replies
    12
    Views
    2,546

    Alternative to OUTER JOIN (SELECT....

    I use "OUTER JOIN" because I want all rows from TABLE_A even if no matching row in B exists.
    I use "JOIN ( SELECT DISTINCT" because I only want one row from B if more than one exists.



    ...
  35. Replies
    15
    Views
    3,108

    Re: MySQL. Get records affected by UPDATE

    Thanks for the posts guys. I've been away so didn't respond earlier. Sorry. But I really do appreciate your comments/suggestions.

    If I have read a unique Key then of course I know whether to...
  36. Replies
    15
    Views
    3,108

    Re: MySQL. Get records affected by UPDATE

    Ha! Made my day! :)
  37. Replies
    15
    Views
    3,108

    Re: MySQL. Get records affected by UPDATE

    @FunkyDexter

    I'm interested in what you said about disk hit being a bottle neck. This application was originally written (by me) back in the days of ISDN before broadband. So trips to the server...
  38. Replies
    15
    Views
    3,108

    Re: MySQL. Get records affected by UPDATE

    Thanks guys.

    Sorry. I neglected to say that the application can connect to JET, Microsoft SQL Server or MySQL. I try to write db agnostic code. Obviously different connectors but as far as...
  39. Replies
    15
    Views
    3,108

    MySQL. Get records affected by UPDATE

    Ha! When you read that title you came here to tell me to use the return value of ExecuteNonQuery. Well, that's what I have been using for years. But, it seems, we can't trust it anymore.

    For years...
  40. Re: "Save", "OK", "Make it so" still relevant today?

    In the current version of my software, the user must click the 'Save' button when he's done. If he tries closing without saving then a popup appears asking if he really wants to exit without saving....
Results 1 to 40 of 56
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width