1 Reply Latest reply on Nov 1, 2007 6:10 PM by ksmith

    use sql db on a remoate location

    Level 7
      I'm at the company network that's setup for coldfusion application (CF 8).

      I need to create an ODBC to a SQL server that is NOT in the local
      network..
      it's at a remote datacenter.

      I tried this:

      jdbc:Microsoft:sqlserver://SERVERNAME;DatabaseName=DBNAME
      com.microsoft.jdbc.sqlserver.SQLServerDriver

      with the username/password

      I get this error message:
      connection verification failed for data source: DBNAME
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
      establishing socket.
      The root cause was that: java.sql.SQLException: [Microsoft][SQLServer 2000
      Driver for JDBC]Error establishing socket.


      is this possible or how can I fix... thanks!