I am experimenting with TN 4.6 and TN 6.0. TN 4.6 works ok with the built-in database (cloudscape), but I cannot get 6.0 to connect to the database.
Apparently there is no built-in database available for TN 6.0, so I chose to use sql server. I ran the db install scripts which successfully created about 30 tables for TN in a database called TN_TEST.
I then configured a JDBC Pool Alias for TN as follows:
Functional Alias Definitions
TN Trading Networks Function
Pool Alias Definitions
Alias Name: TN
Associated Driver Alias: DataDirect Connect JDBC SQL Server Driver
Database URL: jdbc:sqlserver://192.168.1.101:1433;databaseName=TN_TEST;SelectMethod=cursor
User Id: sa
When I try to connect to TN with WmTNWeb I get the following error:
“could not get host profile”
When I try to connect to TN with TNconsole I get the following error:
“there was a database error fetching the model version info from your database, connection refused”
I tried windows authentication as well as well as sql server authentication.