search

ox-it / ords

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

Turning ODBC access to 'off' on a project doesn't actually prevent people connecting to that project via ODBC #757

Closed jajwilson closed 8 years ago

jajwilson commented 8 years ago

It seems that the 'switch ODBC off' function doesn't work.

I created an Access db with an ODBC link to a db on ORDS when the ODBC access was switched to 'on'. I then switched ORDS ODBC access to that project to 'off' tried opening my Access db again, and found that I could still log in and edit the db successfully using my credentials.

thestoat commented 8 years ago

I have just tried this and it worked fine. Please add me to your project so I can take a look

MerielP commented 8 years ago

As discussed in the meeting, I've just tried turning off ODBC access for an old project on Dev (the project id is 545837 - as far as I can tell, it's the oldest I have there). It worked there: if ODBC is off, I can't access the tables; if it's on, I can.

thestoat commented 8 years ago

This would suggest it might be a problem with Staging.

thestoat commented 8 years ago

Is this still a problem now new code has gone to staging?

jajwilson commented 8 years ago

I'm no longer getting this problem - hooray!