I took an workstation that was being a temporary server and told Open Dental to use the database on the computer named SERVER. And it did...
Then I joined it to my DC and everything looked right until we noticed a newly added patient we created (doctors wife) wasnt on this one workstation. Sure enough Open Dental latches onto the local opendental database if mysql is running on this workstation. Turn of mysql and it will automatically use the SERVER.
I like to use backup servers that always run mysql and this would interfere... Yes I know I could just turn on mysql and start and stop it when needed...
but having a workstation that used to be the server automatically using its own database without really any warning is scary. Glad we caught it before Monday.
