Home » U++ Library support » U++ SQL » MSSQL TCP ports
MSSQL TCP ports [message #53623] |
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
|
|
|
Re: MSSQL TCP ports [message #53624 is a reply to message #53623] |
Thu, 16 April 2020 10:45 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
Giorgio wrote on Thu, 16 April 2020 10:32Hi 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
If it works with SQL Studion, it should work with U++ too => problem is somewhere else.
|
|
|
|
|
Goto Forum:
Current Time: Fri Mar 29 10:43:19 CET 2024
Total time taken to generate the page: 0.01306 seconds
|