Jump to content

ODBC connection dropping out?


Justin Close
 Share

This topic is 2595 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a user who has reported issues with their ODBC connection.  They say that they have to manually relogin every so often; approximately every 10 days.  (Although the connection is only utilized once a day, so perhaps is every 10 connections?)  I have researched everything that I can find, but haven't seen anything definitive about what may be causing it.

 

This is using FMSA 12.05; client used to connect from is 'Qlikview'.

 

*  User privilege set has 'Disconnect user when idle' marked ON:  would this affect ODBC connections?  Are ODBC connections persistent or not?

 

*  User extended privilege set 'Access via ODBC' is marked ON

 

*  User extended privilege 'Require re-authentication after...10' is ON:  I know the re-authentication is supposed to be for Go only, but maybe there is a bug...

 

*  Server is configured to allow ODBC (checkbox is on)

 

 

I am not sure why the ODBC client they are using wouldn't just use the same credentials and reconnect if it were disconnected.  (Their setup creates an encrypted connection string based on what the user types in - during a setup wizard process - and then embeds that in a script.  This is what apparently is expiring, and they have to walk through the wizard process again to reset it.)

 

Any ideas on where to look for issues?

 

Thanks,

Justin

Link to comment
Share on other sites

  • 2 weeks later...

Well, I possibly have a few answers for myself. 

 

It appears that an ODBC connection stays alive as long as there is data being transmitted.  So each request is a separate connection, and only stays open as long as is needed to move the data requested.

 

Also, the authentication issues may have been caused by the external authentication server that was being used.  The PW for the account was reset; we will have to wait and see if the same kinds of errors crop up again.

 

 

--  Justin

Link to comment
Share on other sites

This topic is 2595 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By HOnza
      Everyone is excited about Lion. Even though many new features on Mac OS X 10.7 are giving us improvements we kept asking for since 10.1, Apple has again succeeded in giving all the new features the strong essence of innovation that makes us unable to hesitate to install and try Lion out as soon as we are able to.
      But we are also afraid. What if some important apps stop working?
      Read more in my article. Alredy updated with links to other resources and opinions...
    • By Buckie
      Tried adding an ODBC source using both MySQL 8.0.22 and MariaDB 3.1.10 drivers in Unicode mode and I can connect just fine, however it's impossible to add a table onto the relationships graph. It sees the table's name but when I try to add it, I get 
      This action cannot be performed because the required table is missing. error. It works fine with ANSI version of the MySQL driver, sans the ability to work with Unicode of course. I've tried multiple combinations, including making the database and the table strictly "latin", it still refuses to add the table. The test database itself is very simple, just a single table and a single field, no spaces and no unicode characters in names. Test/test/test, basically, tested with an empty FM database. The server is running MariaDB 10.4.16. Any pointers to solve that?
    • By mleiser
      I go into my FM server like I always did before. The only difference is I'm coming in through teamviewer as I'm not in the office. I get this message and just don't know what to do:
      I get the following error message. Tried to push the button to start database on the top left and it's hanging.
      The database server is not available
      admin console functionality is limited to filemaker server overview and the log viewer panes.
      to use other functionality, the server administrator must start the database server again.
    • By 34South
      I previously used ODBC Manager (32 bit)  to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP:
      dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found
      I have navigated to Actual Technologies' web site believing I should download an ODBC driver but this comes at a hefty price tag, especially when converted to my local currency. Given the increasing costs of maintenance contracts and SSL certificates I had hoped to avoid further expenditure. Do I really need this and is there an alternative?
    • By andyCodling
      Apologies if I've put this in the wrong place.
      My Filemaker solution uses a FM database and an ODBC connection to a MySql database that is used to serve data to a website.
      I have complete read/write access to the data in the MySql database from inside FM and thus control of data published on the site.
      I would like the MySql database to be able to access tables in the FM database in the same manner.
      I have set up an FM ODBC connection to our FM server and that is visible in my local ODBC Manager, have tested the connection and that is good, but I can't see any way in the MySql apps I have installed on my system to create a table in the MySql database using live FM data, in the same way that I can make a table in FM using live data from the MySql database.
      Is it possible to do this?
      My main MySQL app is SequelPro.  And occasionally MySQL workbench and associated tools.
      Thank you.
       
      Andy Codling
       
       
       
  • Who Viewed the Topic

    1 member has viewed this topic:
    madman411 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.