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