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 Delphi’s native interface to connect to SQL databases and has coding familiar to 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
Features and Functions of SQLDirect:
- Easy to install and configure
- Concurrent access to supported databases
- Ability to edit query results
- Supports queries with macros
- table components
- Multi-threaded security
- BLOB field support (including LOB and BFILE for Oracle 8)
- Supports stored procedures
- Use cache to speed up receiving and displaying results
- Filtering records
- Data component support
- InfoPower Support
- And…
required system
Below you will find the necessary files to install SQLBase Server on a Win32 platform (Windows95 / 98 or Windows NT).
The name of the file | Description |
Dbnt1sv.exe or Dbnt? Sv.exe | SQLBase Engine for Win32 (Window95, 98, NT) where ‘?’ is a server user license. |
start.dbs | Database of templates. A new database needs to be created. |
Sql.ini | Server configuration file |
message.sql | Message constants and description |
error.sql | Error number and description |
country.sql | Country settings for foreign languages (not English by default) |
Communication DLL |
See Sql.ini for a description of the required DLL. Most used 32-bit libraries:
|
It is recommended to place all files in one directory. Then you need to have a server configuration, i.e. set the server name, country (if you don’t use the default setting), communication protocol and other necessary settings.
The most important Sql.ini sections of a single-user SQLBase Win32 database server are shown below.
(dbnt1sv)
servername=SRV1, sqlws32
cache = 2000
sortbuffer = 2000
, database path
dbdir=C:Centura
dbname = TEST , sqlws32
(dbnt1sv.dll)
comdll=sqlws32
These lines contain the following information. The SRV1 server is configured for TCP/IP and has database files in the C:\Centura directory. The TEST database is now installed on the server.
For more information on configuring the server and Sql.ini keywords, see Centura SQLBase Books (SQLBase Database Administrator’s Guide).
Pictures
installation manual
Use the password in the Password.txt file to install the app.
Download link
Download SQLDirect 6.5.2 source (customized for Alexandria)
Download SqlDirect_6.5.1_for_D5-XE10.2_Tokyo
File password(s): free download software
size
70MB