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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
Portuguese 
English