Skip to content
View in the app

A better way to browse. Learn more.

The AVSIM Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Database Errors After Install

Featured Replies

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!

  • 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

  • Author

That did it!  Thanks so much.

  • 8 months later...
  • 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.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.