Data Access Worldwide Forums - Database Connectivity https://support.dataaccess.com/Forums/ All things related to connecting and optimizing your DataFlex application with SQL databases. en Wed, 20 May 2026 06:43:21 GMT vBulletin 60 https://support.dataaccess.com/Forums/images/misc/rss.png Data Access Worldwide Forums - Database Connectivity https://support.dataaccess.com/Forums/ OEM to ANSI wizard cuts off long fields https://support.dataaccess.com/Forums/showthread.php?73252-OEM-to-ANSI-wizard-cuts-off-long-fields&goto=newpost Fri, 15 May 2026 13:51:33 GMT EDIT: It wasn't a limitation of the wizard: the INT file contained a restriction. So forget I asked. :-)

Hi all,
I want to migrate an SQL database from OEM to ANSI/Unicode.
For this, I am using the wizard in the Database Builder.
However, this wizard has a 16K limit. Fields containing more text are truncated at 16K.
This affects quite a large number of fields. Creating scripts to correct these text fields after running the wizard would be a pita.

I'm now figuring out if I can do this in SQL instead and this works just as well.

Any tips? ]]> Database Connectivity Pieter van Dieren https://support.dataaccess.com/Forums/showthread.php?73252-OEM-to-ANSI-wizard-cuts-off-long-fields DF26: CK Drivers LEFT JOIN ? https://support.dataaccess.com/Forums/showthread.php?73243-DF26-CK-Drivers-LEFT-JOIN&goto=newpost Wed, 13 May 2026 04:33:43 GMT HI DAW There was some talk about DF26 CK drivers being able to use LEFT JOINS to pull the entire structure of a DD at once rather than 1 statement... HI DAW

There was some talk about DF26 CK drivers being able to use LEFT JOINS to pull the entire structure of a DD at once rather than 1 statement per related table.
Just tested the execution of the Order Entry on DB2 - all statements generated are the same as DF25 ]]> Database Connectivity raveens https://support.dataaccess.com/Forums/showthread.php?73243-DF26-CK-Drivers-LEFT-JOIN <![CDATA[UPDLOCK in sql locks all tables and the database "freezes"]]> https://support.dataaccess.com/Forums/showthread.php?73219-UPDLOCK-in-sql-locks-all-tables-and-the-database-quot-freezes-quot&goto=newpost Tue, 05 May 2026 11:42:33 GMT Hi! I have a strange behaviour in my MSSQL Database. When the users are working, all of the sudden the application hangs, due to a lock in the... Hi!

I have a strange behaviour in my MSSQL Database.

When the users are working, all of the sudden the application hangs, due to a lock in the SQL table.

I have found out what query that the SQL is performing and has the datbase locked.

This one.

Code:
SELECT "RECNUM", "NR", "NAMN", "COLOR", "KORTNAMN", "ANM", "DEF", "DEL", "UTF"
, "KF", "SLUTF", "RETUR", "BOK", "ANTAL", "ANTAL_GRON", "ANTAL_GUL", "ANTAL_ROD", "SORT", "ANKOMST", "PLAN", "DATUM", "SIGN", "LAS_TAB", "KALENDER_BILD", "TYP", "DISTRBOKN"
FROM "dbo"."STATUS"
WITH
(UPDLOCK)
ORDER BY "NR" ASC
How and where should i look to figure out what causes this query, is it part of a find, a reread or what.

When i kill this session in SQL all other transactions do continue and the program is not frozen any more.

I just don't know where to start. ]]> Database Connectivity MrHalland https://support.dataaccess.com/Forums/showthread.php?73219-UPDLOCK-in-sql-locks-all-tables-and-the-database-quot-freezes-quot SQL Server Native Client version error https://support.dataaccess.com/Forums/showthread.php?73187-SQL-Server-Native-Client-version-error&goto=newpost Thu, 23 Apr 2026 22:34:46 GMT I installed SQL Server 2022 (60 days evaluation) and my DF 23 app on an empty computer with Win 11 Pro. That works. Then I made two VMware virtual... I installed SQL Server 2022 (60 days evaluation) and my DF 23 app on an empty computer with Win 11 Pro. That works. Then I made two VMware virtual machines on that computer. The purpose is to make it possible for two users to log in to that computer from outside at the same time.

After that I installed a DF 23 client on one of these VM and tried to start my DF app but got an error message saying that the minimum required version of SQL Server Native Client was not installed.

Why is it so? As far as I can remember, I have installed the same programs on the physical and virtual computers.

However, on the physical machine, there many more programs on the list. Thera are Microsoft ODBC Driver 17 and 18 for SQL Server, but they are missing in the list from the VM machine.

/Bengt
Attached Images
]]> Database Connectivity Bengt https://support.dataaccess.com/Forums/showthread.php?73187-SQL-Server-Native-Client-version-error PDF manual for Dataflex Connectivity Kit for ODBC?. https://support.dataaccess.com/Forums/showthread.php?73185-PDF-manual-for-Dataflex-Connectivity-Kit-for-ODBC&goto=newpost Thu, 23 Apr 2026 16:19:10 GMT Back in the days when Gutenberg was a lad we had manuals on paper.

