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 :-(
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment