Additional SQL Server features and topics not covered by specific categories
Hi,
I'm new to ado
Are you sure that you speak about ADO and not ADO.Net?
ADO is a short for "ActiveX Data Objects". It is very old database provider which is usually used in C, C++ and Visual Basic for example and not recommended for .Net applications.
ODBC is not a specific driver name but a type of drivers. There is an ODBC driver for most data sources (different driver for different databases). For SQL Server you can use the "Microsoft ODBC Driver for SQL Server"
For most case, I would not recommend ether of these and you should use the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) which is Microsoft recommendation.
In this case, check the following link to get the option of the connection strings which you can use:
https://www.connectionstrings.com/ole-db-driver-for-sql-server/
For example
// Standard security
Provider=MSOLEDBSQL;Server=myServerAddress;Database=myDataBase;UID=myUsername;PWD=myPassword;
// Trusted connection
Provider=MSOLEDBSQL;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;
// Connecting to an SQL Server instance
Provider=MSOLEDBSQL;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;
Check the link for more options