H05

This may not apply given I'm using MS Sql and not dbexpress but in your connection string do you need the Provider? This is mine when connecting using a "trusted connection". Where server/db need to be populated still: 'Provider=MSOLEDBSQL;Driver={ODBC Driver 17 for SQL Server};Persist Security Info=False;Server=%s;Database=%s;Integrated Security=SSPI;'

Thank you @SwiftExpat and @David Heffernan that gives me a good and focused start on getting to the root cause. I appreciate the guidance.

Fair -- to clarify I tried changing the system path order; It didn't have any effect and was changed back. And modifying SwiftExpat's advice slightly, I just tried executing the compiled exe through Windows Explorer manually and it does work with the IDE open. My current suspicion is that I need to set the current directory when using CreateProcess or something along those lines but that's a problem for tomorrow.

Beautiful, this did the trick thank you kindly @SwiftExpat @programmerdelphi2k Since you provided me unsolicited advice, allow me to do the same. In the future perhaps reading the question and answering it as opposed to making incorrect assumptions, chastising, and then providing an answer was already tried (I even said it!) would serve you better as a programmer and mentor to others.

I'm creating a tool to automate building a number of other Delphi projects and I am trying to call MSBUILD from my application. I'm running into an issue I don't get from the command line prompt directly. I have Delphi 10.4 and 11.1 installed. I'm successful from the the commandline. I call a batch file builder.bat (code below) I created with two arguments: builder "c:\Projects\Project1.dproj" "Debug" and this works to build my application using 10.4 (all the paths in the console reference C:\Program Files (x86)\Embarcadero\Studio\21.0\lib\) It fails when calling from the Delphi application I wrote where I'm capturing the console output (via CreateProcess & CaptureConsoleOutput https://stackoverflow.com/a/22326335) I've seen the comment by @corneliusdavid and I've changed the order of my path hoping that helps. However, it seems to be picking up the Delphi 11 lib folder and that isn't in my Windows Path. Anyone run in this situation? Thanks in advance! Builder.bat REM builder.bat REM =================================================== setlocal enabledelayedexpansion REM Delphi 10 Variables SET BDS=C:\Program Files (x86)\Embarcadero\Studio\21.0 SET BDSAPPDATABASEDIR=BDS SET BDSBIN=C:\Program Files (x86)\Embarcadero\Studio\21.0\bin SET BDSINCLUDE=C:\Program Files (x86)\Embarcadero\Studio\21.0\include SET BDSCOMMONDIR=C:\Users\Public\Documents\Embarcadero\Studio\21.0 SET FrameworkDir=C:\Windows\Microsoft.NET\Framework\v4.0.30319 SET FrameworkVersion=v4.5 SET PATH=%FrameworkDir%;%FrameworkSDKDir%;C:\Program Files (x86)\Embarcadero\Studio\21.0\bin;C:\Program Files (x86)\Embarcadero\Studio\21.0\bin64;C:\Program Files (x86)\Embarcadero\Studio\21.0\cmake;C:\Users\Public\Documents\Embarcadero\InterBase\redist\InterBaseXE7\IDE_spoof;%PATH% msbuild %1 /nologo /target:Build /p:config=%2 endlocal Error Log (truncated paths): Build started 2022-11-27 6:44:40 AM. Project "c:\Projects\project1.dproj" on node 1 (Build target(s)). BuildVersionResource: C:\Program Files (x86)\Embarcadero\Studio\21.0\bin\cgrc.exe -c65001 project1.vrc -foproject1.res CodeGear Resource Compiler/Binder Version 1.2.2 Copyright (c) 2008-2012 Embarcadero Technologies Inc. Microsoft (R) Windows (R) Resource Compiler Version 6.0.5724.0 Copyright (C) Microsoft Corporation. All rights reserved. Deleting file "project1.vrc". del "project1.vrc" Deleting file "project1.$manifest". del "project1.$manifest" BrccCompile: C:\Program Files (x86)\Embarcadero\Studio\21.0\bin\brcc32.exe -dmadExcept;DEBUG; -i<CUT LONG PATH> Borland Resource Compiler Version 5.40 Copyright (c) 1990, 1999 Inprise Corporation. All rights reserved. _PasCoreCompile: C:\Program Files (x86)\Embarcadero\Studio\21.0\bin\dcc32.exe -$O- -$W+ -$J+ -$C- --no-config -B -Q -TX.exe <CUT LONG PATH> -V -VN -K00400000 --description:"Project 1" -GD --drc -NBC:\Users\Public\Documents\Embarcadero\Studio\21.0\Dcp -NHC:\Users\Public\Documents\Embarcadero\Studio\21.0\hpp\Win32 -NO..\compiled -H- -W+UNSAFE_TYPE -W+UNSAFE_CODE -W +UNSAFE_CAST -$M16384,5242880 project1.dpr Embarcadero Delphi for Win32 compiler version 34.0 Copyright (c) 1983,2021 Embarcadero Technologies, Inc. project1.dpr(1): error F2048: Bad unit format: 'c:\program files (x86)\embarcadero\studio\22.0\lib\Win32\release\System.dcu' - Expected version: 34.0, Windows Unicode(x86) Found version: 35.0, Windows Unicode(x86) [c:\Projects\project1.dproj] Done Building Project "c:\Projects\project1.dproj" (Build target(s)) -- FAILED. Build FAILED. "c:\Projects\project1.dproj" (Build target) (1) -> (_PasCoreCompile target) -> project1.dpr(1): error F2048: Bad unit format: 'c:\program files (x86)\embarcadero\studio\22.0\lib\Win32\release\System.dcu' - Expected version: 34.0, Windows Unicode(x86) Found version: 35.0, Windows Unicode(x86) [c:\Projects\project1.dproj] 0 Warning(s) 1 Error(s) Time Elapsed 00:00:00.38

For what it's worth I ran several thousand queries across three variations and found all about the same performance (or at least within the tolerance that we're happy with): ADO + OLEDB; FireDAC + ODBC 18; and FireDAC + SQL Native Client 11.0 I'd like the option to replace SQL Native Client though as our clients tend to balk at installing deprecated drivers. We moved from BDE to FireDAC so we're pot committed 😕

Thanks @BruceTTTT. Found it https://quality.embarcadero.com/browse/RSP-32494 That's really too bad. Once MS undeprecated the OLEDB approach I had high hopes for FireDac performance again

@BruceTTTT Did you every figure this one out? I'm looking at testing the SQL Server OLE DB 19 driver but it's always defaulting to SQL Server Native Client 11 https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Very helpful solution - ran into this with Delphi 10.4.2 & self-compiled 1.3.18. Issue emerged after switching from a remote 4K RDP session to the local 2x1080P physical machine itself the next day. Changed the ContextHeighPercent to 95% and restarted the IDE to resolve.