Submitted by randfb on 2024/02/02 10:39

It states that IQ can be accessed from an external app. Can I access IQ data from a Python script using odbc ?

How do I create the connection string ?

Is the database password protected ? encrypted ?

Can the database be opened in Access ?

Thanks

Rand

Comments

Hi ranfb,

Yes, IQ grids are visible to other apps. There are 2 methods to connect:

  1. ODC file (Grid > ODC) which works well for MS apps
  2. ODBC connection. Use Jet 4.0 as the connection string. Lots of samples online

By default grids are not visible, you must enable it in Manage Grids > Options.

Both password protection and encryption are off by default. If the IQBase is password protected, you must include it in the connection string. Encryption is done entirely at the driver level so there is nothing special to do.

Finally, yes, the IQBase can be opened by Access. It isn't recommended, but play around with a backup if you want, you'll discover what the IQ magic is all about 😯👍

Details here

Pierre_Admin
IQ Designer

How do I ?