if Win98, u must first configure ur SQL server authentication for the user to access...
if WinNT, as long as u r accessible to the specific Database & Server, then u can just connect to it using..SQLDMO with creating one SQLServer object....
dim objSQLServer as SQLDMO.SQLServer
set objSQLServer = new SQLDMO.SQLServer
for WinNT the 2nd & 3rd parameter can just ignore...
but for Win98 or Win95....
u must provide this two...with configuring the Database Login User prior to perform this Statement....
hope it's useful to u....!
anyway...i'm stuck in applying Transaction Log...any ideas ???
calenkl is right as far as it goes but it depends on the authentication method. WinNT/2K will only authenticate against no username/password if that username has been granted access as a trusted connection, otherwise you would have to supply a username and password. All other systems (inc. Win 9x) cannot use trusted connections and therefore have to supply a username/password.
do u know how to apply the Transaction Log anyway ?
i wanna apply it right after i restore my Backup....
the scenario is like this...
1. i backup the database & its TrnLog...all activities halted
2. i truncate the TrnLog...
3. start the activities again...
4. let's say it crashes here...so i wanna restore my DB...
5. after restoring the DB, i gotta apply the new TrnLog rite ? to ensure the Data Integrity...and so the Trns is done successfully...
Reply With Quote
SQLDMO
