Anyone know why I must supply a port number in my OLEDB connection strting?

This information is already in the interfaces file.

Both SQL Server and Oracle do not require this.

On my "login screen" for my app I either need to have the user provide the port with the server (not desirable) or I have to look it up in the interfaces file.

Does the provider already have to look up the SQL.INI entry to get the network address and protocol? Couldn't the provider just get the port from there?

Just seems like a big pain that I haven't had to deal with in SQL Server or Oracle.

Thoughts? Am I missing something? Is there a way to specify the interfaces file in the connect string so I don't have to do this?