Conn to MS SQL Express

Classic Servoy
1

Hi Folks

Just playing with Servoy connecting to MS SQL for the first time (been using iA previously) and am having some connection difficulties.

Here is my string:

jdbc:jtds:sqlserver://HPSPAIN\SQLEXPRESS\Databases/tci_excorr

EDIT: Looks like my syntax was wrong - changed to:

jdbc:jtds:sqlserver://HPSPAIN/SQLEXPRESS/Databases/tci_excorr

Was getting the ‘Unknown Server’ error, but now getting a connection time-out error?

I’ve the TCIPP Port configured and the IPALL port set and active.

What am I missing here?

2

I connected to MS SQL Server Express edition using the url jdbc: sqlserver://localhost\SQLEXPRESS:1443;DatabaseName=mydb;SelectMethod=cursor . There were some changes that had to be done: download another jdbc driver and copy it to drivers directory ( in combo then select: com.microsoft.sqlserver.jdbc.SQLServerDriver); use sql authentication not windows one; enable tcp/ip protocol and configure port to 1443. This is some stuff I remember now, maybe I did others as well. Maybe these can give you a clue about what to do ?

3

lvostinar:
I connected to MS SQL Server Express edition using the url jdbc: sqlserver://localhost\SQLEXPRESS:1443;DatabaseName=mydb;SelectMethod=cursor . There were some changes that had to be done: download another jdbc driver and copy it to drivers directory ( in combo then select: com.microsoft.sqlserver.jdbc.SQLServerDriver); use sql authentication not windows one; enable tcp/ip protocol and configure port to 1443. This is some stuff I remember now, maybe I did others as well. Maybe these can give you a clue about what to do ?

Vostinar - thanks for that feedback

I’m using windows authentication at the moment - but since the sql server is not running on the same PC I cant use localhost to connect. I think thats the problem.

And I want to use the jTDC driver!

Any other comments?

4

Ok, I tried with jtds driver in 4.0 and it was working using the url: jdbc:jtds:sqlserver://LAU:1443/mydb . Port is configured to 1443 ( not dynamic); TCP/IP enabled and sql authentication.

5

lvostinar:
Ok, I tried with jtds driver in 4.0 and it was working using the url: jdbc:jtds:sqlserver://LAU:1443/mydb . Port is configured to 1443 ( not dynamic); TCP/IP enabled and sql authentication.

Ivostinar

I tried this:

jdbc:jtds:sqlserver://HPSpain/SQLEXPRESS:1443/Databases/tci_excorr

which should be the equivalent of what your string does and get the same connection time-out!

Is LAU the name of the PC on which your sqlserver is running or the name of your SQLServer?

6

Lau is the name of the computer ( which is actually localhost); the catch was that SQLEXPRESS is not needed in the url even if i have sql server express 2005 , until I removed that string, it didn’t work. Also I think that sql authentication must be used ( if windows authentication a dll must be in the system path).

7

lvostinar:
Lau is the name of the computer ( which is actually localhost); the catch was that SQLEXPRESS is not needed in the url even if i have sql server express 2005 , until I removed that string, it didn’t work. Also I think that sql authentication must be used ( if windows authentication a dll must be in the system path).

Ivostinar - thanks for all the feedback - still couldn’t get comm’s over the network - so for experimental purposes - I installed Servoy on the same PC as the SQL SERVER and got up and running instantly.

I still need to work on getting networked access from Servoy but that can come later. At least I can start developing with a production-database ‘copy’ now and see what we can generate!