OleDB/ODBC :




An example SQL Server, ACCESS or ORACLE for each type of connection OleBD or ODBC can be used:



The selection of the example then automatically pre-enters the connection string:



The missing parts of the connection chain simply need to be replaced.

In this example, it will be:

DataSource=Server or SQL instance name

Initial Catalog=database name

User ID=user account that can connect to the SQL instance

Password=user password


The connection string could then be for example :

Provider=sqloledb;Data Source=VS-7x6413\;Initial Catalog=myPDMtools;Persist Security Info=True;User ...


Queries can now be filled in.