Hi, everybody
I'm looking for a free Ms Server jdbc driver: does it exists?
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
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?
jdbc:microsoft:sqlserver://1.2.3.4:1433;DatabaseName=<databasename>;SelectMethod=cursor/
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.
Users browsing this forum: No registered users and 8 guests