OLEDB/ODBC:




An example usingSQL Server, Access,or Oracle for each type of OLE DB or ODBC connection can be used:



Selecting the example then automatically populates the connection string:



All you need to do is replace the missing elements in the connection string.

In this example, we will:

DataSource=SQL server or instance name

Initial Catalog=database name

User ID=user account that can log in to the SQL instance

Password=user's password


The connection string could then be, for example:

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


Requests can now be filled out.