Search the Community

Using Delphi 10 Seattle with dbExpress and Delphi 11 Alexandria with both dbExpress and firedac connecting to : sqlserver 2008 - 2022 I am using an ini to initialize the connections, and now I need to change it from using the native client libraries to the ODBC library. I keep getting 'unknown driver message, with the unknown driver set to whatever I set drivername to (I have tried odbc and ODBC Driver 17 for SQL Server) at one point, I didn't get a connection error anymore, but doing the first query returned an error running the first query on a view, saying the view wasn't found. Can someone please help fix? [QC2022] DriverUnit=Data.DBXOdbc DriverPackageLoader=TDBXOdbcDriverLoader,DBXOdbcDriver230.bpl DriverAssemblyLoader=Borland.Data.TDBXOdbcDriverLoader,Borland.Data.DbxOdbcDriver,Version=23.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b MetaDataPackageLoader=TDBXOdbcMetaDataCommandFactory,DbxOdbcDriver230.bpl MetaDataAssemblyLoader=Borland.Data.TDBXOdbcMetaDataCommandFactory,Borland.Data.DbxOdbcDriver,Version=23.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b GetDriverFunc=getSQLDriverMSSQL LibraryName=dbxmss.dll VendorLib=msodbcsql17.dll DriverName = ODBC Driver 17 for SQL Server MaxBlobSize=50000000 OSAuthentication=False PrepareSQL=True ErrorResourceFile= SchemaOverride=%.dbo Schema=dbo HostName=pv06 Database=qcLocal blobsize=-1 localecode=0000 isolationlevel=ReadCommitted os authentication=False prepare sql=False connecttimeout=60 mars_connection=False ConnectionString=Driver={ODBC Driver 17 for SQL Server};Server=pv06;DAtabase = qclocal;schema=dbo;Trusted_Connection=yes;

Hi, In this project I must use Delphi XE with dbExpress. I'm connecting against a SQL Server 20xx.... There's a customer requesting a TLS 1.2 only setup. Using sslscan I get this result: SSL/TLS Protocols: SSLv2 disabled SSLv3 disabled TLSv1.0 disabled TLSv1.1 disabled TLSv1.2 enabled TLSv1.3 disabled With this setting I'm unable to connect my sample project ( TSQLConnection only ). When activating the connection an error is raised (attached image) When reactivating the other verions : SSL/TLS Protocols: SSLv2 disabled SSLv3 disabled TLSv1.0 enabled TLSv1.1 enabled TLSv1.2 enabled TLSv1.3 disabled Everything works fine. I'm searching the web, but the only two parameters I found out, are not working with the XE version of dbExpress. I wondering if there's any way to connect to SQL Server via TLS1.2 only setup. (https://stackoverflow.com/questions/65050540/tls-1-2-sql-server-and-delphi-client) Are there any other parameters I can try? Tia, Clément

Test case information To reproduce the error specific data and specific, a bit complex, nested clientdataset layout is needed. The test is just opening master clientdataset and walking through all its records including nested datasets. Result is written to memo box. To run it click on button Open ClientDataSet. Button Run All Tests for Case ID runs repeated test for all option combinations . Output is saved in app's folder. Each dataset in its own .txt file. The name of the file includes chosen params. For one set of data there is problem retreiving data from database into ClientDataSet component (Case 1 and Case 2). Either there is error on dataset open method and the other has one empty nested dataset where it should be one record present (cdsP40 dataset). Calculated field is added on cdsP47 that is way down the nested hierarchy. This is the only calculated field in the project. It is created at run-time if settings Case Calculated Field Kind requires it. There is no OnCalculated event and calculated field isn't used anywhere. Just defined. Case 1 - missing data record (empty cdsP40 dataset) ID 7367 Fetch on demand PacketRecord = 50 Case 2 - "no current record" ID 7367 fkInternalCalc Fetch All PacketRecord -1 Case 3 - all OK ID 7367 No calculated fields / fkCalculated Fetch All PacketRecord -1 Case 4 - all OK ID 7334 There is a demo application with small mssql database attached. DataSetProviderDemo.zip

Hello, Can we use DBExpress on Linux platform? I am getting "E2202 Required package 'dbexpress' not found" error when I set target to linux. There are some .dcp files for other platforms such as win32, win64, osx32 and even for android and ios but I can't find any linux related file :) Also there is a file named bpldbexpress260.so in binlinux64 folder, so it must have been compiled before the ISO file released. Could some files be missing in Delphi 10.3? Can you suggest any solution? PS: I already checked all three December 2018 patches for Delphi 10.3 Rio @Marco Cantu