U++ forum: Welcome to the forum

Thu, 16 April 2020 10:32

Giorgio
Messages: 218
Registered: August 2015

Experienced Member

Hi there,
I've been using the MSSQL ODBC driver to connect to the database of a software developed by a third party. Basically, I have just to import a table, so just to read data. The database is hosted in a remote server managed by the party that developed the application and we connect to that server through a VPN connection. When the application I developed runs in the third party premises works perfectly, but when I connect through VPN I got the following error: "ERROR: Expected number: oft][ODBC SQL Server". The problem is that due to the sysadmin paranoia, they open ports in the VPN connections only if requested. I managed to have the sysadmin to open some port, so now I can use SQL Server Management Studio to access the data base (TCP port 1433), but the application I developed still doesn't work.

What are the ports I should ask to open to use MSSQL through U++?

Thanks,
gio

Report message to a moderator