#pip3 -> python 3.9 # – Instalar com pip3 #pip3 install JayDeBeApi –user #pip3 install JPype1==0.6.3 –user import jaydebeapi #variables to connect to zimjdbc8.jar jclassname=’zim.jdbc.ZJ_Driver’ jdbc_driver_loc = r’C:\Users\xxx\Documents\p01\zimjdbc8.jar’ jdbc_driver_name = ‘zim.jdbc.ZJ_Driver’ host=’localhost:6002′ #url and login variables url=’jdbc:zim://’ + host + ‘/zimdb01’ login=”ZIM” psw=”” #sql to be executed at the Zim’s side. sql = “SELECT codie,…
Read more
Preparing the Database for ODBC Access Start up the Development Center (DC) and click Tools -> Remote Access -> Prepare Database. This action runs a script that populates the metadata entities that are used by non-Zim applications to acquire EntitySet information.
The driver provides a login dialog under one of two conditions. The login appears if the application using the driver passes it a blank user id or password the user id or password variables are not defined in the registry The User ID and Password passed to the driver from the application override those defined…
Read more
Even though per user entity sets are private and only seen by the user that created them, they can still be available to an ODBC Driver connection by means of the Dynamic Creation of a Data Source, which informs the work path that contains the per user entity sets. When the third party software connects…
Read more
Zim supports Microsoft Open Database Connectivity Drivers (ODBC, defined by Microsoft as a standard way for applications to access data stored in database files) which allows third-party tools to access a Zim database via the Zim ODBC Driver. This driver is used to access data from a Zim database that is either local to the…
Read more
Note: In Zim, constant strings can be represented either surrounded in single quotes (‘) or double quotes (“). In SQL, constant strings are surrounded by single quotes (‘) whereas identifiers are surrounded by double quotes (“). statement ::= SELECT select | INSERT insert | DELETE delete | UPDATE update | passthroughSQL passthroughSQL ::= any statement…
Read more
An ODBC Data Source to access a Zim database can be configured in two different ways: . Using the Zim ODBC Driver Setup to create a data source; . Using Zim language to dynamically create and maintain a data source tailored for specific needs like calling a third party software from within Zim. In both…
Read more
English 
Portuguese