Re: JDBCR4 error Unknown server host name

This may be obvious but...Are you sure the user and password are valid on the SqlServer database? And does that user have permissions on the database/instance <datitest>? Other than that the connection string looks correct that I can see.

Also note, in the source for JDBCR4 if you scan for JDBC_Connect you will see comments that JDBC_Connect is actually just a wrapper for JDBC_ConnProp. I would recommend using JDBC_ConnProp as jdbc_Connect just calls jdbc_ConnProp but my calling jdbc_ConnProp directly you are able to populate the connection properties.

Rob


On 5/22/2017 9:11 AM, gio.cot wrote:

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