What version(s) of the ODBC Driver for SQL Server have you installed?
If ODBC driver 18 that would explain what you are seeing.
The DataFlex SQL Server driver that comes with DataFlex...
Type: Posts; User: Martin Moleman
What version(s) of the ODBC Driver for SQL Server have you installed?
If ODBC driver 18 that would explain what you are seeing.
The DataFlex SQL Server driver that comes with DataFlex...
Peter,
I could reproduce the issue. (Great bug report, your steps made very easy to reproduce)
It seems not new in DataFlex 24.0, I could also reproduce in DataFlex 23.0.
Will take a closer...
Samuel,
I have logged this as a feature request.
As Samuel mentions it would be better to use the MySQL ODBC Unicode driver instead of the Ansi driver.
Here is some information how to setup MySQL for Unicode. It also mentions the setting you...
I had tried that and several other things. Works correct for me.
Procedure TestDesc
Open TestDescTable
Clear TestDescTable
Find Gt TestDescTable By index.2
While...
Thanks, I still would like to see your table definition (inlude the indexes).
Also if you have a Max_Rows_Fetched setting in your table .int file.
One thing you could try is increasing the MySQL...
I tried to reproduce this with your example data, but for me this works as expected.
Table definition:
NUM FIELD NAME TYPE SIZE OFFST IX RELATES TO FILE.FIELD--- --------------- ...
Hi,
Can you tell us something about your setup:
-DataFlex version
-MySQL version
-MySQL ODBC connector version
Can you show how the INT file for this specific table looks? Also the...
You can get this error (can't load DLL DFBTRDRV), when the Windows environment variable PATH gets too long (above 2048 bytes).
In 19.1 and later this limit was raised, but with 19.0 you can still...
Adding columns or indexes with Database Builder should not be a problem.
Can you provide some more information?
-What does it mean when you say database builder crashes? Do you get any error? ...
I think the problem is, you are executing 2 different statements on the same statement handle.
Before the second SQLExecDirect you should first close and then re-open a new statement.
Procedure...
Not really an idea what causes this, but CKDaemon is hardly used anymore.
CKDaemon is only used when you use separate driver license.
If you use a DataFlex license with connectivity no separate...
I could reproduce this. We will look into it.
Thanks for reporting.
Positional parameters is missing from the docs. I logged an issue to add this.
The SQLExecutor supports positional parameters (?). The parameters must be passed as '?1' '?2' etc.
Example:
String sSQLQuery
String [][] asTheRows
Move...
Raphael,
Just to be sure, when using the new cSQLExecutor this solved your original issue?
The cSQLExecutor does auto reconnect after a lost connection, so this should work.
Thanks, glad this is working.
MySQL 5.6 seems really really old and not supported?
Anyway, I still would like to know what MySQL ODBC version you are using.
If you look in ODBC Administrator...
What MySQL version and MySQL Connector ODBC version are you using?
I just tried calling a stored procedure with MySQL ODBC Connector 8.0.33 and got a similar error.
Something seems to have...
Check if there is a mssqldrv.int file (probably in the data folder) that has the DFConnectionID defined.
Yes, the incorrect types will be fixed for the next build.
It is actually not correct. SQLColumnInfo returns:
varchar column as type SQL_CHAR (1) where is should be SQL_VARCHAR (12)
nvarchar column as type SQL_WCHAR (-8) where is should be...
I could reproduce this when calling SQLParameterInfo from OnSQLPreExecute/OnSQLPostExecute
We will look into it.
Thanks, I could reproduce.
It seems this happens when calling SQLParameterInfo from OnSQLPreExecute/OnSQLPostExecute
We will look into it.
Logged a suggestion to add this.
Yes I agree. I had already logged an issue to look for improvement.
I will add your suggestion.