Board index » delphi » MSSQL DMO and Delphi4

MSSQL DMO and Delphi4

As anyone used Delphi and MS SQL DMO ?
                        or
As anyone had to write Delphi Code to perform :
- Creatation of Databases
- Control Backup procedures

if so ....    how?

Thanks for any insight you may have.

Brad Allen
br...@prismpos.com

 

Re:MSSQL DMO and Delphi4


Quote
Brad Allen wrote in message <8bb81d$m...@bornews.borland.com>...
>As anyone used Delphi and MS SQL DMO ?
>                        or
>As anyone had to write Delphi Code to perform :
>- Creatation of Databases
>- Control Backup procedures

If you're using v6.5, you'll have to log in with administrator rights.  When
I was a Bank One we
encrypted an administrator userid and password for distribution to the
clients.

SQL 7 has server roles to handle this sort of thing, but I haven't used
them.  You can import the type library from the DLL files that ship with SQL
server.  v6.5 implements DMO as an OLE library, so you'll want to write
wrapper components for the DMO objects.  v7 implements DMO as active
controls, which should make things simpler, but again, I haven't worked with
them yet.

Good luck,

Naren

Other Threads