Solved
How to get to know the "Connection String" needed to work with ADO.
As described here, one approach to do validation on Databases, is to make use of ADO CreateCommand Method. To be able to make this work, you will need to define the "Connection string" . ...
Did some additional research , and I found this article. Very handy and it gave me everything I needed.
SmartBear support desk helped me out with it as well, with these steps on how to get the Connection String from MS Visual Studio:
You can try connecting to your database from Visual Studio:
- Open the Server Explorer window in Visual Studio.
- Right-click the Data Connections node and select Add Connection.
- Select Microsoft SQL Server as Data Source and .NET Framework Data Provider for OLE DB as Data provider. You'll then need to establish a connection - select the server, provide valid credentials and select your database.
- When the connection is established, you can select you database on the list and see the Connection String value in the Properties tab (see the attached screenshot).
