ADO.NET Connections

An ADO.NET database connection may be established to an enterprise database within the Oracle or SQL Server database management systems.

Complete the following steps to establish an ADO.NET connection in CartoPac Studio:

1. Right-click on Databases and select Add > Via Connection.

   

   Add Via Connection

2. In the Connection String Builder window, set Architecture to AdoNet and the Provider to either SQLServer, Oracle, or Access.  

   

   Connection String Builder Window

3. Enter the appropriate base level components of the connection string and any additional settings desired.  

4. Click Test Connection to test the connection to ensure the string is valid and an active connection can be established.

5. When the connection has be established, click OK to add the database to the list of database connections.