Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Technical Information

  • Delphi-Version
    Delphi 10.4 Sydney
  1. Damon

    External table not in the expected format

    This is the program you were helping me with before. I have the paradox tables on the target that are the same as the dev computer. Charset is same. I am using the MS standard odbc that comes with windows. This works on my dev computer both with firedac and ado connections, but both fail on the target. No BDE on target. The odbc is configured on both computers the same. MySQL is installed on both, but part works fine. It is the paradox file connection that is the problem. Sample data files here: https://degei.com/D5/D4to5MigrationTool/Degei4.zip Messagedlg('Load data process. Starting data migration...',mtinformation,[mbok],0); adoconnection1.Connected := true; //START TABLE PROCESSING... showmessage('Connection is done. Start query.'); countlabel.Caption := 'Working on ACTIVITY.DB table.'; countlabel.Update; adoquery1.SQL.Text := 'select count(*) from activity.db'; adoquery1.open; //---------------------------OPEN QUERY FAILS WITH "external table not in expected format" error. IT DOES THE SAME IF I USE FIREDAC CONNECTION. The connections works, so the odbc config is working. adoquery1.Active := true; showmessage('query active with '+inttostr(adoquery1.fields[0].asinteger)+' records'); progressbar1.Min := 1; if adoquery1.fields[0].asinteger > 0 then progressbar1.Max := adoquery1.fields[0].asinteger;
  2. I have used both firedac and ado connections to connect to old paradox files to read the data and process to a mysql server. I have gotten this working fin on my development machine. When installing and running on a test machine i get the error: external table is not in the expected format. This happens with both connection types and I cannot figure out what is missing for different from the text machines. Any suggestions?
  3. Damon

    Firedac connection to paradox via odbc

    I started from scratch with the FDconnection and finally got it to work i think. Thanks for sticking with me. There are some architecture errors when using FDTable, but not with FDQuery so i will just use that. The FireDAC seems very picky with these old paradox tables. But thanks again for all your help! Now i can start writing the import to MySql.
  4. Damon

    Firedac connection to paradox via odbc

    Still unsuccessful at this. I have tried both versions of the microsoft driver that are on windows with no luck. Every time the connection establishes fine, the FDTable will read the odbc and find all of the tables in the folder. Once I try to set the FDTable to active i get the error. The driver will not read the data. This is a FIREDAC config (my fault) or operational problem - as I can use the same ODBC that I created and it works just fine in Crystal reports as shown in the screen shots. I am completely baffled. Same error (11265) when trying to activate an FDQuery also. Damon
  5. Damon

    Firedac connection to paradox via odbc

    @emailx45 where does the connectionname property come from on the firedac connection? Is that the ODBC connection name? I'm working through your example, thank you. I notice that my app gives a different error at run time. When connecting the firedac connection it gives data source name not found and no default driver specified, but AT design time it says it is connected fine???
  6. Damon

    Firedac connection to paradox via odbc

    ================================ Connection definition parameters ================================ Database=C:\Degei4\Data ODBCDriver={Microsoft Paradox Driver (*.db )} DataSource=degei4migration DriverID=ODBC ================================ FireDAC info ================================ Tool = RAD Studio 10.4 FireDAC = 27.0.0 (Build 99682) Platform = Windows 32 bit Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR ================================ Client info ================================ Loading driver ODBC ... Loading odbc32.dll driver manager Creating ODBC environment handle Driver Manager version = 03.81.19041.0000 ================================ Session info ================================ Current catalog = Current schema = Driver name = odbcjt32.dll Driver version = 10.00.19041 Driver conformance = 3 DBMS name = PARADOX DBMS version = 05.00.0000 Master.DB Master.MB Master.PX Master.VAL
  7. Damon

    Firedac connection to paradox via odbc

    Thank you but it really does not address the question. The odbc works, just not in delphi, or not in firedac. There must be an alternate way or fix for the connection. The odbc connection works for Crystal reports, it works for excel... surely there is a way to make it work in delphi. Installing the BDE is not an option. You "bridge" suggestion says it requires SQLLite.
  8. I have followed this instruction: https://blogs.embarcadero.com/firedac-odbc-for-paradox-and-dbase-tables/ But it does not work. When trying to make the TFDTable active the error occurs: [FireDAC][Phys][ODBC][Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11265).. If it matters, I am writing a program to convert my old Delphi 5 BDE Paradox tables to MySQL as part of an application upgrade. I know this is a Delphi FireDAC problem, because the ODBC that was created to connect to the Paradox files works just fine with Crystal Reports. Anyone have any solutions?
  9. Yes, i did try with the binaries, but it did not work. I will try the stand alone installer, thank you for this.
  10. Anyone else seen this behavior? It is a recent problem. The print button is clicked but the dialog never appears. pdf still loads fine, but cannot print unless you save to file first. Troublesome. webbrowser1.Navigate('yourfile.pdf'); Also, Does anyone have the new TEdgeBrowser working? I have applied the git package and got the webview2.dll in the output folder with the exe and navigate fails. I cannot load any page. Edge version is Version 87.0.664.52 (Official build) (64-bit)
  11. Damon

    Setting Scroll Bar Width problem

    I have several tablets for time entry for staff with the issue of too small of scroll bars in my Delphi app. They are really only used for this app, so i simply set the values in the registry for the scroll bars to make them FAT. https://www.tenforums.com/tutorials/79875-change-size-scroll-bars-windows-10-a.html Works fine, but yes, changes for the entire system.