DNS-less Connection Strings in a .NET Application

Question:

I want to use a .NET application to connect to the c-treeSQL ODBC driver using a DSN-less connection string. What is required?

Answer:

Your application should include `using System.Data.Odbc' and the following string for the default installation on a local machine.

string connectString=

   "DRIVER={c-treeSQL ODBC Driver}; TRUSTED_CONNECTION=false;"; 

   connectString += "HOST=localhost; DATABASE=ctreeSQL;";

   connectString += "UID=ADMIN; PWD=ADMIN;";

The values of HOST, DATABASE, UID, and PWD are substituted as appropriate for your c-treeSQL Server installation.