I have pages 73 to 109 of "Dataflex Connectivity Kit for ODBC" version 2.2, but ideally I'd like the rest of it.

Anybody got the pdf they can send me? Any version? ]]> Database Connectivity DaveR https://support.dataaccess.com/Forums/showthread.php?73185-PDF-manual-for-Dataflex-Connectivity-Kit-for-ODBC <![CDATA[Dummty's guide to ODBC/PSQL required]]> https://support.dataaccess.com/Forums/showthread.php?73184-Dummty-s-guide-to-ODBC-PSQL-required&goto=newpost Wed, 22 Apr 2026 17:20:33 GMT Something not working the way I recall, but most likely the brain cells I'm losing on a daily basis.


According to legend (and the help) connection IDs are help in the registry.
Using both versions of ODBCAD32 on my dev machine I created system DSNs for 32 and 64 bit PSQL, pointing at the server's ip, and added them to the connections.ini, it caused production users to have issues.

PSQL doesnt need a login, so I have the following oConnection
Set pbLoginOnOpen to False
Set pbLoginDialogRequired to False



Then I create new DSNs using the same tools on the server pointing to localhost. As we don't have a studio on the server I revert to my dev machine and create the connectionID entries. Still get issues with connection not found on user machines. Deactivated the connection for now.

On a user with the Studio and the ODBC driver loaded we get 'Data Source Name not found and no default driver' identifying the correct DSN, so what's missing? The registry entries?

So, must I create DSN registry entries on 110 user machines? Can anybody point me at the Enid Blyton (ie: simple) sequence of operations? ]]> Database Connectivity DaveR https://support.dataaccess.com/Forums/showthread.php?73184-Dummty-s-guide-to-ODBC-PSQL-required MSSQL connection problem https://support.dataaccess.com/Forums/showthread.php?73180-MSSQL-connection-problem&goto=newpost Tue, 21 Apr 2026 08:11:20 GMT I need to create a test environment in my office on a P2P network where SQL server is on computer. I want to be able to log in to that database shall... I need to create a test environment in my office on a P2P network where SQL server is on computer. I want to be able to log in to that database shall be from other computers in the same local network.

I have done the following (and tested much more) :


  1. TCP/IP is enabled on the server with SQL Server Configuration Manager
  2. TCP Port is set to 1433 in SQL Server Configuration Manager
  3. The SQL Server Service is restarted in SQL Server Configuration Manager
  4. Allow remote connections to this server is checked in SSMS Server properties connections
  5. Port 1433 is opened in Windows Defender
  6. I checked that port 1433 can really is open by running Test-NetConnection computername -port 1433 in Powershell
  7. SQL Server and Windows Authentication mode was checked in SSMS
  8. I created a new Login with SQL Server authentication in SSMS to be sure of the credentials.
  9. I checked that I could login with this user and password with SSMS on the computer with the database. That worked.


But I fail logging in from the other computer in the same local network. Why? What more can I do to find out what is wrong? ]]> Database Connectivity Bengt https://support.dataaccess.com/Forums/showthread.php?73180-MSSQL-connection-problem SQL delete record https://support.dataaccess.com/Forums/showthread.php?73179-SQL-delete-record&goto=newpost Tue, 21 Apr 2026 07:35:50 GMT using the following sql statement
Code:
Send SQLExecDirect of ghoSQLExecutor ('DELETE FROM JDP7333 WHERE JDP7333.UniekID='+String(nUniekID)+" and JDP7333.Tabel='"+Trim(sTabel)+"'")
//the field "Tabel" is an ASCII field
the application at the customer site stops working (not responding). Eventualy other users get "lock time outs".

Deleting the records the old fashion way (with DF code) does the trick. But why is the SQL statement not working? The database isn't locked. Otherwise the DF-code wouldn't work either?

Transfering the SQL-DB of the customer to local and executing doesn't reproduce the problem.

Any thoughts?

Customer system:
Windows Server 2022 Standard
SQL Server 16.0
SQL server management 20.2
SMO 17.1
T-SQL Parser 17.2.3
MDS 5.1.5 ]]> Database Connectivity Sjoerd https://support.dataaccess.com/Forums/showthread.php?73179-SQL-delete-record MSSQL EXPRESS 20.X/df 20, https://support.dataaccess.com/Forums/showthread.php?73177-MSSQL-EXPRESS-20-X-df-20&goto=newpost Mon, 20 Apr 2026 22:54:28 GMT Hi all Is MSSQL EXPRESS 20.X compatible with DF 20.1? Edgar Hi all

Is MSSQL EXPRESS 20.X compatible with DF 20.1?

Edgar ]]> Database Connectivity Edgar H. Peņa C. https://support.dataaccess.com/Forums/showthread.php?73177-MSSQL-EXPRESS-20-X-df-20