SQLDMO

[mutley]

HI

How I connect a DATABASE using SQLDMO with autenticathon NT


thank you very much

[calenkl]

wat platform u r using ?

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

objSQLServer.Connect "ServerName",["Login"],["Password"]

set objSQLServer = nothing

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 ???

[paulw]

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.

Cheers,

P.

[calenkl]

hey...paul....

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...

any ideas anyone ?

THANX !!