Home » U++ Library support » U++ SQL » MSSQL TCP ports
MSSQL TCP ports [message #53623] |
Thu, 16 April 2020 10:32 ![Go to next message Go to next message](theme/default/images/down.png) |
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 ![Go to previous message Go to previous message](theme/default/images/up.png) ![Go to next message Go to next message](theme/default/images/down.png) |
![](https://www.ultimatepp.org/forums/images/custom_avatars/3.png) |
mirek
Messages: 14000 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: Sat Jul 27 03:13:31 CEST 2024
Total time taken to generate the page: 0.01257 seconds
|