Add MS SQL datasource error

Forum|Forum|13 years ago
December 2, 2012
1 reply
819 views

I just installed CF 10 on my Win 7 Home machine and tried to add a MS SQL server data source and got following error.

do I need install any driver to add MS SQL Server as a data source?

I am able to add MySQL database, but not MS SQL Server.

Your help and information is great appreciated,

Regards,

iccsi,

Connection verification failed for data source: MyServer

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect

The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect

This topic has been closed for replies.

Correct answer iccsi

I got it works now,

Thanks for helping and informaiton,

Regards,

Iccsi,

I

iccsiAuthorCorrect answer

Inspiring

I got it works now,

Thanks for helping and informaiton,

Regards,

Iccsi,

BKBK

Community Expert

Please, kindly say how you solved the problem. It will help someone else in future.

I

iccsiAuthor

Inspiring

Thanks for the message,

It was my mistake a typo on the server name.

Thanks again for helping and message,

Regards,

Iccsi,

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded