Connection to MsSql server 2000

Report · Nov 13, 2008

I tried to establish a new datasource on SQL server 2000 (personal edition)
and I have this message :

Connection verification failed for data source: Forum_SQL
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

Does CF7 works with MsSql server 2000 personal edition ?

Thanks for any help with this.
My work is stopped.

Pierre.

Report · Nov 13, 2008

> Does CF7 works with MsSql server 2000 personal edition ?

IIRC, yes. Though it has been a while since I used 2000. Did you check your service pack level?
http://www.danvega.org/blog/index.cfm/2006/7/14/Coldfusion-SQL-Server-Problems