What database type & name am I connected - Community

How do I tell the database configuration that the adtempus installation has ?

The way i deployed adtempus was less than scientific. On some of our earlier installations ,especially during testing, we used the default install of Access.

Later as we became more experienced we started using SQL server.

During installation, it is somewhat challenging to determine what the database configuration is.

I checked the about. It does not list this information there.

I poked around in the program directories, I did not see anything there.

Is there a definitive resource for that information.

Thanks

Steve Atchue

This is stored in the Registry, under key

HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Database

If the Database key is not there, adTempus uses the Access database, which is located in the "data" subdirectory under the adTempus program directory.

If the Database key is there, it will have a connectionString value, which is an OLEDB connection string that identifies the database being used.

The userID and password values are present if adTempus is using SQL Server security to connect to the database; one or both will be absent if it is using integrated (Windows) security.

The password value is an encrypted REG_BINARY value. If you need to change the password, delete the value and recreate it as a String value, set to the password. When adTempus starts it will read the string password, encrypt it, and write it back as REG_BINARY.