Connecting with SQL server with ssl

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Connecting to an SQL server with encryption forced on stopped my C# program
using ADO.Net from working on some SP calls. FillFromStoredProcedure failed
with "General Network Error". I cornered the problem to large amounts of
data being returned. Reducing the no of rows returned got rid of the error
message. Now how do I solve the problem? Is there a timeout setting that
needs to be set somewhere?
Thanks in advance,
Hananiel
 
You can specify the connection.Timeout in the connection string - it's
readonly thereafter. You can set the CommandTimeout through the
CommandTimeout Property of your command object. But this is usually a band
aid at best - I'd really look to keep the query as small as absolultey
necesary.
 
Back
Top