search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Database names being misreported in ODBC connection string lists #724

Closed jajwilson closed 8 years ago

jajwilson commented 8 years ago
  1. Ensure your project has 'enable ODBC access' ticked, and contains more than one database (such as 'New test project especially for Dave' in Dev.
  2. Go to your accounts screen to find ODBC string.
  3. Notice that the same database name is given twice, but with different ODBC names

I'm not sure why only the most recent db is being listed, nor why two different strings are being given - I would expect all three databases in the project to be listed, with a separate connection string for each.

thestoat commented 8 years ago

Your expectation is correct.

thestoat commented 8 years ago

Fixed

jajwilson commented 8 years ago

Hmm. Doesn't seem to be fixed when I try. misreporteddbnames As you can see, by the 'New test project especially for Dave' project, two databases are listed. Both are called 'Mondial #3 uploaded on the 8th October'. Neither is actually the db named. The first one is in fact 'Good old Mondial', whilst the second is 'Mondial #2 uploaded after fixes on 7th October' the third db in the project - the one that is actually called 'Mondial #3 uploaded on the 8th October' is not appearing in the list. Could you take another look?

thestoat commented 8 years ago

Sorry - I should have said, this is only fixed for new databases added. This is because there was a problem at the database level so the web site is reporting the status accurately.

jajwilson commented 8 years ago

Ok. When we shuffle all of this code over into App, will the same problem persist? i.e. will people only be able to create a ODBC link automatically for new projects/database that they add after that point?

thestoat commented 8 years ago

Currently ODBC connections have been done by hand and those settings should continue to work. This was just a reporting issue. Users of app shouldn't be affected since currently the information isn't reported anyway.

jajwilson commented 8 years ago

Yep - works now with new projects.