AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: SQL Maestro connection  (Read 2831 times)

0 Members and 1 Guest are viewing this topic.

apjwright

  • New Member
  • *
  • Posts: 46
SQL Maestro connection
« on: July 16, 2010, 11:56:09 PM »
Hi.  I've just downloaded SQL Maestro and am trying to create a database profile against the navdata.db3 file.  What is the appropriate userid/pw to enter in order to connect?

Is there any other settings that are not obvious?

Thanks,
Tony

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: SQL Maestro connection
« Reply #1 on: July 17, 2010, 07:47:16 AM »
I've just downloaded SQL Maestro and am trying to create a database profile against the navdata.db3 file.  What is the appropriate userid/pw to enter in order to connect?

I don't use SQL Maestro (Tarbat is probably the best person to ask), but I can at least confirm that SQLite databases in general, and that includes RadarBox's NavData.db3, don't need a user name or password in order to access them.
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: SQL Maestro connection
« Reply #2 on: July 17, 2010, 07:49:01 AM »
You shouldn't need a userid/pw.   Some instructions on creating a database profile on my site at http://www.tarbat.gofreeserve.com/instructions.htm - see STEP 4.

apjwright

  • New Member
  • *
  • Posts: 46
Re: SQL Maestro connection
« Reply #3 on: July 26, 2010, 01:47:02 AM »
This whole process seems to work differently on my Windows 7 laptop than it did on my previous one (Vista) ... I cannot get SQLite to connect to one of the .db3 databases ...  I'm using the latest version of SQLite-Maestro.

Any assistance, tips, guidance appreciated.

Tony

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: SQL Maestro connection
« Reply #4 on: July 26, 2010, 06:45:26 AM »
When you try to connect, what error(s) do you get?

apjwright

  • New Member
  • *
  • Posts: 46
Re: SQL Maestro connection
« Reply #5 on: July 26, 2010, 11:18:30 AM »
Hi - have sorted this out.  Turns out I had a brain-cramp and was trying to using the MySQL version of Maestro as opposed to the SQLite version.  Think I had better lie down for a while ;-)

Thanks for the help.
Tony