August 20, 20214 yr Thanks to MS breaking everything recently, I've had to reinstall P2ATC. I keep getting the attached error: Unable to initialize Database The underlying provider failed on Open. An attempt to attach an auto-named database for file c:\Pilot2ATC_2020_x64\Data\P2ADynamicData.mdf failed. I tried again after removing all the data from 'appdata' as well. Any ideas? Thanks!
August 20, 20214 yr Commercial Member That's a MS Database error. 1. Check that the database files are properly installed in the P2A Data folder. There should be 2 database files: P2ABaseData.mdf and P2ADynamicData.mdf. 2. If they are there, check if there are the corresponding log files: P2ABaseData_log.ldf and P2ADynamicData_log.ldf. You can delete these 2 log files and see if that fixes the issue. 3. If they are not there, reinstall the full version of Pilot2ATC, paying close attention to the installation directory so that it is installed to the same directory as before rather than a sub-directory. 4. If that doesn’t fix it, you can try installing the SQL LocalDB engine again. Here’s a link to the Microsoft installer program on my Dropbox server: https://www.dropbox.com/s/b30wwk84t7a4ngp/SqlLocalDBx64.zip?dl=0 You can download, unzip and run the installer. Take note if any error messages are given, but it should run without issue. Then try starting Pilot2ATC again. 5. If you still get errors, try the following: ⦁ Shut down Pilot2ATC ⦁ Open a Windows command prompt as administrator. ⦁ Type the following command: SQLLocalDB delete "MSSQLLocalDB" ⦁ Type the following command: SQLLocalDB create "MSSQLLocalDB" ⦁ Type the following command: SQLLocalDB start "MSSQLLocalDB" ⦁ Try starting P2A again 6. There may be some corrupt or missing files in the MSSQLLocalDB work folder. It is located at C:\Users\<UserName>\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB where <UserName> is your PC user name. Portions of the path may be hidden by default, so be sure Windows Explorer has Show Hidden Items checked in the View tab. Locate this folder and delete the entire folder. SQL will rebuild the folder and valid contents on the next startup of Pilot2ATC. Dave
May 5, 20224 yr Commercial Member Assuming you're getting the exact same error message, you should do a fresh install of the full program, using the install that includes the Navigraph or NavDataPro data. After that, check to see if it works before trying to update to the Public Beta or trying to update the data. Assuming it works, then you should be able to apply the updates to the new install. Dave
Archived
This topic is now archived and is closed to further replies.