[protege-discussion] DataMaster connection to SQL Server

[Andrew Roberts]

Dear All,

The problem seemed to be some old versions of Java on my machine. 

The driver needed is at:

http://www.microsoft.com/downloads/details.aspx?
FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en

and contains some .dlls needed.

sqljdbc.jar and sqljdbc4.jar go into the Datamaster plugin folder and
sqljdbc_auth.dll to C:\WINDOWS\system32\

In JDBC Driver type com.microsoft.sqlserver.jdbc.SQLServerDriver

In JDBC URL type
jdbc:sqlserver://sqlserver\XXXXXXXX;databaseName=XXXXXXXXX;
ntegratedSecurity=true;

The username and password come from windows and Hey Presto!

andrew