Suggestion to access invalid named database

[olivierf77]

Dear Ritesh

1. Again, thank you for a very neat and powerful program .

In my experience, words are gratitude are never excessive when deserved.

2. In view of my problems accessing a wrongly based database hosted by my ISP (online.fr), and already developped in the thread named:

'connection to a database with invalid name'

I would like to suggest a “slight”(??) modification to your program:

– in the panel: 'connect to my database', add the following checkbox:

X 'accept stupidly named database, and act in cautious way for calls'

(or any shorter title)

– when this option is checked, instead of issuing orders such as:

Code:

select * from database_name.table_name;

issue:

Code:

use `stupid_database_name`;
select * from table_name;

apply this for any order (and yes, I am aware there are many orders). This would probably enable the use of your nice program for almost all orders you have implemented.

When issuing orders implying several databases (such as synchronizing or complex queries), refuse

orders implying the use of more than one invalid named database.

Comment added 4-June-2003: —

Also, it is probable that most orders imply the access to a single database within one SQL query. Thus, issuing a “use dtabase_name;” followed by a sql order without an explicit reference to the database_name is quite reasonable.

— end of added comment —

3.

Also, when accessing some databases hosted by providers (even those using valid database names), please realize that, for security reasons, they may forbid the use of any order which would display the names of other databases.

Some providers may do it by returning a null answer, or answer that there is just one database, but, at least my ISP choses to return a code saying the order is illegal, or not allowed with my security level.

I believe you program should gracefully accept this rebuke, and act accordingly.

Also, I have just emailed again to my host to ask him to reconsider his stupid naming scheme, but with very little hope.

Best Regards, and thank you in advance for any consideration you will give to my suggestion.

Olivier, Paris, France

[Author]

Posts