# MS Server jdbc driver **URL:** \ **Category:** Classic Servoy\ **Created:** [June 3, 2003, 9:04pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103 "2003-06-03T21:04:57Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Riccardino](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Riccardino](https://forum.servoy.com/u/Riccardino)\ **Post date:** [June 3, 2003, 9:04pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/1 "2003-06-03T21:04:57Z")
Hi, everybody I’m looking for a free Ms Server jdbc driver: does it exists? ![:-)]( "Smile") ---
**Author:** ![mpwiedemann](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mpwiedemann](https://forum.servoy.com/u/mpwiedemann)\ **Post date:** [June 3, 2003, 9:13pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/2 "2003-06-03T21:13:24Z")
You can get it at [www.microsoft.com/sql](http://www.microsoft.com/sql) It is one of the top downloads. Good luck, Martin ---
**Author:** ![Riccardino](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Riccardino](https://forum.servoy.com/u/Riccardino)\ **Post date:** [June 3, 2003, 10:31pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/3 "2003-06-03T22:31:17Z")
> mpwiedemann: > You can get it at [www.microsoft.com/sql](http://www.microsoft.com/sql) > > It is one of the top downloads. Thanks. ![:-)]( "Smile") 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? ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [June 3, 2003, 11:03pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/4 "2003-06-03T23:03:08Z")
MS SQL server is in the auto setup pulldown, it will return: URL: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=\;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:]( "Wink") ---
**Author:** ![Riccardino](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Riccardino](https://forum.servoy.com/u/Riccardino)\ **Post date:** [June 4, 2003, 4:09pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/5 "2003-06-04T16:09:56Z")
> jaleman: > MS SQL server is in the auto setup pulldown, it will return: > > URL: > jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=\;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:]( "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:]( "Wink") ---
**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\ **Post date:** [June 4, 2003, 5:19pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/6 "2003-06-04T17:19:21Z")
> Riccardino: > > > jaleman: > > MS SQL server is in the auto setup pulldown, it will return: > > > > URL: > > jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=\;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:]( "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:]( "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 ---
**Author:** ![edward](https://avatars.discourse-cdn.com/v4/letter/e/90db22/32.png) [@edward](https://forum.servoy.com/u/edward)\ **Post date:** [June 4, 2003, 8:02pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/7 "2003-06-04T20:02:03Z")
Its also case-sensitive so double check that… ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [June 4, 2003, 8:13pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/8 "2003-06-04T20:13:59Z")
```auto jdbc:microsoft:sqlserver://1.2.3.4:1433;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. ---
**Author:** ![Riccardino](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Riccardino](https://forum.servoy.com/u/Riccardino)\ **Post date:** [June 5, 2003, 7:35pm UTC](https://forum.servoy.com/t/ms-server-jdbc-driver/103/9 "2003-06-05T19:35:33Z")
> jaleman: > > ```auto > jdbc:microsoft:sqlserver://1.2.3.4:1433;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 ![:-)]( "Smile")