Windows 10: Sql connectionstring "Old Password" attribute not working on OLE DB Driver for SQL Server

Sql connectionstring "Old Password" attribute not working on OLE DB Driver for SQL Server - getting error ""We have downloaded the OLE DB diver :https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16In our connection string we added the Old Password attribute.The connection string has the following structure: 'Provider=SQLOLEDB.1;Data Source=localhost;Initial Catalog=DatabaseName; User ID=UserName;Password=password;Old Password=oldpassword'This gives the error: "Invalid connection string attribute"However, when I install the ODBC driver:

:)

 

SQL: Importing/Loadin in SQL DB using Excel

Hi All,

Not sure if this is the right place to post this.

I have an excel workbook with two sheets.

I want to continuously load data from this workbook in SQL DB.

I was successful in importing it once using SQL server import export tool.

The tool automatically created the tables and columns based on Excel's sheet and column names.

Now the data in my excel is updated (for the same columns).

My excel will have new data everyday.

How I can make sure that the new data is added in the DB , but I do not want to drop the old data?

Appreciate your suggestions.

Note: I am a novice in SQl server and just learnt about the above tool using different blogs and videos.

Thanks,

Aditya

 

MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes

• Microsoft SQL Server 2019 with DGR 2101 (KB5021125) is installed on a Windows Server 2019 computer.
  
• The SQL Server has a self-signed certificate and is configured with Force Encryption = yes.
  
• A Windows Server 2012 R2 computer has Microsoft OLEDB Driver 19 for SQL Server installed (v19.3.1.0).
  
• An application is running on this server that uses OLE DB to reach the SQL Server. The connection string is:
  

The connection fails with: "SSL Provider: The certificate chain was issued by an authority that is not trusted."

Yes, that is true, but I am specifying "TrustServerCertificate=yes;" in the connection string. It does connect OK if Force Encryption = no on the SQL Server but gives this certificate chain error if Force Encryption = yes.

Why is the driver ignoring the "TrustServerCertificate=yes" connection string parameter?

Note: On the W 2012R2 server, registry value: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SNI19.0\GeneralFlags\Flag2 = 0x1.

Thank you.

 

SQL Express 2022 Installation is failing with error code - 2068052310

Hello Team,

Prerequisite:

SQL 2019 Express is installed and working properly.

Action performed:

SQL Express 2022 Installation is failing with error code 2068052310 in my Windows 10 (22 H2) machine.

below message is from the Summary.txt which was created by SQL installer

Feature: SQL Server Replication

Status: Failed

Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.

Next Step: Use the following information to resolve the error, and then try the setup process again.

Component name: Microsoft OLE DB Driver for SQL Server

Component error code: 1706

Component log file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240529_175257\msoledbsql_Cpu64_1.log Error description: An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'. Error help link: Your request has been blocked. This could be due to several reasons.

when I searched against the error code, I found suggestions to uninstall ODBC driver 17 and retry the SQL installation.

I could not find the root cause why this issue would occur.

It would be of great help if someone please tell me if this can be detected before hand. We can mention this in readme, asking user to do a pre check and then perform the installation.

Thank you

regards,

Karthik