Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Sao Paulo, Brazil
    Posts
    6

    Unanswered: MDAC 2.6 with SQL Server 7 clustered (delay in connect)

    After I installed the MDAC 2.6 in COM+ Server, I'd a problem with a long delay to connect the COM+ with SQL 7 clustered.

    I had some tests, explained below:

    * COM+ in server 1
    * SQL Server in server 2

    1) Try COM+ connect in SQL Server with thrust authentication
    ConnectionString: "Provider=SQLOLEDB;Server=SERVER1;Database=master; Persist Security Info=False;Integrated Security=SSPI"

    (this SQL Server is Sort Order 52)
    --> connect in 10 seconds


    2) try COM+ connect in SQL Server with SQL authentication
    ConnectionString: "Provider=SQLOLEDB;Server=SERVER1;Database=master; Persist Security Info=False"

    --> connect in 0,1 seconds


    3) Try COM+ connect in SQL Server with thrust authentication
    ConnectionString: "Provider=SQLOLEDB;Server=SERVER2;Database=master; Persist Security Info=False;Integrated Security=SSPI"

    (this SQL Server is Sort Order 54)
    --> connect in 0,1 seconds



    CODE:

    Dim cnnData As ADODB.Connection

    Set cnnData = New ADODB.Connection

    Trace "Before cnnData.Open"

    cnnData.Open "Provider=SQLOLEDB;" _
    & "Server=SERVER1;" _
    & "Database=master;" _
    & "Persist Security Info=False;" _
    & "Integrated Security=SSPI"

    Trace "After cnnData.Open"

    cnnData.Close
    set cnnData = Nothing


    All answers will be welcome.
    Thanks,
    Sushi

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any errors or information from SQL error log?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Location
    Sao Paulo, Brazil
    Posts
    6
    no message in ERRORLOG or EventViewer :-(

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •