How to automatically start databases when windows is restarted?

[Former Member]

Hello all,

I´m starting with Sybase and I´m not able to automatically start two databases created by me during the windows startup.

Everytime I restart the computer I have to Start it manually through the Sybase Central, providing the "Database file", "Encription Key", and "Database Name".

Someone knows where can I configure this?

[MarkCulp]

You need to create a Windows service. See the documentation on dbsvc.

For the encryption key, you will need to put it in a @data file and then use dbfhide -w to 'hide' the contents of the file so that users cannot read the encryption key. Note that the -w option encrypts the file using builtin Windows encryption and uses an encryption key that is known to the user only ... so you need to run the dbfhide command when logged in as the same user as the user that is going to run the service.

See the documentation for more information on services.

HTH