3 Replies Latest reply: Apr 3, 2014 12:08 AM by BKBK RSS

    Having problems connecting Coldfusion10 with sql server express 2012

    Rossco199 Community Member
    Rossco199 Mar 28, 2014 11:33 AM

      Hi,

       

      I am having problems setting up a datasource for a local sql express 2012 server. Its running as the default instance. Connections are working with ODBC and client told just not Coldfusion.

       

      When I try to set up a connection using the sql driver I get this error:

       

      Connection verification failed for data source: Leaf

      java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connect

      The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connect

       

      When I try a Socket connection with an ODBC connection I setup in windows I get this error:

       

      Connection verification failed for data source: LeafDB

      java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.

      The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.

       

      Any ideas?

       

      Thanks,