1. Davide Morando
  2. as SQLite DB Server
  3. Среда, Апрель 17 2024, 10:54 AM
  4.  Подписаться через email
Environment:
- installed a licensed instance of Valentina Server (Windows pc 192.1.1.202, unmodified standard parameters)
- put a SQLite db UTF16LE in the appropriate folder
- installed Valentina Studio on Client1 (Windows): VStudio connects to VServer successfully
- installed vodbc_standalone_x64_13_win.exe on Client2 (Windows)
- disabled firewall everywhere
- querying 192.1.1.202:15532 from any browser of pc in the networks returns some binary data, so the communication port is working

Problem:
- When trying to create a DSN in Client2 using Winddows ODBCx64 panel, it fails reporting SQL_ERROR
- When trying to connect from Client2 with ADO connection string "Driver={Valentina ODBC Driver};Host=192.1.1.202;Port=15532;UID=sa;PWD=sa;Database=dbmaterialsspac2025_amw" , it fails with com error 80004005 E_FAIL
- repeating the test in Client1 (where with the same parameters VStudio connects successfully), obviously after the installation of ODBC driver, I get the same failure.
- Tried with "Database=dbmaterialsspac2025_amw" and "Database=dbmaterialsspac2025_amw.db" but I can guess that the file extension is optional, VStudio connects regularly with both values

How can I fix this?
Thank you
DavideM
Вложения
Комментарий
There are no comments made yet.


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories