Skip to Content
0
Former Member
Dec 17, 2013 at 03:02 AM

Changing to DSN-less ODBC Connection at Runtime

186 Views


Using VS2012 with SAP CRYSTAL REPORTS, DEVELOPER VERSION FOR MICROSOFT VISUAL STUDIO 13.0.7 in a VB.NET 4.0 Winforms application that I inherited.

The reports currently are using an ODBC DSN connection to SQL Server 2012. I would like to change to a DSN-less connection at runtime. There are too many reports to change at design time.

I have found a couple of examples of changing the connection at runtime, but they all use ADO and set DbConnectionAttributes. I can't seem to find any documentation on DbConnectionAttributes.

Could someone please point me to documentation and/or a good example of changing to DSN-less connection at runtime.