Re: JDBCR4 and the TDS SQL Server.

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Should be "user" and "password" (without quotes, in lowercase).

You can get a complete list of the properties here:
http://jtds.sourceforge.net/faq.html


Alan Campin wrote:
> Does anyone know (Probably Scott) when you are using the TDS Driver for SQL
> Server with JDBCR4 what the fields names need to be for the User Name,
> Password and Database?
>
> I am using these but I get an error back saying that it doesn't support
> single signon so I am assuming it is not recognizing the properties that I
> set.
>
> JDBC_SetProp(MyProperty: 'userName'    : %Trim('aUser'));
> JDBC_SetProp(MyProperty: 'password'    : %Trim('aPassword'));
> JDBC_SetProp(MyProperty: 'databaseName': 'RapidLog');
>
> MyConnection =
>        JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'  :
>                      'jdbc:jtds:sqlserver://RAPIDLOG:1433':
>                      MyProperty                           );
>
> Link to Scott's article on the TDS driver.
>
> http://systeminetwork.com/article/sql-server-jdbc-driver-tip