Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Set cnn = New adodb.Connection
- cnn.ConnectionString = "DRIVER=SQL Server;SERVER=SERVERSERVER;DATABASE=a_db;Trusted_Connection=Yes"
- cnn.Open cnn.ConnectionString
- Set cmd = New adodb.Command
- cmd.ActiveConnection = cnn
- cmd.CommandType = adCmdStoredProc
- cmd.CommandText = "stprMoveDataSet"
- Set param = cmd.CreateParameter("DataSetID", adInteger, adParamInput, 6, stDataSet)
- cmd.Parameters.Append param
- Set param = cmd.CreateParameter("Destination", adChar, adParamInput, 2, stDestination)
- cmd.Parameters.Append param
- rs.CursorType = adOpenStatic
- rs.CursorLocation = adUseClient
- rs.LockType = adLockOptimistic
- rs.Open cmd
- Public dbconn As ADODb.Connection
- Dim cmd As New ADODb.command
- Dim rs As New ADODb.Recordset
- Dim param As New ADODb.Parameter
- Set dbconn = New ADODb.Connection
- dbconn.ConnectionString = GetServerCon
- dbconn.Open dbconn.ConnectionString
- Set cmd = New ADODb.command
- cmd.ActiveConnection = dbconn
- cmd.CommandType = adCmdStoredProc
- cmd.CommandText = "insert_user"
- Set param = cmd.CreateParameter(_
- "username", adVarChar, adParamInput, 50, Environ("UserDomain") & "dddddddd" _
- & Environ("Username"))
- cmd.Parameters.Append param
- rs.CursorType = adOpenStatic
- rs.CursorLocation = adUseClient
- rs.LockType = adLockOptimistic
- rs.Open cmd
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement