ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

JDBCR4 error Unknown server host name

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • JDBCR4 error Unknown server host name

    Hi all
    i?m try to use for the first time Scott Klement JDBCR4 ;

    I have modified in the example JDBCTEST the connection values:

    conn = JDBC_Connect( 'net.sourceforge.jtds.jdbc.Driver'
    : 'jdbc:jtds:sqlserver://VServer02/datitest'
    : %trim(userid)
    : %trim(passwrd) );

    But I receive the message ?Unknown server host name 'VServer02' ?

    I have done this:
    1. Installed JDBCR4 and compiled as instruction
    2. Downloaded and installed via ftp jtds-1.2.5.jar in /java/jdbc
    3. Executed ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jtds-1.2.5.jar')
    4. Call to JDBCTEST


    the ping at VServer02 is Ok

    where am I wrong ?
    which test can I do ?
    thanks

  • #2
    Assuming you're running MS SQL Server and trying to connect to VServer02\datitest, try this:
    : 'jdbc:jtds:sqlserver://VServer02;instance=datitest'

    Comment


    • #3
      Hi jtaylor

      thanks for your reply ..
      if i sue ip adress instead of the name, it works fine

      thanks

      Comment

      Working...
      X