Description
SQLDirect is a component library for connecting Delphi applications to SQL databases. This library is actually a lightweight database engine for Borland/CodeGear/Embarcadero Delphi v.5 – 10, 2010, XE-XE10 and C++ Builder v.5 – 2010, XE-XE10 default engines. SQLDirect uses the native Delphi interface to connect to SQL databases and will have familiar coding for the programmer. 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 Data Sources
- OLEDB Data Sources
SQLDirect Features and Functionality:
- Easy to install and configure
- Concurrent access to supported databases
- Ability to edit query results
- Support queries with macros
- Array component
- Multi-threaded security
- Support for BLOB fields (including LOB and BFILE for Oracle 8)
- Supports stored procedures
- Use the cache to speed up the reception and display of results
- Record filtering
- Data Component Support
- InfoPower support
- And …
system required
Below are the files required to install SQLBase Server on the Win32 platform (Windows95/98 or Windows NT).
File name | Description |
Dbnt1sv.exe or Dbnt? Sv.exe | SQLBase engine for Win32 (Window95, 98, NT), where ‘?’ is a user license for the server. |
Start.dbs | Model database. It is necessary to create a new database. |
Sql.ini | Configuration file for the server |
Message.sql | Message constants and description |
error.sql | Error number and description |
Country.sql | Country settings for foreign languages (not English by default) |
Communication DLLs |
See the description of the required DLL in Sql.ini. Most 32-bit communication libraries are used:
|
It is desirable to place all files in a single directory. Next, you need to have a server configuration, i.e. set the server name, country (if you are not using the default setting), communication protocol, and other required settings.
The most important Sql.ini sections for the 1-User SQLBase Win32 Database Server are shown below.
[dbnt1sv]
server_name = SRV1, sqlws32
caching = 2000
sort cache = 2000
; database path
dbdir=C:Centura
database_name = TEST, sqlws32
[dbnt1sv.dll]
comdll=sqlws32
These lines contain the following information. The SRV1 server is configured for the TCP/IP protocol and has database files in the C:Centura directory. The server now has a TEST database installed.
For more information on setting up a Sql.ini server and keywords, see Centura SQLBase Books (SQLBase Database Administrator’s Guide).
Pictures
Installation guide
Use the password in the Password.txt file to install the application.
Download link
Download SQLDirect 6.5.2 Source (Adapted to Alexandria)
Download SqlDirect_6.5.1_for_D5-XE10.2_Tokyo
File password(s): ngaur.com
Cut
70 MB