Re: JDBCR4 error Unknown server host name

[Robert Rogerson <rrogerson@xxxxxxxxxxx>]

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