Unable to connect MX7 to MS SQL 2005

[BSW2]

I get the following error when attempting setup a database connection.

Connection verification failed for data source: q01nw
java.sql.SQLException: Error establishing socket to host and port:
127.0.0.1:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: Error establishing socket to
host and port: 127.0.0.1:1433. Reason: Connection refused: connect

I have updated the DataDirect drivers

This has me stumped after 2 days.

[BSW1]

More details:

I am working with the Developer version of CF MX7
I am attempting to use the SQL driver to connect to the Northwind database
MS SQLEXPRESS is installed and working, this is the developer version of
SQL2005
I have setup an ODBC data source to the Northwind database
Using the ODBC driver in CF works but restricts the T-SQL that can be used
SQL

[drforbin1970]

Every time I have a problem connecting to a SQL Server DB via CF Admin, I do
the following:

In Windows, Control Panel, Administrative Tools, Data Sources(ODBC), set up a
User DSN and a System DSN to the SQL Server DB. USE THE SAME NAME FOR BOTH. If
you are using the local server on the machine, type in (local) as the server
for the select box 'Which SQL Server do you want to connect to?' Make sure the
connection tests OK at the end of each setup.

Go into CF Admin under Data Sources and Add a new datasource but DO NOT pick
SQL Server, use ODBC. Select the ODBC DSN(the entry you added should be in the
dropdown list). Click 'Trusted Connection'. Leave username set to system .
Click Submit and you should be connected.

If this does not work, you may have to add a user to the Users section of the
database with sufficient access. You will have to add the user under Control
Panel/User Groups also.

Then go back into CF Admin and replace username with the username of the new
user you added and the password you assigned this user under Control Panel/User
Groups

[drforbin1970]

If you are able to connect but cannot perform certain functions in SQL, make
sure the user you are using to connect with has sufficient rights to that
database. Check under Users for that database and Security for that instance of
SQL Server, both in Enterprise Manager.

Also check the settings in CF Admin for your Data Source under Data & Services

> Datasources > Microsoft SQL Server .

[BSW1]

This provides an ODBC connection. I need a SQL driver connection.

OR

Does this make SQL driver connections work?

[JMGibson3]

SQLServer Express refused to work for me with CF's drivers until I stumbled
across the fact that it installs with bogus default IP/Port settings,
presumably to emulate the old MSDE (ie. not intended for use as a Server). To
fix it, use the SQL Express Configuration Manager to drill all the way down to
the final Protocols/TCPIP screen. Make sure that the IPALL (the public port)
setting has blanks in the TCP Dynamic Ports and 1433 in the TCP Port.

[BSW2]

Now that I have both a ODBC and a JDBC connect performance testing can start with Microsoft SQLEXPRSS.