Hello,
I use devart dbexpress for SQL server to connect an SQL server 2014 with Delphi Embarcadero and it works fine for years.
The SQL server is going to be upgraded to 2019 version. I try to connect the SQL server 2019 with dbexpress devart driver but I got the following message:
[DBNETLIB](ConnectionOpen (SECDoClientHandshake()).) SSL Security error.
I use the 7.4.6 devart driver version.
I've tried with the 9.0.1 trial version to be compatible with SQL server 2019 but I have the same error message. My trial version has now expired and I can't do more test on this version.
On my local machine, I've installed an SQL server 2019 for test. I successfully connect with the 7.4.6 driver on Delphi tokyo 10.2. I'm surprised because I thought this version wasn't compatible with SQL server 2019.
I don't know why it works on my computer and why it doesn't work on the server?
How the 7.4.6 can work on my computer with SQL server 2019?
What can explain the error message with 7.4.6 and 9.0.1 with "SSL security error"?
If I have to do more tests with the 9.0.1 version, how could I expand the trial version expiration period?
One of the dfference is that the error message appears between a client computer and a server computer (two different machines).
Whereas it works on my computer on which the client and the server are on the same machine.
Maybe there are some DLLs installed by the SQL server 2019 installation file or SQL Server management studio which could explain that the the 7.4.6 driver succeed to connect 2019 version.
I hope you'll be able to help me to understand and solve this problem.
Best Regards.
Search found 1 match
Search found 1 match
• Page 1 of 1
- by DamienSPIE
- Mon 17 Jan 2022 08:49
- Forum: dbExpress driver for SQL Server
- Topic: Pb SQL server 2019 connection
- Replies: 1
- Views: 12348
Search found 1 match
• Page 1 of 1
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins