Port not supported for SQL Server

archie · Post by **archie** » Wed 11 Jul 2007 14:50

Hi,

I'm trying to connect to a Microsoft SQL Server on a non-standard port, but I experience problems when I'm specifying the port. When I try to connect I receive the following error: Port not supported for SQL Server.

Why isn't it possible to specify a port number? Is there any other way for me to specify the port, because we have numerous situations where the SQL Server isn't listening on the default port.

Thanks.

Alexey · Post by **Alexey** » Wed 11 Jul 2007 15:37

We are going to fix this.
Look forward to hearing from me again.

archie · Post by **archie** » Thu 12 Jul 2007 07:02

Great

Does this mean all providers will support different ports to be specified from now on? From what we've seen only MySQL and Postgre could have a port specified.

Any idea when all this will be ready?

Thanks!

Alexey · Post by **Alexey** » Thu 12 Jul 2007 07:32

What do you mean "all providers"? MySQLDirect .NET, PostgreSQLDirect .NET and OraDirect .NET has this connection attribute. So we are going to fix this only in UniDirect .NET when using it with standard provider for MS SQL Server.

archie · Post by **archie** » Thu 12 Jul 2007 07:45

Yes, perfect. Thanks.

Alexey · Post by **Alexey** » Thu 12 Jul 2007 14:45

We have analyzed the problem and found out that special keyword for port is not needed. You should set it like this:

Code: Select all

provider=SQL Server;Data Source=server2, 1433;Initial Catalog=Test;User ID=sa;

where 1433 is your port number.

archie · Post by **archie** » Mon 16 Jul 2007 06:53

Ok, but could you fix the problem anyway? The idea of UniDirect is to be a transparent layer to all DBMS, it'd be kind of stupid to have to deal with this Port anomaly for MSSQL specifically. It'd be better if we could just set the Port property of the UniConnection and your library would take care of setting up the connection string properly.

Alexey · Post by **Alexey** » Mon 16 Jul 2007 08:29

OK, we will do it for you.

archie · Post by **archie** » Tue 04 Sep 2007 13:43

Is there any news regarding an update of UniDirect? It has been a while and we've never heard anything about the next update.

Alexey · Post by **Alexey** » Wed 05 Sep 2007 08:32

We haven't fix this yet, unfortunately.