hi,
I want to know through applicaiton how to check whether the Server named"Myserver" is Exists with Database named "MyDatabase" with Tables named ('Table1','Table2','Table3').
For any Database like (MS Access, Oracle, MS SQL-Server,MySQL)..
Please help me.....
thank's in advance.......
Paresh Patel.
Paresh.onmail@.hotmail.com
The syntax would be a bit different for different databases, but basically I believe that the procedure would be the same for all..
You'd have to:
1) connect and login to the server 'Myserver'
2) ask it if 'MyDatabase' exist (eg try use MyDatabas)
3) check for existence of 'Table1', 'Table2' etc (eg try access tables, check for objectnames etc)
You'd also need to know a valid login with appropriate permissions to do this.
/Kenneth
No comments:
Post a Comment