Convert from OLEDB driver to ODBC or Native SQL Driver

I have an application supplied by an outside party who will no longer provide support. The application relies on configuration files to drive most of its operation. One such configuration file depicts a connection to a database. Currently, it is using (assuming) an OLEDB driver to connect to that database. This connection may no longer be used as it violates recent security patches to the OS. I want to upgrade that connection to an ODBC or SQL Server Native connection, but doing so is just over my head. I need help; well, being honest, I need an answer/solution. Below are the current connection definition parameters appearing in the XML configuration file. I need to know how to change that content for the latest ODBC or SQL Native Driver. The server is running Windows Server 2012 R2 and Microsoft SQL Server 10.0.6556.0.

<?xml version="1.0" encoding="utf-8"?> <Configuration> <Module name="LocalDB"> <Property name="Server" value="(local)\xxxxxxxx"/> <Property name="Database" value="yyyyyyyy"/> <Property name="UID" value="zzzzzzzz"/> <Property name="Password" value="********"/> <Property name="AdditionalSettings" value="Provider=MSOLEDBSQL"/> <Property name="ObjectAssemblyDescriptor" value="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <Property name="ConnectionObjectType" value="System.Data.OleDb.OleDbConnection"/> <Property name="DataAdapterObjectType" value="System.Data.OleDb.OleDbDataAdapter"/> <Property name="CommandBuilderObjectType" value="System.Data.OleDb.OleDbCommandBuilder"/> <Property name="CrystalReportDLL" value="crdb_ado.dll"/> </Module> </Configuration>

0 answers