General database


Home|System settings

Information about the database to be connected to Topocad. This database connection is only for specific or known points. Almost all types of databases can be connected, including MS Excel and SQL databases. To connect and collect all the maps stored in a database you can use any of our other database connections, e.g. ISM adapter.

Databases
Add, edit or delete your database connections.

Search criteria

You can select whether you want to use the known point file (pp file), the database or both.

Editing

Database

Enter the name of the database.

Point columns

Enter the names of columns in the database for the point information.

Attribute columns

Table

Enter the names of columns in the database for the attribute information.

Attribute

Enter the names of columns in the database for the point information.

Connection string
To find the right database.

This is a sample of a Connection string for Excel sheet: Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel files;DBQ=C:\Chaos\database.xls;DefaultDir=C:\Chaos;DriverId=790;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=C:\Chaos

Where C:\Chaos\database.xls is the database in excel file.

Connection string for Microsoft access:

Provider=Microsoft.ACE.OLEDB.12.0;Password=XXXX;User ID=XXXX;Data Source=filnamn;Persist Security Info=True

Request the user name and password

A separate login can be created.