- 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.