> 1. Use SQL Server Express 2005 instead. It is so much better. No can do, the production server is 2000 so he must develop on 2000 to avoid things going wrong between dev and production.
> 2. Does he have SQL Server authentication or Windows authentication? Mixed mode. > 3. What is the error? It is a connection error... ------------------------------------------------------- Connection verification failed for data source: test java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect ------------------------------------------------------- I have worked arroud the issue by setting the DB up as a system ODBC datasource then having CF use that but it would be nice to get CF/JDBC working directly without the ODBC middleman. -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
