Having problems connecting Coldfusion10 with sql server express 2012

forums_noreply@adobe.com — Fri, 28 Mar 2014 18:33:44 GMT

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,

Adobe Community : All Content - All Communities

Having problems connecting Coldfusion10 with sql server express 2012