I can't accessing existing view !
Posted by: Amine Hmidi
Date: June 22, 2022 04:04AM

I have a small experience in mysql.
I'm using c# mysql connector net 6.9.7, i have two databases in the same server, database1 and database2 : database1 contain four tables and view (view_1) getted from database2.

My problem is that locally i haven't any problem i can get view_1 data by simple request : "select * from database1.view_1" but when i connect remotly over web an error occured in mysql connector : "the table database1.view_1 does not exist" !
Note that if i select from any of the other four table (remotely) every thing is ok !

Please someone know why this strange behavior occurred ?

Options: ReplyQuote

Written By
I can't accessing existing view !
June 22, 2022 04:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.