Monday, March 26, 2012

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;P ersist 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;P ersist 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;P ersist 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,
SushiAny errors or information from SQL error log?|||no message in ERRORLOG or EventViewer :-(

No comments:

Post a Comment