Skip to main content
Inspiring
November 22, 2009
Question

Windows 7 (64bit) / CF8 / SQL Express 2008 - can't connect

  • November 22, 2009
  • 1 reply
  • 1169 views

I cannot establish a DSN connection on this machine to the SQL 2008 Express server.The error is:

Connection verification failed for data source: obis2
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: W700:1433. Reason: Connection refused: connect.  The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: W700:1433. Reason: Connection refused: connect

Based on all the other posts I've read on this I have (as far as I can tell):

  • Enabled tcpip
  • Established that this IS a valid instance
  • Tried using both windows account and sql account authentication
  • Mixed and non-mixd authentication
  • Attempted to turn off dynamic port (I'm still not sure how or where to do this)

I also tried to set up an ODBC connection, and that fails regradless of which driver, windows account or sql account I use.

So I have to ask, IS THIS POSSIBLE?  I don't NEED sql server 2008, any working version will do.  I just thought the most recent version would be the best to use on Windows 7..

Has anyone gotten this working?  What's the trick? I'm not an expert but connecting MS SQL and CF has always been a simple process and I'm really stuck.

Help!

Thanks...

This topic has been closed for replies.

1 reply

RichardGAuthor
Inspiring
November 22, 2009

Okay, nevermind, I started working.  Darned if I know why.

RichardGAuthor
Inspiring
November 22, 2009

Aha - apparently the SQL Server Beowser service must be running.  It was not enabled by default.

Phew.

Participant
August 22, 2010

Thank you so much - starting browser service fixed it for me too.