Forum Discussion

NK12's avatar
NK12
Occasional Contributor
7 years ago

Unable to Connect SQLSERVER DB by using JDBC step

Have used all the pre-requisites

 

Copied all the JAR files -sqljdbc41 and sqljdbc42 in ext and lib folders

 

Copied sqljdbc_auth.dll in bin folder

 

Used the driver name as-

 

com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Unable to make the connection successful

 

Please let me know is any other steps to be taken to establish the connection

 

Appreciated your help in this

 

Thanks

 

  • NK12's avatar
    NK12
    Occasional Contributor

    Thanks for your reply

     

    Have tried with two options

     

    Option 1:

    Download jtds-1.3.1.jar
    And place it under READYAPI_HOME/bin/ext directory and restart.

    Use driver class as : net.sourceforge.jtds.jdbc.Driver

    Use connection string as :
    jdbc:jtds:sqlserver://${dbServer}:${port}/${dbName};domain=${domain}

     

    Getting error as Can't get the connection for specified properties

    java.sql.SQLException:Network error IOException:Connection timed out to connect

     

    Option 2

     

    Copied sqljdbc_auth.dll  in bin folder

    Copied sqljdbc42.jar  in ext folder

    Used SQL Driver as SQL Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

    Connection String as:jdbc:sqlserver://ServerIP:Port;databaseName=DBName;user=username;password=password

     

    Getting error as Could not get the connection specified properties followed by connection string values

     

     

    Please can you help me any other options for getting connection successful

     

    Currently I'm using trial version of Ready API2.2.0 version

     

    Thanks!!

    • nmrao's avatar
      nmrao
      Champion Level 3
      There are place holders of the database details. Please replace those values and try it.
  • NK12's avatar
    NK12
    Occasional Contributor

    In Both the cases

     

    Have used my project DB Name, UserName and Password

     

    FYI.. My DB is hosted in Server it is not running locally

     

    Thanks

  • NK12's avatar
    NK12
    Occasional Contributor

    Thanks for your help!!

     

    Finally I'm able to make the successful connection

     

    SQL Server DB is running in host environment not in local

     

    Used the below steps

     

    1.Copied

                      bin\ext folder contains sqljdbc41.jar

                      bin folder contains sqljdbc_auth.dll

     

    2. Driver Name as com.microsoft.sqlserver.jdbc.SQLServerDriver

     

    3. Connection String as jdbc:sqlserver://<Instannce Name>;databaseName=<DB Name>;integratedSecurity=true

     

    Thanks!!