This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have one application in C# and .NET which earlier was using SQL Server 2019, Now I made changes so that it support SQL server 2022 and ODBC driver 18 as well. I made all the required changes. So I tested it in a fresh VM where that application and ODBC 18 driver is there. After that my application is crashing. So I installed Visual Studio 2022 on the same VM and it starts working fine, but I dont want to place Visual studio on the same VM. I just want to have my application and ODBC 18 driver, can you please suggest is there any link between SQL server 2022 and Visual studio 2022, why my application is crashing. Do I need to do any modification related to visual studio.
Behavior is same in Windows 10 and Windows 11.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.
Hello,
The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS).
The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development.
Best regards,
Molly
Hello,
Thank you for posting in Microsoft Community forum.
Based on the description, I understand your question is related to SQL Server 2022, Visual Studio 2022, and ODBC drivers.
Visual Studio 2022 includes tools for working with SQL Server databases, such as SQL Server Object Explorer, SQL Server Data Tools (SSDT), and ADO.NET connectivity. ODBC Driver 18 is specifically designed for SQL Server and provides efficient data access.
Verify if your application has any dependencies on Visual Studio components, ensure that your application has the required permissions.
Consider creating a test environment where you can isolate your application, ODBC driver, and SQL Server 2022.
Test the application with only the ODBC driver and SQL Server 2022 (without Visual Studio) to see if the issue persists.
Have a nice day.
Best Regards,
Molly
If I am using SQL Server 2022,2019 and ODBC 18 driver then should I use SQL Server Native Client or not. If yes then it is optional or mandatory.
