Port not supported for SQL Server

Port not supported for SQL Server

Postby 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.
archie
 
Posts: 9
Joined: Wed 11 Jul 2007 14:42

Postby Alexey » Wed 11 Jul 2007 15:37

We are going to fix this.
Look forward to hearing from me again.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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!
archie
 
Posts: 9
Joined: Wed 11 Jul 2007 14:42

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby archie » Thu 12 Jul 2007 07:45

Yes, perfect. Thanks.
archie
 
Posts: 9
Joined: Wed 11 Jul 2007 14:42

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
archie
 
Posts: 9
Joined: Wed 11 Jul 2007 14:42

Postby Alexey » Mon 16 Jul 2007 08:29

OK, we will do it for you.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
archie
 
Posts: 9
Joined: Wed 11 Jul 2007 14:42

Postby Alexey » Wed 05 Sep 2007 08:32

We haven't fix this yet, unfortunately.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect Universal