Connecting to SQL server 2005 / Resolved?

ScadaBR - Dúvidas e Suporte
1

Hello,

I tried to comment on the post “Connecting to SQL server 2005” but was not able to. Here is my comment below…

I have tried to follow the procedure to connect to an MS SQL server database and can not make a connection. Is there additional information on connecting to MS SQL server available? I can not read the manual, I only speak English ;-( !! Jose were you able to resolve your connection issue?

Thank you,

Nancy M
USA

2

Hi Nancy,

Unfortunately I didn’t get the connetion yet. I have been some problens with the SQL drivers configuration.
I am trayng:

Driver name: "com.microsoft.sqlserver.jdbc.SQLServerDriver "

String connection:" jdbc:microsoft:sqlserver://192.168.61.110:1433;databaseName=PRIME;user=sa;password=sa"

…return
"class java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver ".

Tanks for help.

Jfranck

3

Oh bummer!!

Today I get the error message “class com.microsoft.sqlserver.jdbc.SQLServerException: Statement(s) could not be prepared”

It looks like I have made progress since yesterday and have a connection but now need to add statements.

Check out the following link if you like that helped me to get here…

http://www.jibble.org/settingupjava.php

previous returns:

Nov 17 10:48: ‘XiO SQL’: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.”.
Nov 17 10:39: ‘XiO SQL’: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Nov 17 10:35: ‘XiO SQL’: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Nov 16 20:04: ‘XiO SQL’: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: “connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.”.
Nov 16 13:07: ‘XiO SQL’: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
Nov 15 17:33: ‘XiO SQL’: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
Nov 15 15:42: ‘XiO SQL’: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
Nov 15 14:55: ‘XiO SQL’: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

Working from home today can answer more questions Monday!

Nancy

4

Hello!

Here is the following I used to connect MS SQL server 2000 database…

Driver class name: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection string: jdbc:sqlserver://10.1.10.201:1433

Select statement:
USE XIO
SELECT *
FROM XIO_DATA

Hope this helps!!
:slight_smile: