vdocs_db.dll — Standalone MySQL/MariaDB Connector for VB6 and Win32

Standalone 32-bit DLL to connect VB6, Delphi, PowerBuilder and any Win32 app to MySQL/MariaDB. No dependencies. No ODBC. No ADO. LGPL.

vdocs_db.dll is a standalone MySQL/MariaDB connector for 32-bit Windows applications, specially designed for Visual Basic 6 (VB6), Delphi, PowerBuilder, and any Win32 language that can call standard DLL functions.

It requires no additional DLLs, no ODBC drivers, no ADO, no runtime libraries, and no COM registration. The entire MariaDB Connector/C is compiled directly inside the library.

Key Features

• Standalone — One DLL, no dependencies. Drop it next to your .exe and run.
• 32-bit native — Perfect for VB6, Delphi 7, PowerBuilder, and legacy Win32 apps.
• Simple API — PHP-style functions: connect, query, fetch, free, disconnect.
• SSL support — Auto-negotiates SSL with the server.
• UTF-8 ready — Full support for utf8mb4 characters.
• Transactions — BEGIN / COMMIT / ROLLBACK functions included.
• LGPL license — Use it in commercial, proprietary applications without opening your source code.

Technical Specifications

API Functions

Connection

• vddb_connect(host, db, user, pass, port) — Returns connection handle
• vddb_disconnect(conn) — Closes connection and frees handle
• vddb_is_connected(conn) — Returns 1 if connected, 0 if not

Queries

• vddb_query(conn, sql) — Executes SELECT — returns 1 on success
• vddb_execute(conn, sql) — Executes INSERT / UPDATE / DELETE

Navigation

• vddb_eof(conn) — Returns 1 when no more records
• vddb_next(conn) — Moves to next record
• vddb_record_count(conn) — Returns total records in result set

Fields

• vddb_field(conn, name) — Returns field value by column name
• vddb_field_index(conn, idx) — Returns field value by index (0-based)
• vddb_field_count(conn) — Returns number of columns in result

Transactions

• vddb_begin(conn) — Starts transaction (disables autocommit)
• vddb_commit(conn) — Commits transaction
• vddb_rollback(conn) — Rolls back transaction

Resources & Info

• vddb_free_result(conn) — Frees query result memory
• vddb_close(conn) — Alias for vddb_free_result
• vddb_error(conn) — Returns last error message
• vddb_affected(conn) — Returns rows affected by last UPDATE/INSERT/DELETE

VB6 Example

' Declarations (included in package)
Private Declare Function vddb_connect Lib "vdocs_db.dll" (ByVal host As String, ByVal db As String, ByVal user As String, ByVal pass As String, ByVal port As Long) As Long
Private Declare Function vddb_is_connected Lib "vdocs_db.dll" (ByVal conn As Long) As Long
Private Declare Sub vddb_query Lib "vdocs_db.dll" (ByVal conn As Long, ByVal sql As String)
Private Declare Function vddb_eof Lib "vdocs_db.dll" (ByVal conn As Long) As Long
Private Declare Sub vddb_next Lib "vdocs_db.dll" (ByVal conn As Long)
Private Declare Function vddb_field_index Lib "vdocs_db.dll" (ByVal conn As Long, ByVal idx As Long) As Long
Private Declare Sub vddb_free_result Lib "vdocs_db.dll" (ByVal conn As Long)
Private Declare Sub vddb_disconnect Lib "vdocs_db.dll" (ByVal conn As Long)
Private Declare Function vddb_error Lib "vdocs_db.dll" (ByVal conn As Long) As Long

' Usage
Dim conn As Long
conn = vddb_connect("localhost", "mydb", "root", "password", 3306)

If vddb_is_connected(conn) = 0 Then
    MsgBox "Error: " & PtrToStr(vddb_error(conn))
    Exit Sub
End If

vddb_query conn, "SELECT id, name FROM customers ORDER BY id"

Do While vddb_eof(conn) = 0
    Debug.Print PtrToStr(vddb_field_index(conn, 0)) & " - " & _
                PtrToStr(vddb_field_index(conn, 1))
    vddb_next conn
Loop

vddb_free_result conn
vddb_disconnect conn

' Note: PtrToStr helper function and full declarations included in the package.

System Requirements

• Windows XP / Vista / 7 / 8 / 10 / 11 (32-bit or 64-bit with 32-bit app support)
• MySQL 5.0 or later, MariaDB 5.5 or later
• Any development environment that can call standard DLLs (VB6, Delphi, PowerBuilder, etc.)

License

This software includes MariaDB Connector/C.
Copyright © MariaDB Corporation Ab.
Licensed under LGPL 2.1.
https://github.com/mariadb-corporation/mariadb-connector-c

What's Included

• vdocs_db.dll — the connector (32-bit, standalone)
• vdocs_db.h — C/C++ header (optional, for C/C++ developers)
• User Manual (PDF) — complete API reference with VB6 examples
• Sample VB6 Project — ready-to-run test form

Why Choose vdocs_db.dll?

Support

Pricing