Windows 7 (64bit) / CF8 / SQL Express 2008 - can't connect
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...
