SQL,access denied: runs

Showing posts with label runs. Show all posts

Sunday, March 25, 2012

ActiveX Script Task - Help!

I have a script that is run in Excel or Access that automatically runs the code I have cut/pasted below. I attempted to cut/paste into an activeX task, but doesn't work. Would anyone be able to convert this to vbscript?
Thank you in advance for your help,
clutch
Attribute VB_Name = "CD-1291"
Option Compare Database
Option Explicit
Public Function CD1291()
On Error GoTo CD1291_Err
Dim Y As String, M1 As String, M2 As String, D1 As String, D2 As String, d As String, L1, L2, sd As Date
d = Application.CurrentProject.Path
If Dir(d & "\CD1291.msl") <> "" Then Kill (d & "\CD1291.msl")
If Dir(d & "\CD1291.bat") <> "" Then Kill (d & "\CD1291.bat")
If Dir(d & "\CD1291.mod") <> "" Then Kill (d & "\CD1291.mod")
If Dir(d & "\CD1291.prj") <> "" Then Kill (d & "\CD1291.prj")
If Dir(d & "\CD1291.RPT") <> "" Then Kill (d & "\CD1291.RPT")
If Dir(d & "\CD1291.TMP") <> "" Then Kill (d & "\CD1291.TMP")
Y = Year(Now() - 1)
M1 = Month(Now() - 1)
If M1 < 10 Then
M1 = "0" & M1
End If
M2 = Month(Now() - 1)
If M2 < 10 Then
M2 = "0" & M2
End If
D1 = Day(Now() - 1)
If D1 < 10 Then
D1 = "0" & D1
End If
D2 = Day(Now() - 1)
If D2 < 10 Then
D2 = "0" & D2
End If
'MsgBox Y & "-" & M1 & "-" & D1
p = Application.CurrentProject.Path
''' MSL
Open p & "\CD1291.msl" For Output As #1
Print #1, "OPENTOPIC SERVERID 'OARS' TOPICNAME '5625' TOPICVERSIONID '" & Y & M1 & D1 & "001001' TOPICITEM 'CD-1291 1853 SYS E=" & M2 & D2 & "0" & Right(Y, 1) + 1 & "' REPORTID 'CD-1291' EXACTTOPICITEM"
Print #1, "EXPORT ASCII FILE '" & p & "\CD1291.TMP' ALL GROUP ''"
Print #1, "CLOSE"
Print #1, "RUN '" & p & "\CD1291.bat'"
Print #1, "EXIT"
Close #1
''' MOD
Open p & "\CD1291.mod" For Output As #1
Print #1, "MFWMOD12"
Print #1, "~Description"
Print #1, "Premier Bankcard, Inc."
Print #1, ""
Print #1, "~Settings"
Print #1, "M/D/Y"
Print #1, "50"
Print #1, "."
Print #1, "0"
Print #1, "1"
Print #1, "1"
Print #1, ","
Print #1, "0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "Y"
Print #1, "~ExtendedSettings"
Print #1, "42"
Print #1, "N"
Print #1, "(Null)"
Print #1, "1"
Print #1, "1"
Print #1, "128128255"
Print #1, "128,32,96"
Print #1, "255,0,255"
Print #1, "160,0,224"
Print #1, "64128128"
Print #1, "255,0,128"
Print #1, "128128128"
Print #1, "85,85,255"
Print #1, "128,0,128"
Print #1, "193,0,193"
Print #1, "255115115"
Print #1, "128,64,255"
Print #1, "0,128,0"
Print #1, "128,64,64"
Print #1, "255,0,0"
Print #1, "255191255"
Print #1, "255255255"
Print #1, "225225225"
Print #1, "151151151"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "12"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "10"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "8"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "~TableField"
Print #1, "Acct #"
Print #1, "16"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "16"
Print #1, "3"
Print #1, "N"
Print #1, "N"
Print #1, "16"
Print #1, "5"
Print #1, "0"
Print #1, "0"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Acct #"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Pymt Date"
Print #1, "10"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "10"
Print #1, "4"
Print #1, "N"
Print #1, "N"
Print #1, "10"
Print #1, "5"
Print #1, "0"
Print #1, "18"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Pymt Date"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Payment"
Print #1, "18"
Print #1, "2"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "19"
Print #1, "5"
Print #1, "N"
Print #1, "N"
Print #1, "19"
Print #1, "5"
Print #1, "0"
Print #1, "30"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Payment"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float Amount"
Print #1, "18"
Print #1, "2"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "16"
Print #1, "6"
Print #1, "N"
Print #1, "N"
Print #1, "16"
Print #1, "5"
Print #1, "0"
Print #1, "53"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float Amount"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Strat ID"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "7"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "70"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Strat ID"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Line"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "8"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "80"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Line"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Actn ID"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "9"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "86"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Actn ID"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Ltr #"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "10"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "96"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Ltr #"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Ltr Data"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "11"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "108"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Ltr Data"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float %"
Print #1, "18"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "5"
Print #1, "12"
Print #1, "N"
Print #1, "N"
Print #1, "5"
Print #1, "5"
Print #1, "0"
Print #1, "119"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float %"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Q Prio"
Print #1, "2"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "2"
Print #1, "13"
Print #1, "N"
Print #1, "N"
Print #1, "2"
Print #1, "5"
Print #1, "2"
Print #1, "18"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Q Prio"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float Cycle"
Print #1, "3"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "3"
Print #1, "14"
Print #1, "N"
Print #1, "N"
Print #1, "3"
Print #1, "5"
Print #1, "2"
Print #1, "30"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float Cycle"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Rpt"
Print #1, "7"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "7"
Print #1, "1"
Print #1, "N"
Print #1, "N"
Print #1, "7"
Print #1, "0"
Print #1, "0"
Print #1, "0"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Rpt"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Date"
Print #1, "8"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "D"
Print #1, "0"
Print #1, "12"
Print #1, "2"
Print #1, "N"
Print #1, "N"
Print #1, "14"
Print #1, "0"
Print #1, "0"
Print #1, "107"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Date"
Print #1, "3"
Print #1, "N"
Print #1, "1"
Print #1, "1"
Print #1, "~Level"
Print #1, "0"
Print #1, ""
Print #1, "1"
Print #1, "CD-1291 1108/ AVAILABLE FUNDS ACCOUNT DATA FIRST PREMIER BANK -FD- 01/09/04 PAGE 1 "
Print #1, "2"
Print #1, "0"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~LevelExtended"
Print #1, "0"
Print #1, "2"
Print #1, "Page Header"
Print #1, "N"
Print #1, "N"
Print #1, "~Level"
Print #1, "5"
Print #1, "???????????"
Print #1, "3"
Print #1, "5149860001000015 2004/01/09 5.00 5.00 0002 0009 0001 0000 0000 100 "
Print #1, " QUEUE PRIO FLOAT CYCL "
Print #1, " 00 011 "
Print #1, "12"
Print #1, "0"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~LevelExtended"
Print #1, "5"
Print #1, "2"
Print #1, "Detail"
Print #1, "N"
Print #1, "N"
Print #1, "~PageSetup"
Print #1, "1"
Print #1, "256"
Print #1, "10"
Print #1, "50"
Print #1, "50"
Print #1, "2"
Print #1, "Y"
Print #1, "Y"
Print #1, "Y"
Print #1, ""
Print #1, "~PageSetupExtended"
Print #1, "1"
Print #1, "Y"
Print #1, "~End"
Close #1
'''PRJ
Open p & "\CD1291.prj" For Output As #1
Print #1, "MFWPRJ01"
Print #1, "[RefreshDDR]"
Print #1, "[InputFile]"
Print #1, p & "\CD1291.RPT"
Print #1, "[ModelFile]"
Print #1, p & "\CD1291.mod"
Print #1, "[ViewTable]"
Print #1, "[SummaryNoChart]"
Print #1, "[Author]"
Print #1, "[Description]"
Print #1, "[ASCII]"
Print #1, "[End]"
Close #1
''' BAT
Open p & "\CD1291.bat" For Output As #1
Print #1, "@.echo off"
Print #1, "copy " & p & "\CD1291.TMP " & p & "\CD1291.RPT"
Print #1, "del " & p & "\CD1291.TMP"
Close #1
'''Execute
Do Until Dir(p & "\CD1291.TMP") <> "" Or Dir(p & "\CD1291.RPT") <> ""
Shell ("C:\Program Files\Mobius\DDR\rdswin.exe " & p & "\CD1291.msl /E")
Pause (30)
Loop
Do Until Dir(p & "\CD1291.TMP") = ""
DoEvents
Loop
Pause (5)
If Dir("C:\CD1291.ASC") <> "" Then Kill ("C:\CD1291.ASC")
Shell ("C:\Program Files\Mobius\DocuAnalyzer\program\analyzer.exe " & p & "\CD1291.prj " & p & "\CD1291.ASC")
Pause (5)
L1 = 1
Do Until L1 = L2
Open p & "\CD1291.ASC" For Random As #1
L1 = LOF(1)
Close #1
Pause (5)
Open p & "\CD1291.ASC" For Random As #1
L2 = LOF(1)
Close #1
Loop
Pause (5)
If Dir(p & "\CD1291.msl") <> "" Then Kill (p & "\CD1291.msl")
If Dir(p & "\CD1291.bat") <> "" Then Kill (p & "\CD1291.bat")
If Dir(p & "\CD1291.mod") <> "" Then Kill (p & "\CD1291.mod")
If Dir(p & "\CD1291.prj") <> "" Then Kill (p & "\CD1291.prj")
If Dir(p & "\CD1291.RPT") <> "" Then Kill (p & "\CD1291.RPT")
If Dir(p & "\CD1291.TMP") <> "" Then Kill (p & "\CD1291.TMP")
End Function
You are going to have some very hard work cut out for you here. There is no
application class in VBScripting. There is no DIR() function. There is no
Kill function. You may want to transfer code to VB.net and then have DTS run
an application.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:974122A0-6D23-4C82-BA82-2FCBAF8D2716@.microsoft.com...
> I have a script that is run in Excel or Access that automatically runs the
code I have cut/pasted below. I attempted to cut/paste into an activeX task,
but doesn't work. Would anyone be able to convert this to vbscript?
> Thank you in advance for your help,
> clutch
> Attribute VB_Name = "CD-1291"
> Option Compare Database
> Option Explicit
> Public Function CD1291()
> On Error GoTo CD1291_Err
> Dim Y As String, M1 As String, M2 As String, D1 As String, D2 As String, d
As String, L1, L2, sd As Date
>
> d = Application.CurrentProject.Path
> If Dir(d & "\CD1291.msl") <> "" Then Kill (d & "\CD1291.msl")
> If Dir(d & "\CD1291.bat") <> "" Then Kill (d & "\CD1291.bat")
> If Dir(d & "\CD1291.mod") <> "" Then Kill (d & "\CD1291.mod")
> If Dir(d & "\CD1291.prj") <> "" Then Kill (d & "\CD1291.prj")
> If Dir(d & "\CD1291.RPT") <> "" Then Kill (d & "\CD1291.RPT")
> If Dir(d & "\CD1291.TMP") <> "" Then Kill (d & "\CD1291.TMP")
> Y = Year(Now() - 1)
> M1 = Month(Now() - 1)
> If M1 < 10 Then
> M1 = "0" & M1
> End If
> M2 = Month(Now() - 1)
> If M2 < 10 Then
> M2 = "0" & M2
> End If
> D1 = Day(Now() - 1)
> If D1 < 10 Then
> D1 = "0" & D1
> End If
> D2 = Day(Now() - 1)
> If D2 < 10 Then
> D2 = "0" & D2
> End If
> 'MsgBox Y & "-" & M1 & "-" & D1
> p = Application.CurrentProject.Path
> ''' MSL
> Open p & "\CD1291.msl" For Output As #1
> Print #1, "OPENTOPIC SERVERID 'OARS' TOPICNAME '5625' TOPICVERSIONID
'" & Y & M1 & D1 & "001001' TOPICITEM 'CD-1291 1853 SYS E=" & M2 & D2 &
"0" & Right(Y, 1) + 1 & "' REPORTID 'CD-1291' EXACTTOPICITEM"
> Print #1, "EXPORT ASCII FILE '" & p & "\CD1291.TMP' ALL GROUP ''"
> Print #1, "CLOSE"
> Print #1, "RUN '" & p & "\CD1291.bat'"
> Print #1, "EXIT"
> Close #1
> ''' MOD
> Open p & "\CD1291.mod" For Output As #1
> Print #1, "MFWMOD12"
> Print #1, "~Description"
> Print #1, "Premier Bankcard, Inc."
> Print #1, ""
> Print #1, "~Settings"
> Print #1, "M/D/Y"
> Print #1, "50"
> Print #1, "."
> Print #1, "0"
> Print #1, "1"
> Print #1, "1"
> Print #1, ","
> Print #1, "0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "Y"
> Print #1, "~ExtendedSettings"
> Print #1, "42"
> Print #1, "N"
> Print #1, "(Null)"
> Print #1, "1"
> Print #1, "1"
> Print #1, "128128255"
> Print #1, "128,32,96"
> Print #1, "255,0,255"
> Print #1, "160,0,224"
> Print #1, "64128128"
> Print #1, "255,0,128"
> Print #1, "128128128"
> Print #1, "85,85,255"
> Print #1, "128,0,128"
> Print #1, "193,0,193"
> Print #1, "255115115"
> Print #1, "128,64,255"
> Print #1, "0,128,0"
> Print #1, "128,64,64"
> Print #1, "255,0,0"
> Print #1, "255191255"
> Print #1, "255255255"
> Print #1, "225225225"
> Print #1, "151151151"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "12"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "10"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "8"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "~TableField"
> Print #1, "Acct #"
> Print #1, "16"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "16"
> Print #1, "3"
> Print #1, "N"
> Print #1, "N"
> Print #1, "16"
> Print #1, "5"
> Print #1, "0"
> Print #1, "0"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Acct #"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Pymt Date"
> Print #1, "10"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "10"
> Print #1, "4"
> Print #1, "N"
> Print #1, "N"
> Print #1, "10"
> Print #1, "5"
> Print #1, "0"
> Print #1, "18"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Pymt Date"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Payment"
> Print #1, "18"
> Print #1, "2"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "19"
> Print #1, "5"
> Print #1, "N"
> Print #1, "N"
> Print #1, "19"
> Print #1, "5"
> Print #1, "0"
> Print #1, "30"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Payment"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float Amount"
> Print #1, "18"
> Print #1, "2"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "16"
> Print #1, "6"
> Print #1, "N"
> Print #1, "N"
> Print #1, "16"
> Print #1, "5"
> Print #1, "0"
> Print #1, "53"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float Amount"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Strat ID"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "7"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "70"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Strat ID"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Line"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "8"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "80"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Line"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Actn ID"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "9"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "86"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Actn ID"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Ltr #"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "10"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "96"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Ltr #"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Ltr Data"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "11"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "108"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Ltr Data"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float %"
> Print #1, "18"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "5"
> Print #1, "12"
> Print #1, "N"
> Print #1, "N"
> Print #1, "5"
> Print #1, "5"
> Print #1, "0"
> Print #1, "119"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float %"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Q Prio"
> Print #1, "2"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "2"
> Print #1, "13"
> Print #1, "N"
> Print #1, "N"
> Print #1, "2"
> Print #1, "5"
> Print #1, "2"
> Print #1, "18"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Q Prio"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float Cycle"
> Print #1, "3"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "3"
> Print #1, "14"
> Print #1, "N"
> Print #1, "N"
> Print #1, "3"
> Print #1, "5"
> Print #1, "2"
> Print #1, "30"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float Cycle"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Rpt"
> Print #1, "7"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "7"
> Print #1, "1"
> Print #1, "N"
> Print #1, "N"
> Print #1, "7"
> Print #1, "0"
> Print #1, "0"
> Print #1, "0"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Rpt"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Date"
> Print #1, "8"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "D"
> Print #1, "0"
> Print #1, "12"
> Print #1, "2"
> Print #1, "N"
> Print #1, "N"
> Print #1, "14"
> Print #1, "0"
> Print #1, "0"
> Print #1, "107"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Date"
> Print #1, "3"
> Print #1, "N"
> Print #1, "1"
> Print #1, "1"
> Print #1, "~Level"
> Print #1, "0"
> Print #1, ""
> Print #1, "1"
> Print #1, "CD-1291 1108/ AVAILABLE FUNDS ACCOUNT DATA
FIRST PREMIER BANK -FD- 01/09/04 PAGE 1
"
> Print #1, "2"
> Print #1, "0"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~LevelExtended"
> Print #1, "0"
> Print #1, "2"
> Print #1, "Page Header"
> Print #1, "N"
> Print #1, "N"
> Print #1, "~Level"
> Print #1, "5"
> Print #1, ""
> Print #1, "3"
> Print #1, "5149860001000015 2004/01/09 5.00
5.00 0002 0009 0001 0000 0000 100
"
> Print #1, " QUEUE PRIO FLOAT CYCL
"
> Print #1, " 00 011
"
> Print #1, "12"
> Print #1, "0"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~LevelExtended"
> Print #1, "5"
> Print #1, "2"
> Print #1, "Detail"
> Print #1, "N"
> Print #1, "N"
> Print #1, "~PageSetup"
> Print #1, "1"
> Print #1, "256"
> Print #1, "10"
> Print #1, "50"
> Print #1, "50"
> Print #1, "2"
> Print #1, "Y"
> Print #1, "Y"
> Print #1, "Y"
> Print #1, ""
> Print #1, "~PageSetupExtended"
> Print #1, "1"
> Print #1, "Y"
> Print #1, "~End"
> Close #1
>
> '''PRJ
> Open p & "\CD1291.prj" For Output As #1
> Print #1, "MFWPRJ01"
> Print #1, "[RefreshDDR]"
> Print #1, "[InputFile]"
> Print #1, p & "\CD1291.RPT"
> Print #1, "[ModelFile]"
> Print #1, p & "\CD1291.mod"
> Print #1, "[ViewTable]"
> Print #1, "[SummaryNoChart]"
> Print #1, "[Author]"
> Print #1, "[Description]"
> Print #1, "[ASCII]"
> Print #1, "[End]"
> Close #1
>
> ''' BAT
> Open p & "\CD1291.bat" For Output As #1
> Print #1, "@.echo off"
> Print #1, "copy " & p & "\CD1291.TMP " & p & "\CD1291.RPT"
> Print #1, "del " & p & "\CD1291.TMP"
> Close #1
> '''Execute
> Do Until Dir(p & "\CD1291.TMP") <> "" Or Dir(p & "\CD1291.RPT") <> ""
> Shell ("C:\Program Files\Mobius\DDR\rdswin.exe " & p & "\CD1291.msl
/E")
> Pause (30)
> Loop
> Do Until Dir(p & "\CD1291.TMP") = ""
> DoEvents
> Loop
> Pause (5)
> If Dir("C:\CD1291.ASC") <> "" Then Kill ("C:\CD1291.ASC")
> Shell ("C:\Program Files\Mobius\DocuAnalyzer\program\analyzer.exe " & p &
"\CD1291.prj " & p & "\CD1291.ASC")
> Pause (5)
> L1 = 1
> Do Until L1 = L2
> Open p & "\CD1291.ASC" For Random As #1
> L1 = LOF(1)
> Close #1
> Pause (5)
> Open p & "\CD1291.ASC" For Random As #1
> L2 = LOF(1)
> Close #1
> Loop
> Pause (5)
>
> If Dir(p & "\CD1291.msl") <> "" Then Kill (p & "\CD1291.msl")
> If Dir(p & "\CD1291.bat") <> "" Then Kill (p & "\CD1291.bat")
> If Dir(p & "\CD1291.mod") <> "" Then Kill (p & "\CD1291.mod")
> If Dir(p & "\CD1291.prj") <> "" Then Kill (p & "\CD1291.prj")
> If Dir(p & "\CD1291.RPT") <> "" Then Kill (p & "\CD1291.RPT")
> If Dir(p & "\CD1291.TMP") <> "" Then Kill (p & "\CD1291.TMP")
>
> End Function
>
>

ActiveX Script Task - Help!

I have a script that is run in Excel or Access that automatically runs the c
ode I have cut/pasted below. I attempted to cut/paste into an activeX task,
but doesn't work. Would anyone be able to convert this to vbscript?
Thank you in advance for your help,
clutch
Attribute VB_Name = "CD-1291"
Option Compare Database
Option Explicit
Public Function CD1291()
On Error GoTo CD1291_Err
Dim Y As String, M1 As String, M2 As String, D1 As String, D2 As String, d A
s String, L1, L2, sd As Date
d = Application.CurrentProject.Path
If Dir(d & "\CD1291.msl") <> "" Then Kill (d & "\CD1291.msl")
If Dir(d & "\CD1291.bat") <> "" Then Kill (d & "\CD1291.bat")
If Dir(d & "\CD1291.mod") <> "" Then Kill (d & "\CD1291.mod")
If Dir(d & "\CD1291.prj") <> "" Then Kill (d & "\CD1291.prj")
If Dir(d & "\CD1291.RPT") <> "" Then Kill (d & "\CD1291.RPT")
If Dir(d & "\CD1291.TMP") <> "" Then Kill (d & "\CD1291.TMP")
Y = Year(Now() - 1)
M1 = Month(Now() - 1)
If M1 < 10 Then
M1 = "0" & M1
End If
M2 = Month(Now() - 1)
If M2 < 10 Then
M2 = "0" & M2
End If
D1 = Day(Now() - 1)
If D1 < 10 Then
D1 = "0" & D1
End If
D2 = Day(Now() - 1)
If D2 < 10 Then
D2 = "0" & D2
End If
'MsgBox Y & "-" & M1 & "-" & D1
p = Application.CurrentProject.Path
''' MSL
Open p & "\CD1291.msl" For Output As #1
Print #1, "OPENTOPIC SERVERID 'OARS' TOPICNAME '5625' TOPICVERSIONID '" & Y
& M1 & D1 & "001001' TOPICITEM 'CD-1291 1853 SYS E=" & M2 & D2 & "0" &
Right(Y, 1) + 1 & "' REPORTID 'CD-1291' EXACTTOPICITEM"
Print #1, "EXPORT ASCII FILE '" & p & "\CD1291.TMP' ALL GROUP ''"
Print #1, "CLOSE"
Print #1, "RUN '" & p & "\CD1291.bat'"
Print #1, "EXIT"
Close #1
''' MOD
Open p & "\CD1291.mod" For Output As #1
Print #1, "MFWMOD12"
Print #1, "~Description"
Print #1, "Premier Bankcard, Inc."
Print #1, ""
Print #1, "~Settings"
Print #1, "M/D/Y"
Print #1, "50"
Print #1, "."
Print #1, "0"
Print #1, "1"
Print #1, "1"
Print #1, ","
Print #1, "0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "Y"
Print #1, "~ExtendedSettings"
Print #1, "42"
Print #1, "N"
Print #1, "(Null)"
Print #1, "1"
Print #1, "1"
Print #1, "128128255"
Print #1, "128,32,96"
Print #1, "255,0,255"
Print #1, "160,0,224"
Print #1, "64128128"
Print #1, "255,0,128"
Print #1, "128128128"
Print #1, "85,85,255"
Print #1, "128,0,128"
Print #1, "193,0,193"
Print #1, "255115115"
Print #1, "128,64,255"
Print #1, "0,128,0"
Print #1, "128,64,64"
Print #1, "255,0,0"
Print #1, "255191255"
Print #1, "255255255"
Print #1, "225225225"
Print #1, "151151151"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "12"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "10"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "N"
Print #1, "N"
Print #1, "8"
Print #1, "Verdana"
Print #1, "0,0,0"
Print #1, "N"
Print #1, "~TableField"
Print #1, "Acct #"
Print #1, "16"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "16"
Print #1, "3"
Print #1, "N"
Print #1, "N"
Print #1, "16"
Print #1, "5"
Print #1, "0"
Print #1, "0"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Acct #"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Pymt Date"
Print #1, "10"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "10"
Print #1, "4"
Print #1, "N"
Print #1, "N"
Print #1, "10"
Print #1, "5"
Print #1, "0"
Print #1, "18"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Pymt Date"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Payment"
Print #1, "18"
Print #1, "2"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "19"
Print #1, "5"
Print #1, "N"
Print #1, "N"
Print #1, "19"
Print #1, "5"
Print #1, "0"
Print #1, "30"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Payment"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float Amount"
Print #1, "18"
Print #1, "2"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "16"
Print #1, "6"
Print #1, "N"
Print #1, "N"
Print #1, "16"
Print #1, "5"
Print #1, "0"
Print #1, "53"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float Amount"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Strat ID"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "7"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "70"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Strat ID"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Line"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "8"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "80"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Line"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Actn ID"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "9"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "86"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Actn ID"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Ltr #"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "10"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "96"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Ltr #"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Ltr Data"
Print #1, "4"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "4"
Print #1, "11"
Print #1, "N"
Print #1, "N"
Print #1, "4"
Print #1, "5"
Print #1, "0"
Print #1, "108"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Ltr Data"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float %"
Print #1, "18"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "N"
Print #1, "0"
Print #1, "5"
Print #1, "12"
Print #1, "N"
Print #1, "N"
Print #1, "5"
Print #1, "5"
Print #1, "0"
Print #1, "119"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float %"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Q Prio"
Print #1, "2"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "2"
Print #1, "13"
Print #1, "N"
Print #1, "N"
Print #1, "2"
Print #1, "5"
Print #1, "2"
Print #1, "18"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Q Prio"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Float Cycle"
Print #1, "3"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "3"
Print #1, "14"
Print #1, "N"
Print #1, "N"
Print #1, "3"
Print #1, "5"
Print #1, "2"
Print #1, "30"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Float Cycle"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Rpt"
Print #1, "7"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "C"
Print #1, "0"
Print #1, "7"
Print #1, "1"
Print #1, "N"
Print #1, "N"
Print #1, "7"
Print #1, "0"
Print #1, "0"
Print #1, "0"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Rpt"
Print #1, "3"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~TableField"
Print #1, "Date"
Print #1, "8"
Print #1, "0"
Print #1, "0"
Print #1, "1"
Print #1, "D"
Print #1, "0"
Print #1, "12"
Print #1, "2"
Print #1, "N"
Print #1, "N"
Print #1, "14"
Print #1, "0"
Print #1, "0"
Print #1, "107"
Print #1, "N"
Print #1, "~TableFieldExtended"
Print #1, "Date"
Print #1, "3"
Print #1, "N"
Print #1, "1"
Print #1, "1"
Print #1, "~Level"
Print #1, "0"
Print #1, ""
Print #1, "1"
Print #1, "CD-1291 1108/ AVAILABLE FUNDS ACCOUNT DATA
FIRST PREMIER BANK -FD- 01/09/04 PAGE 1
"
Print #1, "2"
Print #1, "0"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~LevelExtended"
Print #1, "0"
Print #1, "2"
Print #1, "Page Header"
Print #1, "N"
Print #1, "N"
Print #1, "~Level"
Print #1, "5"
Print #1, "???????????"
Print #1, "3"
Print #1, "5149860001000015 2004/01/09 5.00 5
.00 0002 0009 0001 0000 0000 100
"
Print #1, " QUEUE PRIO FLOAT CYCL
"
Print #1, " 00 011
"
Print #1, "12"
Print #1, "0"
Print #1, "N"
Print #1, "0"
Print #1, "0"
Print #1, "~LevelExtended"
Print #1, "5"
Print #1, "2"
Print #1, "Detail"
Print #1, "N"
Print #1, "N"
Print #1, "~PageSetup"
Print #1, "1"
Print #1, "256"
Print #1, "10"
Print #1, "50"
Print #1, "50"
Print #1, "2"
Print #1, "Y"
Print #1, "Y"
Print #1, "Y"
Print #1, ""
Print #1, "~PageSetupExtended"
Print #1, "1"
Print #1, "Y"
Print #1, "~End"
Close #1
'''PRJ
Open p & "\CD1291.prj" For Output As #1
Print #1, "MFWPRJ01"
Print #1, "[RefreshDDR]"
Print #1, "[InputFile]"
Print #1, p & "\CD1291.RPT"
Print #1, "[ModelFile]"
Print #1, p & "\CD1291.mod"
Print #1, "[ViewTable]"
Print #1, "[SummaryNoChart]"
Print #1, "[Author]"
Print #1, "[Description]"
Print #1, "[ASCII]"
Print #1, "[End]"
Close #1
''' BAT
Open p & "\CD1291.bat" For Output As #1
Print #1, "@.echo off"
Print #1, "copy " & p & "\CD1291.TMP " & p & "\CD1291.RPT"
Print #1, "del " & p & "\CD1291.TMP"
Close #1
'''Execute
Do Until Dir(p & "\CD1291.TMP") <> "" Or Dir(p & "\CD1291.RPT") <> ""
Shell ("C:\Program Files\Mobius\DDR\rdswin.exe " & p & "\CD1291.msl /E")
Pause (30)
Loop
Do Until Dir(p & "\CD1291.TMP") = ""
DoEvents
Loop
Pause (5)
If Dir("C:\CD1291.ASC") <> "" Then Kill ("C:\CD1291.ASC")
Shell ("C:\Program Files\Mobius\DocuAnalyzer\program\analyz
er.exe " & p & "\
CD1291.prj " & p & "\CD1291.ASC")
Pause (5)
L1 = 1
Do Until L1 = L2
Open p & "\CD1291.ASC" For Random As #1
L1 = LOF(1)
Close #1
Pause (5)
Open p & "\CD1291.ASC" For Random As #1
L2 = LOF(1)
Close #1
Loop
Pause (5)
If Dir(p & "\CD1291.msl") <> "" Then Kill (p & "\CD1291.msl")
If Dir(p & "\CD1291.bat") <> "" Then Kill (p & "\CD1291.bat")
If Dir(p & "\CD1291.mod") <> "" Then Kill (p & "\CD1291.mod")
If Dir(p & "\CD1291.prj") <> "" Then Kill (p & "\CD1291.prj")
If Dir(p & "\CD1291.RPT") <> "" Then Kill (p & "\CD1291.RPT")
If Dir(p & "\CD1291.TMP") <> "" Then Kill (p & "\CD1291.TMP")
End FunctionYou are going to have some very hard work cut out for you here. There is no
application class in VBScripting. There is no DIR() function. There is no
Kill function. You may want to transfer code to VB.net and then have DTS run
an application.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:974122A0-6D23-4C82-BA82-2FCBAF8D2716@.microsoft.com...
> I have a script that is run in Excel or Access that automatically runs the
code I have cut/pasted below. I attempted to cut/paste into an activeX task,
but doesn't work. Would anyone be able to convert this to vbscript?
> Thank you in advance for your help,
> clutch
> Attribute VB_Name = "CD-1291"
> Option Compare Database
> Option Explicit
> Public Function CD1291()
> On Error GoTo CD1291_Err
> Dim Y As String, M1 As String, M2 As String, D1 As String, D2 As String, d
As String, L1, L2, sd As Date
>
> d = Application.CurrentProject.Path
> If Dir(d & "\CD1291.msl") <> "" Then Kill (d & "\CD1291.msl")
> If Dir(d & "\CD1291.bat") <> "" Then Kill (d & "\CD1291.bat")
> If Dir(d & "\CD1291.mod") <> "" Then Kill (d & "\CD1291.mod")
> If Dir(d & "\CD1291.prj") <> "" Then Kill (d & "\CD1291.prj")
> If Dir(d & "\CD1291.RPT") <> "" Then Kill (d & "\CD1291.RPT")
> If Dir(d & "\CD1291.TMP") <> "" Then Kill (d & "\CD1291.TMP")
> Y = Year(Now() - 1)
> M1 = Month(Now() - 1)
> If M1 < 10 Then
> M1 = "0" & M1
> End If
> M2 = Month(Now() - 1)
> If M2 < 10 Then
> M2 = "0" & M2
> End If
> D1 = Day(Now() - 1)
> If D1 < 10 Then
> D1 = "0" & D1
> End If
> D2 = Day(Now() - 1)
> If D2 < 10 Then
> D2 = "0" & D2
> End If
> 'MsgBox Y & "-" & M1 & "-" & D1
> p = Application.CurrentProject.Path
> ''' MSL
> Open p & "\CD1291.msl" For Output As #1
> Print #1, "OPENTOPIC SERVERID 'OARS' TOPICNAME '5625' TOPICVERSIONID
'" & Y & M1 & D1 & "001001' TOPICITEM 'CD-1291 1853 SYS E=" & M2 & D2 &
"0" & Right(Y, 1) + 1 & "' REPORTID 'CD-1291' EXACTTOPICITEM"
> Print #1, "EXPORT ASCII FILE '" & p & "\CD1291.TMP' ALL GROUP ''"
> Print #1, "CLOSE"
> Print #1, "RUN '" & p & "\CD1291.bat'"
> Print #1, "EXIT"
> Close #1
> ''' MOD
> Open p & "\CD1291.mod" For Output As #1
> Print #1, "MFWMOD12"
> Print #1, "~Description"
> Print #1, "Premier Bankcard, Inc."
> Print #1, ""
> Print #1, "~Settings"
> Print #1, "M/D/Y"
> Print #1, "50"
> Print #1, "."
> Print #1, "0"
> Print #1, "1"
> Print #1, "1"
> Print #1, ","
> Print #1, "0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "Y"
> Print #1, "~ExtendedSettings"
> Print #1, "42"
> Print #1, "N"
> Print #1, "(Null)"
> Print #1, "1"
> Print #1, "1"
> Print #1, "128128255"
> Print #1, "128,32,96"
> Print #1, "255,0,255"
> Print #1, "160,0,224"
> Print #1, "64128128"
> Print #1, "255,0,128"
> Print #1, "128128128"
> Print #1, "85,85,255"
> Print #1, "128,0,128"
> Print #1, "193,0,193"
> Print #1, "255115115"
> Print #1, "128,64,255"
> Print #1, "0,128,0"
> Print #1, "128,64,64"
> Print #1, "255,0,0"
> Print #1, "255191255"
> Print #1, "255255255"
> Print #1, "225225225"
> Print #1, "151151151"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "12"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "10"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "N"
> Print #1, "N"
> Print #1, "8"
> Print #1, "Verdana"
> Print #1, "0,0,0"
> Print #1, "N"
> Print #1, "~TableField"
> Print #1, "Acct #"
> Print #1, "16"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "16"
> Print #1, "3"
> Print #1, "N"
> Print #1, "N"
> Print #1, "16"
> Print #1, "5"
> Print #1, "0"
> Print #1, "0"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Acct #"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Pymt Date"
> Print #1, "10"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "10"
> Print #1, "4"
> Print #1, "N"
> Print #1, "N"
> Print #1, "10"
> Print #1, "5"
> Print #1, "0"
> Print #1, "18"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Pymt Date"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Payment"
> Print #1, "18"
> Print #1, "2"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "19"
> Print #1, "5"
> Print #1, "N"
> Print #1, "N"
> Print #1, "19"
> Print #1, "5"
> Print #1, "0"
> Print #1, "30"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Payment"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float Amount"
> Print #1, "18"
> Print #1, "2"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "16"
> Print #1, "6"
> Print #1, "N"
> Print #1, "N"
> Print #1, "16"
> Print #1, "5"
> Print #1, "0"
> Print #1, "53"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float Amount"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Strat ID"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "7"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "70"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Strat ID"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Line"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "8"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "80"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Line"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Actn ID"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "9"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "86"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Actn ID"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Ltr #"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "10"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "96"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Ltr #"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Ltr Data"
> Print #1, "4"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "4"
> Print #1, "11"
> Print #1, "N"
> Print #1, "N"
> Print #1, "4"
> Print #1, "5"
> Print #1, "0"
> Print #1, "108"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Ltr Data"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float %"
> Print #1, "18"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "N"
> Print #1, "0"
> Print #1, "5"
> Print #1, "12"
> Print #1, "N"
> Print #1, "N"
> Print #1, "5"
> Print #1, "5"
> Print #1, "0"
> Print #1, "119"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float %"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Q Prio"
> Print #1, "2"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "2"
> Print #1, "13"
> Print #1, "N"
> Print #1, "N"
> Print #1, "2"
> Print #1, "5"
> Print #1, "2"
> Print #1, "18"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Q Prio"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Float Cycle"
> Print #1, "3"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "3"
> Print #1, "14"
> Print #1, "N"
> Print #1, "N"
> Print #1, "3"
> Print #1, "5"
> Print #1, "2"
> Print #1, "30"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Float Cycle"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Rpt"
> Print #1, "7"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "C"
> Print #1, "0"
> Print #1, "7"
> Print #1, "1"
> Print #1, "N"
> Print #1, "N"
> Print #1, "7"
> Print #1, "0"
> Print #1, "0"
> Print #1, "0"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Rpt"
> Print #1, "3"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~TableField"
> Print #1, "Date"
> Print #1, "8"
> Print #1, "0"
> Print #1, "0"
> Print #1, "1"
> Print #1, "D"
> Print #1, "0"
> Print #1, "12"
> Print #1, "2"
> Print #1, "N"
> Print #1, "N"
> Print #1, "14"
> Print #1, "0"
> Print #1, "0"
> Print #1, "107"
> Print #1, "N"
> Print #1, "~TableFieldExtended"
> Print #1, "Date"
> Print #1, "3"
> Print #1, "N"
> Print #1, "1"
> Print #1, "1"
> Print #1, "~Level"
> Print #1, "0"
> Print #1, ""
> Print #1, "1"
> Print #1, "CD-1291 1108/ AVAILABLE FUNDS ACCOUNT DATA
FIRST PREMIER BANK -FD- 01/09/04 PAGE 1
"
> Print #1, "2"
> Print #1, "0"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~LevelExtended"
> Print #1, "0"
> Print #1, "2"
> Print #1, "Page Header"
> Print #1, "N"
> Print #1, "N"
> Print #1, "~Level"
> Print #1, "5"
> Print #1, ""
> Print #1, "3"
> Print #1, "5149860001000015 2004/01/09 5.00
5.00 0002 0009 0001 0000 0000 100
"
> Print #1, " QUEUE PRIO FLOAT CYCL
"
> Print #1, " 00 011
"
> Print #1, "12"
> Print #1, "0"
> Print #1, "N"
> Print #1, "0"
> Print #1, "0"
> Print #1, "~LevelExtended"
> Print #1, "5"
> Print #1, "2"
> Print #1, "Detail"
> Print #1, "N"
> Print #1, "N"
> Print #1, "~PageSetup"
> Print #1, "1"
> Print #1, "256"
> Print #1, "10"
> Print #1, "50"
> Print #1, "50"
> Print #1, "2"
> Print #1, "Y"
> Print #1, "Y"
> Print #1, "Y"
> Print #1, ""
> Print #1, "~PageSetupExtended"
> Print #1, "1"
> Print #1, "Y"
> Print #1, "~End"
> Close #1
>
> '''PRJ
> Open p & "\CD1291.prj" For Output As #1
> Print #1, "MFWPRJ01"
> Print #1, "[RefreshDDR]"
> Print #1, "[InputFile]"
> Print #1, p & "\CD1291.RPT"
> Print #1, "[ModelFile]"
> Print #1, p & "\CD1291.mod"
> Print #1, "[ViewTable]"
> Print #1, "[SummaryNoChart]"
> Print #1, "[Author]"
> Print #1, "[Description]"
> Print #1, "[ASCII]"
> Print #1, "[End]"
> Close #1
>
> ''' BAT
> Open p & "\CD1291.bat" For Output As #1
> Print #1, "@.echo off"
> Print #1, "copy " & p & "\CD1291.TMP " & p & "\CD1291.RPT"
> Print #1, "del " & p & "\CD1291.TMP"
> Close #1
> '''Execute
> Do Until Dir(p & "\CD1291.TMP") <> "" Or Dir(p & "\CD1291.RPT") <> ""
> Shell ("C:\Program Files\Mobius\DDR\rdswin.exe " & p & "\CD1291.msl
/E")
> Pause (30)
> Loop
> Do Until Dir(p & "\CD1291.TMP") = ""
> DoEvents
> Loop
> Pause (5)
> If Dir("C:\CD1291.ASC") <> "" Then Kill ("C:\CD1291.ASC")
> Shell ("C:\Program Files\Mobius\DocuAnalyzer\program\analyz
er.exe " & p &
"\CD1291.prj " & p & "\CD1291.ASC")
> Pause (5)
> L1 = 1
> Do Until L1 = L2
> Open p & "\CD1291.ASC" For Random As #1
> L1 = LOF(1)
> Close #1
> Pause (5)
> Open p & "\CD1291.ASC" For Random As #1
> L2 = LOF(1)
> Close #1
> Loop
> Pause (5)
>
> If Dir(p & "\CD1291.msl") <> "" Then Kill (p & "\CD1291.msl")
> If Dir(p & "\CD1291.bat") <> "" Then Kill (p & "\CD1291.bat")
> If Dir(p & "\CD1291.mod") <> "" Then Kill (p & "\CD1291.mod")
> If Dir(p & "\CD1291.prj") <> "" Then Kill (p & "\CD1291.prj")
> If Dir(p & "\CD1291.RPT") <> "" Then Kill (p & "\CD1291.RPT")
> If Dir(p & "\CD1291.TMP") <> "" Then Kill (p & "\CD1291.TMP")
>
> End Function
>
>

ActiveX Script Running DTS Causes Error

Hello All,

I have an ActiveX script that runs DTS pachkages. In the event that a package fails I want to display the error message. I found the following code (in bold) for doing this but I keep getting an error message as follows.

Type mismatch 'oSoStep.GetExecutionErrorInfo'

All help appreciated.

Thanks, Gary

Could you post your code?
Jason
|||For Each oStep In oPkg.Steps
If oStep.ExecutionStatus = DTSStepExecStat_Completed Then
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
oStep.GetExecutionErrorInfo lErrNum, sSource, sDescr
msgbox(sDescr)
End If
End If
Next

Sunday, March 11, 2012

Active / passive in SQL 7

A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to
upgrade to SQL 2005. I want to know how he can do the below with SQL
7?
His message:
That feature, available with the SQL Server7 Enterprise, would allow
my passive node to startup the database without any DBA involvement.
Right now my cluster simply fails over, but SQL7 does not
automatically activate on the passive node once the shared disk is
available. This is because the passive node only checks for the
presence of the disk drive at bootup. Hence, it does not start the
service when the disk is available after a fail-over.
At the end of the day, I would be running the same database in the
same manner, with no licensing implications because I have not changed
the availability or seat count; I would merely have the second node
fire up after it detects the availability of the shared disk where the
program and data files reside.
Thanks
Buy new hardware and migrate! How old is the equipment running SQL 7?
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"David Sherman" <dshermin@.ameritech.net> wrote in message
news:e7jmu1hk54lfb1i126lrs35dknv2dtk12r@.4ax.com...
>A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to
> upgrade to SQL 2005. I want to know how he can do the below with SQL
> 7?
> His message:
>
> That feature, available with the SQL Server7 Enterprise, would allow
> my passive node to startup the database without any DBA involvement.
> Right now my cluster simply fails over, but SQL7 does not
> automatically activate on the passive node once the shared disk is
> available. This is because the passive node only checks for the
> presence of the disk drive at bootup. Hence, it does not start the
> service when the disk is available after a fail-over.
> At the end of the day, I would be running the same database in the
> same manner, with no licensing implications because I have not changed
> the availability or seat count; I would merely have the second node
> fire up after it detects the availability of the shared disk where the
> program and data files reside.
> Thanks
|||I have tried to get him to buy new equipment. The equipment is about 6
years old.
On Thu, 9 Feb 2006 09:20:26 -0600, "Rodney R. Fournier [MVP]"
<rod@.die.spam.die.nw-america.com> wrote:

>Buy new hardware and migrate! How old is the equipment running SQL 7?
>Cheers,
>Rodney R. Fournier
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering Website
>http://www.msmvps.com/clustering - Blog
>http://www.clusterhelp.com - Cluster Training
>ClusterHelp.com is a Microsoft Certified Gold Partner
>
>"David Sherman" <dshermin@.ameritech.net> wrote in message
>news:e7jmu1hk54lfb1i126lrs35dknv2dtk12r@.4ax.com.. .
>
|||The first thing you have to check is whether the hardware is even supported
for SQL Server 2005. Secondly, unless Enterprise Edition is installed, you
aren't going to get SQL Server 2005 into a failover cluster.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"David Sherman" <dshermin@.ameritech.net> wrote in message
news:e7jmu1hk54lfb1i126lrs35dknv2dtk12r@.4ax.com...
>A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to
> upgrade to SQL 2005. I want to know how he can do the below with SQL
> 7?
> His message:
>
> That feature, available with the SQL Server7 Enterprise, would allow
> my passive node to startup the database without any DBA involvement.
> Right now my cluster simply fails over, but SQL7 does not
> automatically activate on the passive node once the shared disk is
> available. This is because the passive node only checks for the
> presence of the disk drive at bootup. Hence, it does not start the
> service when the disk is available after a fail-over.
> At the end of the day, I would be running the same database in the
> same manner, with no licensing implications because I have not changed
> the availability or seat count; I would merely have the second node
> fire up after it detects the availability of the shared disk where the
> program and data files reside.
> Thanks
|||Thanks for the infomation.
Is there a way to write a script that monitors the active node and
when it dies (1) notifies the DBA of the failure and (2) starts the
passive node. or (3) is there a package that will do this?
thanks
On Thu, 9 Feb 2006 10:29:31 -0600, "Michael Hotek"
<mike@.solidqualitylearning.com> wrote:

>The first thing you have to check is whether the hardware is even supported
>for SQL Server 2005. Secondly, unless Enterprise Edition is installed, you
>aren't going to get SQL Server 2005 into a failover cluster.
>--
>Mike
>http://www.solidqualitylearning.com
>Disclaimer: This communication is an original work and represents my sole
>views on the subject. It does not represent the views of any other person
>or entity either by inference or direct reference.
>
>"David Sherman" <dshermin@.ameritech.net> wrote in message
>news:e7jmu1hk54lfb1i126lrs35dknv2dtk12r@.4ax.com.. .
>
|||The package is called "Failover Clustering" and is a built-in feature of SQL
2000 Enterprise Edition and SQL 2005 Enterprise and Standard Editions.
Windows 2000/2003 Enterprise Edition is also required.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David Sherman" <dshermin@.ameritech.net> wrote in message
news:nvtmu11ik9jpnf2i7nlrhf6ppq0f64nqbd@.4ax.com...
> Thanks for the infomation.
> Is there a way to write a script that monitors the active node and
> when it dies (1) notifies the DBA of the failure and (2) starts the
> passive node. or (3) is there a package that will do this?
> thanks
>
> On Thu, 9 Feb 2006 10:29:31 -0600, "Michael Hotek"
> <mike@.solidqualitylearning.com> wrote:
>
|||Thanks for the update.
I know he has 2005 Standard. He needs to get the CALS that he needs.
thanks again.
On Thu, 9 Feb 2006 14:01:04 -0500, "Geoff N. Hiten"
<SQLCraftsman@.gmail.com> wrote:

>The package is called "Failover Clustering" and is a built-in feature of SQL
>2000 Enterprise Edition and SQL 2005 Enterprise and Standard Editions.
>Windows 2000/2003 Enterprise Edition is also required.
|||According to this link:
http://www.databasejournal.com/featu...le.php/3444181
Failover clustering has been supported since SQL Server 7.0 so it is
not surprising that its latest implementation is a combination of
already familiar (and stable) technology with a number of useful ...
How does one use Failover Clustering withe Windows 2000 Advanced
server and SQL 7?
thanks again.
On Thu, 9 Feb 2006 14:01:04 -0500, "Geoff N. Hiten"
<SQLCraftsman@.gmail.com> wrote:

>The package is called "Failover Clustering" and is a built-in feature of SQL
>2000 Enterprise Edition and SQL 2005 Enterprise and Standard Editions.
>Windows 2000/2003 Enterprise Edition is also required.

Thursday, March 8, 2012

ACT Premium 2008

Hi all I have a question, has anyone tried the new ACT Premium 2008 apparently it runs off of SQL Server and can support 31-50 Users.
Has anyone tried it??
We are trying to get rid of Access and have a database that has a customizeable front end and will run off SQL Server 2005Nope, sorry, we build custom solutions

http://www.act.com/2008/system/|||So do you guys have a website??|||Act! and GoldMine are very similar products, and are CRM solutions. But the drawback to both programs is a highly propietary system, which limits reporting to canned reports and the application itself. Integrating Act! requires a lot of consulting work, as massaging the data in isn't as easy as it could be because the table structures are not clearly defined. Most companies pay a lot of money to consultants who specialize in these two products because of it's complexity.

Act! does work on SQL, but making sense of what it's all doing requires a lot of training.

There are CRM solutions that are easier to administer and maintain, like Siebel Sales and Microsoft's own CRM, and a lot more support for those products in an enterprise environment. If you have 31-50 users, you'll want to aim high in your steering and look at the bigger picture. An unhappy sales staff is detrimental to your business as a whole, and the learning curve with both Act! and Goldmine client side is a big step that can cause a lot of headaches.|||So do you guys have a website??

http://www.prudential.com

However most of the apps we write are intranet...but it's a world wide intranet

the last one might exposed..I have to check|||That would be the back end what we are trying to do is have a front end thats user friendly and some what customizeable without allot of programming. A web interface would be nice but optional. We are trying to get off the ADP'S (Ms Access as front end)

Thats we were looking at ACT Premium 2008

You mentioned Microsoft's CRM's?? Whats the names of them|||http://www.microsoft.com/dynamics/crm/default.mspx|||I've used ACT in the past but not the 2008 version. It's a nice CRM but as Liebling mentioned, it has a propietary database. If the 2008 version is SQL Server based, my guess (from ACT's track record) is that it's probably designed so it's difficult to decipher the database and easily merge it with other databases (just guessing from working with ACT in the past.) If the 2008 SQL Server based version is in a nice, straight-forward, relational table structure, I think it's a good product to consider (and as Liebling also mentioned, Goldmine is another consideration.) ACT is still a CRM though and I've designed similar CRM programs (SQL Server based) which satisfied the needs of the company even though they didn't have all the features ACT did. If you need all the features of a CRM, I would consider some of the options Liebling gave. If you don't need all the features, you might want to consider designing your own CRM which will most likely offer you a lot more flexibility on design and also with merging with your other databases.

The CRM I designed was in an MSAccess mdb front-end (with SQL Server back-end tables linked into the mdb). We used Citrix for external connections and it worked extremely well. I designed the Forms in Access for the CRM unbound (so it was lightning fast with over 2 million records.) I liked this setup because Access offered the benefits of flexibility, ease of design, and ability to quickly create/modify the front-end interface (Access ADP's are more difficult to work with and take twice as long to develop verses an Access mdb file.) Having SQL Server as the back-end avoided the restrictions MSAccess tables have and MSAccess has the ability to design some really great reports (in my opinion - I think MSAccess reports are easier and quicker to design (again - mdb) verses any other program and comparable to Crystal Reports.) But again, this is in an mdb file with SQL Server linked tables. An ADP is more difficult to work with and you don't have the benefit of creating quick, easy queries like you do with an mdb.

Before you get rid of Access, you may want to consider designing mdb files with linked SQL Server tables verses ADP's. I designed the entire midwest Energy Conservation programs in Access mdb's (front-end) and SQL Server linked tables (over 5 million records in all the db's.) All the problems you read about with Access are due to having Access tables in a multi-user environment and large recordsets. If you utilize mdb's and SQL Server linked tables, those problems go away. Also, utilizing unbound forms in an mdb and writing functions to retrieve, write/update, and delete records is basically the same as an ADP but easier to work with (and you also have the power of designing Access queries very quickly). If you design your unbound forms this way, Access is really no different than any other programming tool (except that it's easier!) I was the Manager of the Database Applications department and looked at the ease of designing, modifying, and maintaining the system verses purchasing a 3rd party application which still needed customization (or designing in another front-end language). Developing new Energy Conservation programs happened very fast with Access as the front-end (I would start with Access tables and the upsizing wizard of Access tables to SQL Server tables works very well.) I'm not sure as to why you've decided to do away with Access but if you're designing ADP's, I wouldn't judge Access based on them. ADP's are simply not easy to work with and you can accomplish the same thing with unbound forms in an mdb. Even bound forms in an mdb works very well if designed correctly and is really no different than designing forms in other programming tools. I designed some of the large SQL Server tables with bound forms in mdb's which performed better than those developed in other languages.

Saturday, February 25, 2012

Account under SQL Server

How do I know which account under which the SQL Server 2000 runs ?On Enterprise Manager, select your server, right-click, Properties and
Security tab.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> How do I know which account under which the SQL Server 2000 runs ?
>
>|||Hi Ben,
I am asking this question because I still stuck in my full-text search
problem.
I tried to do many thing to get around it like to change user account to
start up SQLServer.
I just posted a thread regarding changing the account start up the
SQLServer, if you can help me that would be great.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> On Enterprise Manager, select your server, right-click, Properties and
> Security tab.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > How do I know which account under which the SQL Server 2000 runs ?
> >
> >
> >|||Full-Text Search is another Windows service. What is the problem?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Hi Ben,
> I am asking this question because I still stuck in my full-text search
> problem.
> I tried to do many thing to get around it like to change user account to
> start up SQLServer.
> I just posted a thread regarding changing the account start up the
> SQLServer, if you can help me that would be great.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> >
> > On Enterprise Manager, select your server, right-click, Properties and
> > Security tab.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > How do I know which account under which the SQL Server 2000 runs ?
> > >
> > >
> > >
>
>|||I created a catalog in SQL Server 2000 but cannot get results from this
catalog by issuing the SQL with CONTAINS. It just return empty set with
headers only.
The status of the catalog is always idle even after full population.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> Full-Text Search is another Windows service. What is the problem?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Hi Ben,
> >
> > I am asking this question because I still stuck in my full-text search
> > problem.
> > I tried to do many thing to get around it like to change user account to
> > start up SQLServer.
> > I just posted a thread regarding changing the account start up the
> > SQLServer, if you can help me that would be great.
> >
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > >
> > > On Enterprise Manager, select your server, right-click, Properties and
> > > Security tab.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > How do I know which account under which the SQL Server 2000 runs ?
> > > >
> > > >
> > > >
> >
> >
> >|||Probably Full-Text Search is running as System Local and has no permissions
to SQL Server. Try running the Full-Text Search using the same service
account as SQL Server. This time use the Control Panel / Services applet. The
service must be named MSSearch or something similar.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> I created a catalog in SQL Server 2000 but cannot get results from this
> catalog by issuing the SQL with CONTAINS. It just return empty set with
> headers only.
> The status of the catalog is always idle even after full population.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> >
> > Full-Text Search is another Windows service. What is the problem?
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > Hi Ben,
> > >
> > > I am asking this question because I still stuck in my full-text search
> > > problem.
> > > I tried to do many thing to get around it like to change user account to
> > > start up SQLServer.
> > > I just posted a thread regarding changing the account start up the
> > > SQLServer, if you can help me that would be great.
> > >
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > >
> > > > On Enterprise Manager, select your server, right-click, Properties and
> > > > Security tab.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > How do I know which account under which the SQL Server 2000 runs ?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Hi Ben,
I go to EM, right click my server instance, select the "Edit Registered SQL
Server Properties" knowing that I checked the
"Use SQL Server authentication".
Am I going to use that account in the Control Panel - Services ?
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> Probably Full-Text Search is running as System Local and has no
permissions
> to SQL Server. Try running the Full-Text Search using the same service
> account as SQL Server. This time use the Control Panel / Services applet.
The
> service must be named MSSearch or something similar.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > I created a catalog in SQL Server 2000 but cannot get results from this
> > catalog by issuing the SQL with CONTAINS. It just return empty set with
> > headers only.
> > The status of the catalog is always idle even after full population.
> >
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > >
> > > Full-Text Search is another Windows service. What is the problem?
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > Hi Ben,
> > > >
> > > > I am asking this question because I still stuck in my full-text
search
> > > > problem.
> > > > I tried to do many thing to get around it like to change user
account to
> > > > start up SQLServer.
> > > > I just posted a thread regarding changing the account start up the
> > > > SQLServer, if you can help me that would be great.
> > > >
> > > >
> > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > >
> > > > > On Enterprise Manager, select your server, right-click, Properties
and
> > > > > Security tab.
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "Alan" wrote:
> > > > >
> > > > > > How do I know which account under which the SQL Server 2000 runs
?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Right-click the server and select 'Properties', follow the instructions I
already sent.
Do not select 'Edit SQL Server Registration Properties'.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Hi Ben,
> I go to EM, right click my server instance, select the "Edit Registered SQL
> Server Properties" knowing that I checked the
> "Use SQL Server authentication".
> Am I going to use that account in the Control Panel - Services ?
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> >
> > Probably Full-Text Search is running as System Local and has no
> permissions
> > to SQL Server. Try running the Full-Text Search using the same service
> > account as SQL Server. This time use the Control Panel / Services applet.
> The
> > service must be named MSSearch or something similar.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > I created a catalog in SQL Server 2000 but cannot get results from this
> > > catalog by issuing the SQL with CONTAINS. It just return empty set with
> > > headers only.
> > > The status of the catalog is always idle even after full population.
> > >
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > >
> > > > Full-Text Search is another Windows service. What is the problem?
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > Hi Ben,
> > > > >
> > > > > I am asking this question because I still stuck in my full-text
> search
> > > > > problem.
> > > > > I tried to do many thing to get around it like to change user
> account to
> > > > > start up SQLServer.
> > > > > I just posted a thread regarding changing the account start up the
> > > > > SQLServer, if you can help me that would be great.
> > > > >
> > > > >
> > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > >
> > > > > > On Enterprise Manager, select your server, right-click, Properties
> and
> > > > > > Security tab.
> > > > > >
> > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > Database Administrator
> > > > > >
> > > > > >
> > > > > > "Alan" wrote:
> > > > > >
> > > > > > > How do I know which account under which the SQL Server 2000 runs
> ?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Hi Ben,
A little progress, at least, in EM, the catalog is in recovering status.
What I did was:
1) Goto edit SQL Server registration info
2) My account in SQL Server is 'alan', this is just the login for SQL
Server, so I changed to Windows Authentication
3) Then goto Control Panel - Services - Microsoft Search
4) Double click
5) LogOn tab
6) I change to use my Windows machine login, ie 'Alan Tse'.
This 'Alan Tse' is the login that I use to login to my pc everyday when
I start up my pc.
7) Click OK
8) Then I checked the Control Panel - Services - Microsoft Search, the user
is .\Alan Tse
Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> Hi Ben,
> I go to EM, right click my server instance, select the "Edit Registered
SQL
> Server Properties" knowing that I checked the
> "Use SQL Server authentication".
> Am I going to use that account in the Control Panel - Services ?
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> >
> > Probably Full-Text Search is running as System Local and has no
> permissions
> > to SQL Server. Try running the Full-Text Search using the same service
> > account as SQL Server. This time use the Control Panel / Services
applet.
> The
> > service must be named MSSearch or something similar.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > I created a catalog in SQL Server 2000 but cannot get results from
this
> > > catalog by issuing the SQL with CONTAINS. It just return empty set
with
> > > headers only.
> > > The status of the catalog is always idle even after full population.
> > >
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > >
> > > > Full-Text Search is another Windows service. What is the problem?
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > Hi Ben,
> > > > >
> > > > > I am asking this question because I still stuck in my full-text
> search
> > > > > problem.
> > > > > I tried to do many thing to get around it like to change user
> account to
> > > > > start up SQLServer.
> > > > > I just posted a thread regarding changing the account start up the
> > > > > SQLServer, if you can help me that would be great.
> > > > >
> > > > >
> > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > >
> > > > > > On Enterprise Manager, select your server, right-click,
Properties
> and
> > > > > > Security tab.
> > > > > >
> > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > Database Administrator
> > > > > >
> > > > > >
> > > > > > "Alan" wrote:
> > > > > >
> > > > > > > How do I know which account under which the SQL Server 2000
runs
> ?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>|||Hi Ben,
What account should I use on the Security Tab? Use Windows login or SQL
Server login ?
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:FCFB7F64-56BD-4C94-A87B-AC0894AA585B@.microsoft.com...
> Right-click the server and select 'Properties', follow the instructions I
> already sent.
> Do not select 'Edit SQL Server Registration Properties'.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Hi Ben,
> >
> > I go to EM, right click my server instance, select the "Edit Registered
SQL
> > Server Properties" knowing that I checked the
> > "Use SQL Server authentication".
> > Am I going to use that account in the Control Panel - Services ?
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > >
> > > Probably Full-Text Search is running as System Local and has no
> > permissions
> > > to SQL Server. Try running the Full-Text Search using the same service
> > > account as SQL Server. This time use the Control Panel / Services
applet.
> > The
> > > service must be named MSSearch or something similar.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > I created a catalog in SQL Server 2000 but cannot get results from
this
> > > > catalog by issuing the SQL with CONTAINS. It just return empty set
with
> > > > headers only.
> > > > The status of the catalog is always idle even after full population.
> > > >
> > > >
> > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > >
> > > > > Full-Text Search is another Windows service. What is the problem?
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "Alan" wrote:
> > > > >
> > > > > > Hi Ben,
> > > > > >
> > > > > > I am asking this question because I still stuck in my full-text
> > search
> > > > > > problem.
> > > > > > I tried to do many thing to get around it like to change user
> > account to
> > > > > > start up SQLServer.
> > > > > > I just posted a thread regarding changing the account start up
the
> > > > > > SQLServer, if you can help me that would be great.
> > > > > >
> > > > > >
> > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > >
> > > > > > > On Enterprise Manager, select your server, right-click,
Properties
> > and
> > > > > > > Security tab.
> > > > > > >
> > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > Database Administrator
> > > > > > >
> > > > > > >
> > > > > > > "Alan" wrote:
> > > > > > >
> > > > > > > > How do I know which account under which the SQL Server 2000
runs
> > ?
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Alan,
Read my previous messages carefully. 'Edit SQL Server Registration
Properties' do not change the service account but the account you are using
to connect.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Hi Ben,
> A little progress, at least, in EM, the catalog is in recovering status.
> What I did was:
> 1) Goto edit SQL Server registration info
> 2) My account in SQL Server is 'alan', this is just the login for SQL
> Server, so I changed to Windows Authentication
> 3) Then goto Control Panel - Services - Microsoft Search
> 4) Double click
> 5) LogOn tab
> 6) I change to use my Windows machine login, ie 'Alan Tse'.
> This 'Alan Tse' is the login that I use to login to my pc everyday when
> I start up my pc.
> 7) Click OK
> 8) Then I checked the Control Panel - Services - Microsoft Search, the user
> is .\Alan Tse
> Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
> "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> > Hi Ben,
> >
> > I go to EM, right click my server instance, select the "Edit Registered
> SQL
> > Server Properties" knowing that I checked the
> > "Use SQL Server authentication".
> > Am I going to use that account in the Control Panel - Services ?
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > >
> > > Probably Full-Text Search is running as System Local and has no
> > permissions
> > > to SQL Server. Try running the Full-Text Search using the same service
> > > account as SQL Server. This time use the Control Panel / Services
> applet.
> > The
> > > service must be named MSSearch or something similar.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > I created a catalog in SQL Server 2000 but cannot get results from
> this
> > > > catalog by issuing the SQL with CONTAINS. It just return empty set
> with
> > > > headers only.
> > > > The status of the catalog is always idle even after full population.
> > > >
> > > >
> > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > >
> > > > > Full-Text Search is another Windows service. What is the problem?
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "Alan" wrote:
> > > > >
> > > > > > Hi Ben,
> > > > > >
> > > > > > I am asking this question because I still stuck in my full-text
> > search
> > > > > > problem.
> > > > > > I tried to do many thing to get around it like to change user
> > account to
> > > > > > start up SQLServer.
> > > > > > I just posted a thread regarding changing the account start up the
> > > > > > SQLServer, if you can help me that would be great.
> > > > > >
> > > > > >
> > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > >
> > > > > > > On Enterprise Manager, select your server, right-click,
> Properties
> > and
> > > > > > > Security tab.
> > > > > > >
> > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > Database Administrator
> > > > > > >
> > > > > > >
> > > > > > > "Alan" wrote:
> > > > > > >
> > > > > > > > How do I know which account under which the SQL Server 2000
> runs
> > ?
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
>
>|||Hi Ben,
My machine name is 'ATSE', windows login is 'Alan Tse'.
What I did again:
1) Goto EM, right click the server instance, select properties
2) On Security tab
3) Check Windows authentication
4) On Startup service account groupbox, select the 'This account", fill in
ATSE\Alan Tse with password.
5) An error comes up saying Logon failure: unkown user name or bad password.
I am not understand why I got this error, I double checked in the EM that I
actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
the login I use everytime I start up my pc.
I think you gave me guidances very near the solution.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> Alan,
> Read my previous messages carefully. 'Edit SQL Server Registration
> Properties' do not change the service account but the account you are
using
> to connect.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Hi Ben,
> >
> > A little progress, at least, in EM, the catalog is in recovering status.
> > What I did was:
> > 1) Goto edit SQL Server registration info
> > 2) My account in SQL Server is 'alan', this is just the login for SQL
> > Server, so I changed to Windows Authentication
> > 3) Then goto Control Panel - Services - Microsoft Search
> > 4) Double click
> > 5) LogOn tab
> > 6) I change to use my Windows machine login, ie 'Alan Tse'.
> > This 'Alan Tse' is the login that I use to login to my pc everyday
when
> > I start up my pc.
> > 7) Click OK
> > 8) Then I checked the Control Panel - Services - Microsoft Search, the
user
> > is .\Alan Tse
> >
> > Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
> >
> > "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> > news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> > > Hi Ben,
> > >
> > > I go to EM, right click my server instance, select the "Edit
Registered
> > SQL
> > > Server Properties" knowing that I checked the
> > > "Use SQL Server authentication".
> > > Am I going to use that account in the Control Panel - Services ?
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > > >
> > > > Probably Full-Text Search is running as System Local and has no
> > > permissions
> > > > to SQL Server. Try running the Full-Text Search using the same
service
> > > > account as SQL Server. This time use the Control Panel / Services
> > applet.
> > > The
> > > > service must be named MSSearch or something similar.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > I created a catalog in SQL Server 2000 but cannot get results
from
> > this
> > > > > catalog by issuing the SQL with CONTAINS. It just return empty set
> > with
> > > > > headers only.
> > > > > The status of the catalog is always idle even after full
population.
> > > > >
> > > > >
> > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > > >
> > > > > > Full-Text Search is another Windows service. What is the
problem?
> > > > > >
> > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > Database Administrator
> > > > > >
> > > > > >
> > > > > > "Alan" wrote:
> > > > > >
> > > > > > > Hi Ben,
> > > > > > >
> > > > > > > I am asking this question because I still stuck in my
full-text
> > > search
> > > > > > > problem.
> > > > > > > I tried to do many thing to get around it like to change user
> > > account to
> > > > > > > start up SQLServer.
> > > > > > > I just posted a thread regarding changing the account start up
the
> > > > > > > SQLServer, if you can help me that would be great.
> > > > > > >
> > > > > > >
> > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > > >
> > > > > > > > On Enterprise Manager, select your server, right-click,
> > Properties
> > > and
> > > > > > > > Security tab.
> > > > > > > >
> > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > Database Administrator
> > > > > > > >
> > > > > > > >
> > > > > > > > "Alan" wrote:
> > > > > > > >
> > > > > > > > > How do I know which account under which the SQL Server
2000
> > runs
> > > ?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
> >|||If this is a local account just type .\Alan Tse
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Hi Ben,
> My machine name is 'ATSE', windows login is 'Alan Tse'.
> What I did again:
> 1) Goto EM, right click the server instance, select properties
> 2) On Security tab
> 3) Check Windows authentication
> 4) On Startup service account groupbox, select the 'This account", fill in
> ATSE\Alan Tse with password.
> 5) An error comes up saying Logon failure: unkown user name or bad password.
> I am not understand why I got this error, I double checked in the EM that I
> actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
> the login I use everytime I start up my pc.
> I think you gave me guidances very near the solution.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> >
> > Alan,
> >
> > Read my previous messages carefully. 'Edit SQL Server Registration
> > Properties' do not change the service account but the account you are
> using
> > to connect.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > Hi Ben,
> > >
> > > A little progress, at least, in EM, the catalog is in recovering status.
> > > What I did was:
> > > 1) Goto edit SQL Server registration info
> > > 2) My account in SQL Server is 'alan', this is just the login for SQL
> > > Server, so I changed to Windows Authentication
> > > 3) Then goto Control Panel - Services - Microsoft Search
> > > 4) Double click
> > > 5) LogOn tab
> > > 6) I change to use my Windows machine login, ie 'Alan Tse'.
> > > This 'Alan Tse' is the login that I use to login to my pc everyday
> when
> > > I start up my pc.
> > > 7) Click OK
> > > 8) Then I checked the Control Panel - Services - Microsoft Search, the
> user
> > > is .\Alan Tse
> > >
> > > Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
> > >
> > > "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> > > news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> > > > Hi Ben,
> > > >
> > > > I go to EM, right click my server instance, select the "Edit
> Registered
> > > SQL
> > > > Server Properties" knowing that I checked the
> > > > "Use SQL Server authentication".
> > > > Am I going to use that account in the Control Panel - Services ?
> > > >
> > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > > > >
> > > > > Probably Full-Text Search is running as System Local and has no
> > > > permissions
> > > > > to SQL Server. Try running the Full-Text Search using the same
> service
> > > > > account as SQL Server. This time use the Control Panel / Services
> > > applet.
> > > > The
> > > > > service must be named MSSearch or something similar.
> > > > >
> > > > > Ben Nevarez, MCDBA, OCP
> > > > > Database Administrator
> > > > >
> > > > >
> > > > > "Alan" wrote:
> > > > >
> > > > > > I created a catalog in SQL Server 2000 but cannot get results
> from
> > > this
> > > > > > catalog by issuing the SQL with CONTAINS. It just return empty set
> > > with
> > > > > > headers only.
> > > > > > The status of the catalog is always idle even after full
> population.
> > > > > >
> > > > > >
> > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > > > >
> > > > > > > Full-Text Search is another Windows service. What is the
> problem?
> > > > > > >
> > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > Database Administrator
> > > > > > >
> > > > > > >
> > > > > > > "Alan" wrote:
> > > > > > >
> > > > > > > > Hi Ben,
> > > > > > > >
> > > > > > > > I am asking this question because I still stuck in my
> full-text
> > > > search
> > > > > > > > problem.
> > > > > > > > I tried to do many thing to get around it like to change user
> > > > account to
> > > > > > > > start up SQLServer.
> > > > > > > > I just posted a thread regarding changing the account start up
> the
> > > > > > > > SQLServer, if you can help me that would be great.
> > > > > > > >
> > > > > > > >
> > > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > > > >
> > > > > > > > > On Enterprise Manager, select your server, right-click,
> > > Properties
> > > > and
> > > > > > > > > Security tab.
> > > > > > > > >
> > > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > > Database Administrator
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Alan" wrote:
> > > > > > > > >
> > > > > > > > > > How do I know which account under which the SQL Server
> 2000
> > > runs
> > > > ?
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||Alan,
I need to leave. You should have all the instructions on these messages.
Good luck.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
> If this is a local account just type .\Alan Tse
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Hi Ben,
> >
> > My machine name is 'ATSE', windows login is 'Alan Tse'.
> > What I did again:
> > 1) Goto EM, right click the server instance, select properties
> > 2) On Security tab
> > 3) Check Windows authentication
> > 4) On Startup service account groupbox, select the 'This account", fill in
> > ATSE\Alan Tse with password.
> > 5) An error comes up saying Logon failure: unkown user name or bad password.
> >
> > I am not understand why I got this error, I double checked in the EM that I
> > actully have this login. This is the domain\user. This 'ATSE\Alan Tse' is
> > the login I use everytime I start up my pc.
> >
> > I think you gave me guidances very near the solution.
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> > >
> > > Alan,
> > >
> > > Read my previous messages carefully. 'Edit SQL Server Registration
> > > Properties' do not change the service account but the account you are
> > using
> > > to connect.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > Hi Ben,
> > > >
> > > > A little progress, at least, in EM, the catalog is in recovering status.
> > > > What I did was:
> > > > 1) Goto edit SQL Server registration info
> > > > 2) My account in SQL Server is 'alan', this is just the login for SQL
> > > > Server, so I changed to Windows Authentication
> > > > 3) Then goto Control Panel - Services - Microsoft Search
> > > > 4) Double click
> > > > 5) LogOn tab
> > > > 6) I change to use my Windows machine login, ie 'Alan Tse'.
> > > > This 'Alan Tse' is the login that I use to login to my pc everyday
> > when
> > > > I start up my pc.
> > > > 7) Click OK
> > > > 8) Then I checked the Control Panel - Services - Microsoft Search, the
> > user
> > > > is .\Alan Tse
> > > >
> > > > Are SQL Server and Microsoft Search using the same login, .\Alan Tse?
> > > >
> > > > "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> > > > news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> > > > > Hi Ben,
> > > > >
> > > > > I go to EM, right click my server instance, select the "Edit
> > Registered
> > > > SQL
> > > > > Server Properties" knowing that I checked the
> > > > > "Use SQL Server authentication".
> > > > > Am I going to use that account in the Control Panel - Services ?
> > > > >
> > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > > > > >
> > > > > > Probably Full-Text Search is running as System Local and has no
> > > > > permissions
> > > > > > to SQL Server. Try running the Full-Text Search using the same
> > service
> > > > > > account as SQL Server. This time use the Control Panel / Services
> > > > applet.
> > > > > The
> > > > > > service must be named MSSearch or something similar.
> > > > > >
> > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > Database Administrator
> > > > > >
> > > > > >
> > > > > > "Alan" wrote:
> > > > > >
> > > > > > > I created a catalog in SQL Server 2000 but cannot get results
> > from
> > > > this
> > > > > > > catalog by issuing the SQL with CONTAINS. It just return empty set
> > > > with
> > > > > > > headers only.
> > > > > > > The status of the catalog is always idle even after full
> > population.
> > > > > > >
> > > > > > >
> > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > > > > >
> > > > > > > > Full-Text Search is another Windows service. What is the
> > problem?
> > > > > > > >
> > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > Database Administrator
> > > > > > > >
> > > > > > > >
> > > > > > > > "Alan" wrote:
> > > > > > > >
> > > > > > > > > Hi Ben,
> > > > > > > > >
> > > > > > > > > I am asking this question because I still stuck in my
> > full-text
> > > > > search
> > > > > > > > > problem.
> > > > > > > > > I tried to do many thing to get around it like to change user
> > > > > account to
> > > > > > > > > start up SQLServer.
> > > > > > > > > I just posted a thread regarding changing the account start up
> > the
> > > > > > > > > SQLServer, if you can help me that would be great.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > > > news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > > > > >
> > > > > > > > > > On Enterprise Manager, select your server, right-click,
> > > > Properties
> > > > > and
> > > > > > > > > > Security tab.
> > > > > > > > > >
> > > > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > > > Database Administrator
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Alan" wrote:
> > > > > > > > > >
> > > > > > > > > > > How do I know which account under which the SQL Server
> > 2000
> > > > runs
> > > > > ?
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi Ben,
Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the MSSQL
Server service and SQLAgent service.
Then execute the T-SQL to add to a sysadmin role
exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
and
select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
showing sysadmin is 1.
But the catalog still idle and not populated.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:69236D8A-C417-4D82-8B51-FB9E3FCCDEAA@.microsoft.com...
> Alan,
> I need to leave. You should have all the instructions on these messages.
> Good luck.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Ben Nevarez" wrote:
> >
> > If this is a local account just type .\Alan Tse
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > Hi Ben,
> > >
> > > My machine name is 'ATSE', windows login is 'Alan Tse'.
> > > What I did again:
> > > 1) Goto EM, right click the server instance, select properties
> > > 2) On Security tab
> > > 3) Check Windows authentication
> > > 4) On Startup service account groupbox, select the 'This account",
fill in
> > > ATSE\Alan Tse with password.
> > > 5) An error comes up saying Logon failure: unkown user name or bad
password.
> > >
> > > I am not understand why I got this error, I double checked in the EM
that I
> > > actully have this login. This is the domain\user. This 'ATSE\Alan Tse'
is
> > > the login I use everytime I start up my pc.
> > >
> > > I think you gave me guidances very near the solution.
> > >
> > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > news:B8082948-C346-4110-9A36-5340F21D6A38@.microsoft.com...
> > > >
> > > > Alan,
> > > >
> > > > Read my previous messages carefully. 'Edit SQL Server Registration
> > > > Properties' do not change the service account but the account you
are
> > > using
> > > > to connect.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > Hi Ben,
> > > > >
> > > > > A little progress, at least, in EM, the catalog is in recovering
status.
> > > > > What I did was:
> > > > > 1) Goto edit SQL Server registration info
> > > > > 2) My account in SQL Server is 'alan', this is just the login for
SQL
> > > > > Server, so I changed to Windows Authentication
> > > > > 3) Then goto Control Panel - Services - Microsoft Search
> > > > > 4) Double click
> > > > > 5) LogOn tab
> > > > > 6) I change to use my Windows machine login, ie 'Alan Tse'.
> > > > > This 'Alan Tse' is the login that I use to login to my pc
everyday
> > > when
> > > > > I start up my pc.
> > > > > 7) Click OK
> > > > > 8) Then I checked the Control Panel - Services - Microsoft Search,
the
> > > user
> > > > > is .\Alan Tse
> > > > >
> > > > > Are SQL Server and Microsoft Search using the same login, .\Alan
Tse?
> > > > >
> > > > > "Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> > > > > news:OA0$IAHhGHA.4864@.TK2MSFTNGP03.phx.gbl...
> > > > > > Hi Ben,
> > > > > >
> > > > > > I go to EM, right click my server instance, select the "Edit
> > > Registered
> > > > > SQL
> > > > > > Server Properties" knowing that I checked the
> > > > > > "Use SQL Server authentication".
> > > > > > Am I going to use that account in the Control Panel - Services ?
> > > > > >
> > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > news:35A07094-2665-4F64-B5F8-841D15588416@.microsoft.com...
> > > > > > >
> > > > > > > Probably Full-Text Search is running as System Local and has
no
> > > > > > permissions
> > > > > > > to SQL Server. Try running the Full-Text Search using the same
> > > service
> > > > > > > account as SQL Server. This time use the Control Panel /
Services
> > > > > applet.
> > > > > > The
> > > > > > > service must be named MSSearch or something similar.
> > > > > > >
> > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > Database Administrator
> > > > > > >
> > > > > > >
> > > > > > > "Alan" wrote:
> > > > > > >
> > > > > > > > I created a catalog in SQL Server 2000 but cannot get
results
> > > from
> > > > > this
> > > > > > > > catalog by issuing the SQL with CONTAINS. It just return
empty set
> > > > > with
> > > > > > > > headers only.
> > > > > > > > The status of the catalog is always idle even after full
> > > population.
> > > > > > > >
> > > > > > > >
> > > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > > news:39EFD002-9F27-4F56-9658-3BEBC71973AD@.microsoft.com...
> > > > > > > > >
> > > > > > > > > Full-Text Search is another Windows service. What is the
> > > problem?
> > > > > > > > >
> > > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > > Database Administrator
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Alan" wrote:
> > > > > > > > >
> > > > > > > > > > Hi Ben,
> > > > > > > > > >
> > > > > > > > > > I am asking this question because I still stuck in my
> > > full-text
> > > > > > search
> > > > > > > > > > problem.
> > > > > > > > > > I tried to do many thing to get around it like to change
user
> > > > > > account to
> > > > > > > > > > start up SQLServer.
> > > > > > > > > > I just posted a thread regarding changing the account
start up
> > > the
> > > > > > > > > > SQLServer, if you can help me that would be great.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > > > > > > > > >
news:67396273-81A5-4066-A066-8459CFB4EE3D@.microsoft.com...
> > > > > > > > > > >
> > > > > > > > > > > On Enterprise Manager, select your server,
right-click,
> > > > > Properties
> > > > > > and
> > > > > > > > > > > Security tab.
> > > > > > > > > > >
> > > > > > > > > > > Ben Nevarez, MCDBA, OCP
> > > > > > > > > > > Database Administrator
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "Alan" wrote:
> > > > > > > > > > >
> > > > > > > > > > > > How do I know which account under which the SQL
Server
> > > 2000
> > > > > runs
> > > > > > ?
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||Alan wrote:
> Hi Ben,
> Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the MSSQL
> Server service and SQLAgent service.
> Then execute the T-SQL to add to a sysadmin role
> exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
> and
> select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
> showing sysadmin is 1.
> But the catalog still idle and not populated.
>
Hi Alan
Could this article has something to do with your problem :
http://support.microsoft.com/kb/317746/
It's mentioned in the link I send you in another thread regarding your
account change problems.
--
Regards
Steen Schlüter Persson
DBA|||Hi Steen,
I found the NT Authority\System is already in SQL Server "Security ->
Logins".
I executed the T-SQL from the article and repopulated the Catalog again, the
status is still idle after refresh. The item count is 0.
By the way, where is the event log stored so that I can look at that?
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:OMIPHiUhGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Alan wrote:
> > Hi Ben,
> > Now I can use my local account, ATSE\Alan Tse as 'Log On As' in the
MSSQL
> > Server service and SQLAgent service.
> > Then execute the T-SQL to add to a sysadmin role
> > exec sp_addsrvrolemember N'ATSE\Alan Tse', sysadmin
> > and
> > select * from master.dbo.syslogins where loginname = N'ATSE\Alan Tse'
> > showing sysadmin is 1.
> >
> > But the catalog still idle and not populated.
> >
> Hi Alan
> Could this article has something to do with your problem :
> http://support.microsoft.com/kb/317746/
> It's mentioned in the link I send you in another thread regarding your
> account change problems.
> --
> Regards
> Steen Schlüter Persson
> DBA

Sunday, March 25, 2012

ActiveX Script Task - Help!

ActiveX Script Task - Help!

ActiveX Script Running DTS Causes Error

Sunday, March 11, 2012

Active / passive in SQL 7

Thursday, March 8, 2012

ACT Premium 2008

Saturday, February 25, 2012

Account under SQL Server

Account under SQL Server

SQL,access denied

Blog Archive

About Me