I don't have a chance to try it (at least not yet till I can convince one of them to install). Clients only have ADO drivers installed.
Cetin
>Can you connect using SSMS?
>
>>(Named pipes, TCP/IP and shared) protocols are enabled on server. Named, full qualified network name or tcp/ip results the same.
>>
>>It doesn't also make a difference if we use Windows authentication or SQL server auth.
>>
>>Cetin
>>
>>>Are they both using the same network protocol to connect to the SQL Server?
>>>
>>>>"Unable to complete login process due to delay in login response"
>>>>
>>>>Server: SQL server 2005 enterprise
>>>>Client connection: If attempted using SQLNCLI, we get the message in title after some time (no explicit connection timeout setting). The strange thing if we try connecting with SQLOLEDB instead, the connection succeeds instantly.
>>>>
>>>>Because of new datatypes we need to use SQLNCLI. I have been trying this and that to no avail (except increasing timeout which doesn't make sense to me when SQLOLEDB connects instantly). Is there a solution to this. Where should I look exactly (at serverside and/or clientside).
>>>>
>>>>Thanks in advance (timeout should be the last resort)