Login Failed Error in ActiveX script in DTS!

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi

I have one ActiveX Script task and VB script written in it is :


Function Main()
dim SQLConn
dim Sql
dim RS
set SQLConn = CreateObject("ADODB.Connection")
RS = DTSGlobalVariables("SEASON").value

SQLConn.Open = "Provider=SQLOLEDB.1;Data Source=(local); _Initial
Catalog=SuppPaymentSubscription;user id = 'Domain\P10825';password =
'password'"

Sql="EXEC SuppPaymentSubscription.[dbo].uspSeason " &
DTSGlobalVariables("SEASON").value
SQLConn.Execute Sql
Main = DTSStepScriptResult_ExecuteTask

End Function

When executing the SQL Package getting Following error msg:

Invalid Connection string.

Login Failed for User.....

I have given access on all db objects to user 'Domain\P10825'.

But When I provide user id='sa'; password = 'password', it is working
fine....

Why is it so???
What is the reason and resolution for this????
What are the permissions required for login???

Any help is appreciated.
Thanks in advance.
Ajmera
.

Relevant Pages

  • Re: Which identity?
    ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features? ... Another way to do it if using the .AddNew method on a Jet based ADO ... Dim rsTest As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance von SQL-Abfragen auf Exceltabellen
    ... Nun habe ich es mit SQL auf Exceldaten versucht und konnte das ganze ... Performance konstant bei rund 3 Sekunden. ... Dim iColumnCount As Long ... Dim FirstColumnforSQLexists_jn As String 'j if first column for SQL ...
    (microsoft.public.de.excel)