SQLDirect is a library of components for connecting applications Delphi to SQL databases. This library is actually a lightweight database engine and a replacement for the default advanced engines Borland/CodeGear/Embarcadero Delphi v.5-10, 2010, XE-XE10 and C++Builder v.5-2010, XE-XE10. SQLDirect uses Delphi’s native interface to connect to SQL databases, and coding will be familiar to programmers. List of databases supported by this library:
- IBM DB2 Universal Database
- Informix Server
- Interbase/Firebird Server
- Microsoft SQL Server
- MySQL Server
- Oracle Database Server
- PostgreSQL Server
- SQLite Database
- Sybase Adaptive Server Enterprise and Adaptive Server Anywhere
- Unify (Centura, Gupta) SQLBase Server
- ODBC datasources
- OLEDB datasources
Features and features of SQLDirect:
- Easy installation and configuration
- Possibility of simultaneous access to supported databases
- Ability to edit query results
- Support for queries with macros
- Table component
- Multi-threaded security
- Support for BLOB fields (including LOB and BFILE for Oracle 8)
- Support for stored procedures
- Use cache to speed up retrieval and display of results
- Filtering records
- Support for data components
- InfoPower support
- And …
Below you can find required files for installing SQLBase Server on Win32 platform (Windows95/98 or Windows NT).
|Dbnt1sv.exe or Dbnt?sv.exe||SQLBase engine for Win32 (Window95, 98, NT), where ‘?’ is user license for server.|
|Start.dbs||Template database. It is necessary to create a new database.|
|Sql.ini||Configuration file for server|
|Message.sql||Message constants and description|
|Error.sql||Error number and description|
|Country.sql||Country settings for foreign languages (not default-English)|
See description of the required DLL in Sql.ini. Most frequently used 32-bit communication libraries:
It is desirable to place all files in one directory. Then you need to tune a server configuration, ie to set up server name, country (if you do not use default setting), communication protocol and other required settings.
The most important Sql.ini-sections for 1-User SQLBase Win32 database server are shown below.
; database path
These lines contain the following information. The SRV1 server is configured for TCP/IP-protocol and has database files in the C:Centura directory. Now the server has an installed TEST database.
For more detailed information about a server configuring and Sql.ini-keywords see Centura SQLBase Books (SQLBase Database Administrator’s Guide).
Use the password in the Password.txt file to install the program.
Last Updated on July 11, 2023 by admin