bsql works but mimerpy does not

[idexxbernvaug]

Hello! I am stumped here.

I am able to connect to a remote db using bsql:

But when I try to use mimerpy, I get an error: con = mimerpy.connect( dsn='idexxcvqa', user='LABCAT_QA', password='omitted' )

Here is my sqlhosts file:

-- ============================================================================
DEFAULT:
--
-- Database
-- ----------------------------------------------------------------------------
   example_localdb
-- ============================================================================
LOCAL:
--
-- Database           Path
-- ------------------ ---------------------------------------------------------
   testdb             /usr/local/MimerSQL/testdb
-- ============================================================================
REMOTE:
--
-- Database           Node               Protocol Interface Service
-- ------------------ ------------------ -------- --------- -------------------
   idexxcvqa   omitted.domain.com    'tcp'       ''        1360
-- ============================================================================

I must be missing something... Any help is much appreciated. Thanks!

[fredrikalund]

Hi, What version of Mimer SQL are running on the server you are trying to connect to? Regards, Fredrik

[idexxbernvaug]

The Mimer version on the server is 10.0.8A

[fredrikalund]

That's the problem. MimerPy uses our new Mimer C API and it only works with Mimer SQL 11.0 and later. The error code/message could be better here.

[idexxbernvaug]

Well that explains it. Thanks for the info!