Servoy Forum

Hi, everybody

I'm looking for a free Ms Server jdbc driver: does it exists?

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

It is one of the top downloads.

Good luck,
Martin

mpwiedemann wrote: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?

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

jaleman wrote: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

Hi, Jan

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

Is there any mistake or is it a server problem?

Riccardino wrote:

jaleman wrote: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

Hi, Jan

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

Is there any mistake or is it a server problem?

Make SURE that you replace <databasename> 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

Its also case-sensitive so double check that...

Code: Select all

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

Couple of things:
1. replace <Databasename> 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.

jaleman wrote:

Code: Select all

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

Couple of things:
1. replace <Databasename> 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