slow connection

[shaminda]

I have a program in VB that users a SQL Server 7.0 database and it take about 2 - 4 minutes to make the connection. I can't figure out why its taking so long. Here is my code:


Set rsPartLbl = New ADODB.Recordset

With rsPartLbl
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
End With

rsPartLbl.Open "TRWPARTLBL", conn

its the last line that takes time.

 

[smbure]

Have you tried rsPartLbl.Open "select * from TRWPARTLBL", conn?