SQLEXPRESS in Windows7

Classic Servoy
1

Hi!

I installed SQLEXPRESS on Windows7 and trying to connect from Developer.
URL: jdbc:jtds:sqlserver://localhost/tsmseven;instance=SQLEXPRESS
Driver: net.sourceforge.jtds.jdbc.Driver

I get this error message:

"Server localhost has no instance named SQLEXPRESS"

But when I open SQL Management Studio Express and query the servicename

select SQL@@servicename

I get SQLEXPRESS

Thanks in advance.

2

You might have to specify the port or something. I use this format which works:

jdbc:jtds:sqlserver://mycomputer:61775/mydatabase;instanceName=SQLEXPRESS