Hi all,
was anybody successful in using Play SQL Base and connecting it to MSSQL Server? I was able to create new datasource. Even the test query has passed. I used jDTS
Driver: net.sourceforge.jtds.jdbc.Driver
JDBC Connection String: jdbc:jtds:sqlserver://server:1433;databaseName=Global;domain=DOMAINuseNTLMv2=true;
Test SQL: SELECT 1
However, every attempt to query the DB fails with LIMIT 1 error. It's actually described here:
https://playsql.atlassian.net/browse/PLAYSQL-187
So, I'm just checking if someone was successful as there's no official support for MSSQL databases.
Thanks.
Regards,
Radek
