I used VB once, I believed there was two function reside on the same object, DB.CreateDatabase and DB.AttachDatabase. Both provide the same task, "modifying database's metadata/structure" using object-oriented approach.
I, myself, prefer using query, object-oriented is much too many lines of code compared to sql. Correct me if I'm wrong, it has been a decade since my last use of VB. MySQL, has sql function like "SHOW DATABASES", "SHOW TABLES", "IF TABLE xx EXIST", "DESCRIBE xx" or "EXPLAIN xx". Just make a wrapper around it, and you have a better DB.AttachDatabase with fuzzy-logic. Such about metadata modifications. I don't know about other SQL servers. ---------------------------- FIreHAzaR:-D West Java, Indonesia ----- Original Message ----- From: Emmanuel Lamy Hi everybody, Anyone knows if there is a Delphi method that accomplishes the same action as the VB "AttachDatabase" method that the VB programer can use to "attach" an existing database defined by one or several files to a defined instance of SQL Server? Or better, is there an alternative as to register an external SQL database file with another instance of a SQL Server, or SQL Express? Any hint or suggestions welcome. TIA. Emmanuel
