Data Access Worldwide Forums - Database Connectivity

Cannot create connection DF 25

Garret Mott — Fri, 16 Oct 2026 19:18:44 GMT

DF25, SQL Express 2025

I'm trying to create a connection to it - using Windows Auth. on a customer's server. I can get to the point of choosing a DB, but none are listed. Tried typing in the DB name, but then get a "Cannot write to ini file" error.

Creating one for SQL Express 2014 creates one just fine & lists the DBs.

Is it a SQL 2025 issue? Maybe rights on SQL Server?

TIA

DF 25: cSqlExecutor SQlSetParameter issue - Delayed Expression evaluation ?

Samuel Pizarro — Wed, 14 Oct 2026 14:09:03 GMT

Parametrized query
Insert statement, passing each column value as parameters

Code:

Send SQLSetParameter of ghoSQLExecutor '?16' (Object_Label(Self)) // OriginScreen

This code is written inside a BPO
At watches window, (Object_Label(Self)) evaluates properly when breakpoint reaches this line.
SqlExecutor_ObjectLabel_01.png

But, after the insert is executed.. I get a different value inserted in the column, the name of the SQL-Executor object instead. !?

SqlExecutor_ObjectLabel_02.jpg

Attached Images

SqlExecutor_ObjectLabel_01.png (140.9 KB)
SqlExecutor_ObjectLabel_02.jpg (29.0 KB)

DFDateToSQLDate and SQLDateToDFDate missing in cSQLExecutor

Samuel Pizarro — Thu, 24 Sep 2026 13:01:20 GMT

We lost these two handful functions (from cSQLStatement) in new cSqlExecutor.

IT would be nice to have a similar thing

DF26 cSQLExecutor with SQLite ODBC returns no rows

Chris Spencer — Sun, 20 Sep 2026 21:58:02 GMT

I'm doing some initial testing with SQLite from DataFlex 26 for a possible new application.

SQLite is connected through ODBC_DRV using a 64-bit SQLite3 ODBC driver and a DataFlex Connection ID of SQLLite.

Normal DataFlex table access is working correctly. I can open the SQLite Person table, use a DataDictionary, find records and display/update them normally.

However, I can't get cSQLExecutor to return any rows.

The executor is defined as:

Code:

Use cSQLExecutor.pkg





Object oSQLExecutor is a cSQLExecutor

    Set psConnectionId to "SQLLite"

End_Object

For example:

Code:

String[][] aData





Get SQLExecDirect of oSQLExecutor "SELECT * FROM Person" to aData





Showln "Rows:" (SizeOfArray(aData))

Showln "SQL State:" (psSQLState(oSQLExecutor))

Showln "SQL Message:" (psSQLMessage(oSQLExecutor))

This returns:

Code:

Rows: 0

SQL State:

SQL Message:

I also tried a very simple query:

Code:

SELECT 123 AS TestValue

with the same result - zero rows and no SQL error/message.

As a comparison, the traditional DataFlex CLI interface against the same open Person table works correctly:

Code:

Procedure TestSQLite

    Handle hoSQLManager hdbc hstmt

    Integer iFetch

    String sLastName





    Get Create (RefClass(cSQLHandleManager)) to hoSQLManager





    Get SQLFileConnect of hoSQLManager (RefTable(Person)) to hdbc

    Get SQLOpen of hdbc to hstmt





    Send SQLExecDirect of hstmt "SELECT LastName FROM Person"





    Repeat

        Get SQLFetch of hstmt to iFetch





        If (iFetch <> 0) Begin

            Get SQLColumnValue of hstmt 1 to sLastName

            Showln "CLI row:" sLastName

        End

    Until (iFetch = 0)





    Send SQLClose of hstmt

    Send SQLDisconnect of hdbc

    Send Destroy of hoSQLManager

End_Procedure

That returns the expected Person records.

So at this point I have:

Code:

Normal DataFlex table/DD access       Working

Traditional CLI SQL access           Working

cSQLExecutor SQLExecDirect            Returns no rows

cSQLExecutor SQL error/message        None

Has anyone used cSQLExecutor successfully with SQLite via ODBC_DRV?

I'm particularly interested in whether cSQLExecutor has requirements or limitations that differ from
the traditional CLI interface when using a third-party ODBC driver, or whether there is something else required in the connection configuration.

DataFlex 26, 64-bit SQLite ODBC driver.