[CAY-1754] Modeler suggested URL for SQLServer should start with 'jdbc:sqlserver:' instead of 'jdbc:microsoft:sqlserver:'

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 3.1B2, 3.2.M1
• Component/s: Modeler
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 28/Oct/12 16:01
• Updated: 28/Oct/12 16:05
• Resolved: 28/Oct/12 16:05

Description

Modeler suggested URL for SQLServer should start with 'jdbc:sqlserver:' instead of 'jdbc:microsoft:sqlserver:'. Currently Modeler Preferences > Local DataSources > New > ...SQLServer would create a URL jdbc:microsoft:sqlserver://host;databaseName=database;SelectMethod=cursor . It should be something like jdbc:sqlserver://127.0.0.1:1433;databaseName=database;SelectMethod=cursor instead. The jdbc:microsoft: protocol seems to be an old one no longer working with newer MS drivers.