list to a database using dataset with table adapters in visual studio

AZAD ARKAN 11 Reputation points
2022-08-23T13:23:40.227+00:00

234102-hata.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,980 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,008 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 112.7K Reputation points MVP
    2022-08-23T21:48:08.017+00:00

    From where did you get SQLNCLIRDA11? I suspect that there has been an accident, and that should be SQLNCL11 instead. SQLNCLI11 is an OLE DB provider for connecting to SQL Server. I've never heard of SQLNCLIIRDA11.


  2. Izhar Azati 0 Reputation points
    2023-07-18T12:59:06.0666667+00:00

    NOT ANSWER!!!

    When you create new project VS2022, Console, FW4.8.1 and define ConnectionString with setting, you get this string:

    Provider=SQLNCLIRDA11;Data Source=ABC01;Integrated Security=SSPI;Initial Catalog=XxGovx

    User's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.