Spoiler alert! Since I can only write this entire book basically the same for each OLEDB Provider and have 3 for 32-bit and 4 in 64-bit, I must apologize in advance for the use of the same book but with the code changes based on the chosen Provider. Please do not buy this book if it says VS2022,VB.Net, SQL Server, ADO AND RDL Reports. Instead, please replace the connection strings used in the book you purchased and replace them with what I’m using in this book.
For Windows Authentication:
"Provider= SQLNCLIRDA11; Data Source=WIN-U1D8NGFVABF; Integrated Security=SSPI;Initial Catalog=AdventureWorks2019;"
There also is an entire website devoted to connection strings. It is:https://www.connectionstrings.com
I wish you the best of luck in your future learning of how to use OLEDB Providers to create RDL Reports.
This book covers connecting to SQL Server using VB.Net, ADO and the SQL Server Native Client RDA11.0. Once the connection is made, the next step is acquiring a list of tables and views, try complex queries such as inner and outer joins or filter the columns for custom queries. The end goal: create RDL Reports with or without gridlines. Discussions include the use of the SQL.SMO, a discovered real time issue and how to get around it and what the book settled for as the vehicle for creating reports from Stored Procedures. Additional discussions on downloading the Report Viewer, what connection strings are, how to use ADO in a variety of ways and how the code works interactively to produce RDL Reports. This is not a beginners book and expects you to know how to program and have some familiarity with SQL Server.