MS Server jdbc driver

Classic Servoy
1

Hi, everybody

I’m looking for a free Ms Server jdbc driver: does it exists? :-)

2

You can get it at www.microsoft.com/sql

It is one of the top downloads.

Good luck,
Martin

3

mpwiedemann:
You can get it at www.microsoft.com/sql

It is one of the top downloads.

Thanks. :-)
I copied the driver in Servoy’s driver folder, I created a new connection with the string:
jdbc:SQLserver://dbaddress/dbname

But it refuses to connect.
The error message tells me:
Error establishing socket

Is there some mistake in the string I’m using?

4

MS SQL server is in the auto setup pulldown, it will return:

URL:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor

and driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver

all you need to do is replace localhost and database name.

Make sure that your SQL Server accepts TCP connections (YES by default but can be turned off). I personally use MS SQL Servers during all my demos so I can assure you it works very well :wink:

5

jaleman:
MS SQL server is in the auto setup pulldown, it will return:

URL:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor

and driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver

all you need to do is replace localhost and database name.

Make sure that your SQL Server accepts TCP connections (YES by default but can be turned off). I personally use MS SQL Servers during all my demos so I can assure you it works very well :wink:

Hi, Jan

i put this string but it doesn’t work.
jdbc:microsoft:sqlserver://1.2.3.4:1433;DatabaseName=;SelectMethod=cursor/

Is there any mistake or is it a server problem? :wink:

6

Riccardino:

jaleman:
MS SQL server is in the auto setup pulldown, it will return:

URL:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor

and driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver

all you need to do is replace localhost and database name.

Make sure that your SQL Server accepts TCP connections (YES by default but can be turned off). I personally use MS SQL Servers during all my demos so I can assure you it works very well :wink:

Hi, Jan

i put this string but it doesn’t work.
jdbc:microsoft:sqlserver://1.2.3.4:1433;DatabaseName=;SelectMethod=cursor/

Is there any mistake or is it a server problem? :wink:

Make SURE that you replace with the actual name of your database (i.e. Northwind) - and also make sure you SQL Server is running on port 1433 (which is the default). I use MS SQL Server all the time - and have had no problems.

Hope this helps,

Bob Cusick

7

Its also case-sensitive so double check that…

8 
jdbc:microsoft:sqlserver://1.2.3.4:1433;DatabaseName=<databasename>;SelectMethod=cursor/

Couple of things:

  1. replace with the actual databasename
  2. make sure the slash at the end is not there
  3. make sure the server IP is correct

Is it a Microsoft 2000 SQL Server? it will not work with older versions as far as I know.

9

jaleman:

jdbc:microsoft:sqlserver://1.2.3.4:1433;DatabaseName=<databasename>;SelectMethod=cursor/

Couple of things:

  1. replace with the actual databasename
  2. make sure the slash at the end is not there
  3. make sure the server IP is correct

Is it a Microsoft 2000 SQL Server? it will not work with older versions as far as I know.

Good point. I’ll try to call them tomorrow :-)