1 Reply Latest reply on Dec 16, 2002 7:13 PM by 256962

    Error establishing socket.[Microsoft][SQLServer 2000 Driver for JDBC]

    383077
      I tray connect to MS-SQL2000 using JDeveloper and retrieve an error: "[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[Microsoft][SQLServer 2000 Driver for JDBC]PC160832\NCI_DBA_01"

      I followed the steps:
      1 - Install the JDBC Driver for MS-SQL2000
      2 - Create a new AddJavaLibPath :"AddJavaLibPath C:/Program files/Microsoft SQL Server 2000 Driver for JDBC/lib"
      3 - Specify Default Project Libraries: "msbase.jar, msutil.jar and mssqlserver.jar"
      4 - Create a new connection: "Java class name: com.microsoft.jdbc.sqlserver.SQLServerDriver" "URL: jdbc:microsoft:sqlserver://PC160832\NCI_DBA_01:1433;SelectMethod=cursor"
      5 - Retrieve the error: "[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[Microsoft][SQLServer 2000 Driver for JDBC]PC160832\NCI_DBA_01"

      e-mail: rcfiorio@vitoria.es.gov.br