Using Weka version 3.7.11, I have a local 2014 SQL Server instance on my PC. I have a standalone JAVA program that reads from an Oracle database and writes to this SQL Server database. Thus, I have went through enabling TCP connections,
firewall issues, etc. to get that to work. When I copy the following connection string (same one I use for the JAVA program mentioned above)
into the Explorer -> Open DB -> URL box
I get the following error message:
to: jdbc:sqlserver://localhost:1433;user=gregory;password=xxxxxx;integratedSecurity=true;databaseName=green = false,verticalAlignment=CENTER,verticalTextPosition=CENTER]
The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP
connections to the port are not blocked by a firewall.".,verticalAlignment=CENTER,verticalTextPosition=CENTER]
I know everything in the bottom error message in yellow is set correctly. What may be missing is in my standalone JAVA program I have to include ‘sqljdbc_auth.dll’ but that corrected the ‘invalid username/password’ error I was getting
– not the connection issue above.
CLASSPATH is: C:\Program Files\Weka-3-7\weka.jar;C:\Program Files\Weka-3-7\sqljdbc4.jar;C:\Program Files\Weka-3-7\ojdbc14.jar;WEKA_HOME;%CLASSPATH%
PS. I know it’s not good to mix two different issues in the same email, but the ojdbc14.jar I have in the CLASSPATH variable doesn’t throw any errors when I try to connect to an Oracle 22.214.171.124 instance, it just hangs and I have to use
task manager to kill Weka. And for the record, the sqljdbc.jar doesn’t work – I had to change it to sqljdbc4.jar in the CLASSPATH to get this far with SQL Server 2014.
The top part of my DatabaseUtils.props looks like this:
# Database settings for Microsoft SQL Server 2000
# General information on database access can be found here:
# url: http://www.microsoft.com/
# jdbc: http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A
# author: Fracpete (fracpete at waikato dot ac dot nz)
# version: $Revision: 5837 $
# JDBC driver (comma-separated list)
# database URL
Summit Racing Equipment
NOTICE: The information in this electronic mail transmission, including all attachments, is intended by Autosales, Incorporated dba Summit Racing Equipment for exclusive use of the named individual or entity to which it is directed. Please understand that this electronic mail transmission may contain information that is a trade secret or is otherwise confidential, and therefore must be protected from disclosure. It is not intended for transmission to, or receipt by, anyone other than the named addressee (or person expressly authorized to deliver it to the named addressee). The information contained in this electronic mail transmission must not be copied or forwarded to any unauthorized person. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and please notify the sender of the error by reply email or by calling Summit Racing Equipment at 330-630-5343, which will enable us to correct our records.