Sunday, June 6, 2010

Sybase ASE 15 .NET Drivers possible issues

These are just good tips to keep in mind anyways when using Direct ADO.NET interfaces. But here goes:

  • Always surround your Connection with Using. (this calls dispose on finishing usage)
  • Note in case you call connect be sure to balance it with a disconnect as well 
  • Set the connection timeout before you connect
  • Set the command timeout on your command
  • In case you do heavy data import. Try to set the local variables above the try block to null in the finally.