Jump to content

Hans J. Ellingsgaard

Members
  • Content Count

    101
  • Joined

  • Last visited

Posts posted by Hans J. Ellingsgaard


  1. Have you tried to start Windows with the safe option and network options on? If it works from here, than there is most probably some services on the computer that is blocking the connection.

     

    Maybe your software will not run from the safe option, then you can use ping or telnet to check if the connection is working.


  2. If it's a dedicated db server, give it a fixed ip address outside the dhcp range, and call it with the ip address. I would not use the dns name if there's not an internal dns server on the network.

    • Like 1

  3. On 3/18/2025 at 10:42 PM, Jeff Gibson said:

     

    Deploying SQL Anywhere was SIMPLE!

     

    When it comes to simplity and small footprint, Interbase and Firebird will be a good alternative.

    • Like 1

  4. No, as far as I know, you have to download it to the phone and install it under the Encryption & credentials window.

     

    I had this problem with a client, that couldn't acces there webservice with some older handheld terminals, after they got a new DigiCert certificate. If we manually installed the certificate, some of the terminals were working again, but for the oldest version of terminals, it wasn't even possible to install the certificate, as it was not compatible with the Android version. After some research we ended up buying a certificate from GoDaddy, that was compatible with the older Android devices.


  5. Yes, Digicert is a well known provider of certificates, but I would check it anyway.

     

    When searching for errors, should work is not good enough, double check everything to make shure that it really works.

     

    Some older Android devices does not get there certificates updated, and Digicert has issued some new certificates, that's not working on older devices.

     

    You can check the certificates from here:

    Open your device's Settings app.

    Tap Security & privacy And then More security settings and then Encryption & credentials.

    Under "Credential storage":


  6. If you have multiple instanses of the server on same computer, you will need to use different ports for each instance. The first instance normally get port 3050 and the next 3051, if you not specifically choose some other ports.

     

    Can it be that you have multiple instances running and you connect to the first installed via port 3050? 


  7. 5 hours ago, Columbo said:

    When I run the program it says 'Connection established'.  The error comes when it tries to retrieve data from the table DAT2.  The error says 'no such table.'

     

    That should mean it is Ok with spaces in the path, but AFAIK SQLite is a file based db, not a RDBMS, so just to be 100% safe, I would try to place the db file in a path without spaces.


  8. On 11/30/2023 at 8:32 PM, Columbo said:

    SQLConnection1.Params.Add('D:Delphi 11 Community\My Projects\Connecting to SQLite\Data\dat2.sqlite');

    You have a connection path with spaces, are you shure the db component can handle spaces? Not all do.

×