I’m having trouble building a connection string to my local MSSQL database using the Data Abstract Schema Modeler. If I open the Connection Manager, I can create a live connection to my local MSSQL database using the MSSQL.NET provider, however, when I try to create a new schema via the wizard, the drop-down for the drive is empty. When I simply paste in the connection string from the connection I made
(MSSQL.NET?Server=localhost;Database=;User ID=sa;Password=;Integrated Security=SSPI;)
an error shows “Unknown driver MSSQL.NET”
What am I doing wrong?