DB-VA ARCHITECT SQL -> Microsoft SQL Server 2005

General Questions/Discussions
1

We are trying to connect DB-VA ARCHITECT SQL (on Linux) to a Microsoft SQL Server 2005 (on Win2000).

The TCP connection is OK on the server side, because I have been able to connect from a WinXP client with ODBC DSN.

For DB-VA connection, I use :

  • Adapter File : <<jTDS 1.2>>
  • Adapter Driver : MS SQL Server (jTDS Driver)
  • Hostname : 172.20.63.51
  • Port : 1433 (I have tried 1039 and some others) But not sure of the SQL Server default.
  • Database name : SQLEXPRESS
  • the correct Username & Password.

Unfortunatly, I get :
Test adapter connection failed!

I have looked on your website, and could not find any HOWTO .

Thanks for help

2

Hi rr,

Can you send me the log file to have a look? You can find it at $vp-suite-install-dir/bin/vp.log

Best Regards,
Jick

3

Hi Jick,
I do not have such file on my disk.
On file:/opt/VP_Suite2.3/bin/ I found :
file:/opt/VP_Suite2.3/bin/.dbvasqlworkspace
file:/opt/VP_Suite2.3/bin/dbvasql
file:/opt/VP_Suite2.3/bin/vp_windows
file:/opt/VP_Suite2.3/bin/product_edition.properties
file:/opt/VP_Suite2.3/bin/VP_Suite_Update
file:/opt/VP_Suite2.3/bin/VP_Suite_Product_Selector
file:/opt/VP_Suite2.3/bin/VP_Suite_Product_Edition_Manager
file:/opt/VP_Suite2.3/bin/VP_Suite
file:/opt/VP_Suite2.3/bin/DB-VA_SQL_1.0
file:/opt/VP_Suite2.3/bin/vpproductinstallation.xml
file:/opt/VP_Suite2.3/bin/PDFDocGenerator.sh
file:/opt/VP_Suite2.3/bin/HTMLDocGenerator.sh

4

Hi rr,

Are you sure TCP is enabled? As we know it is disabled by default.

Best Regards,
Jick