refactor some connection handling, try and improve heap issues
fix issue with empty schema name for SSAS