How to define a connection port.

[Guest]

Can anyone tell me how to define the SQL port to use to communication to the server?

On a system that has the default ODBC settings defined with a dynamic port are able to connect to the SQL Server. If I go into the ODBC connection manager, and start to create a connection, change the port from dynamic to 1433. Exit or close the ODBC manager and then open my application it works.

If I do not do this step I am unable to locate the SQL Server?

Any ideas?

[Ikar]

You can use Client Network Utility (included into MS SQL Server package), or make corresponding changes in the registry directly (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo)

[Guest]

Is it possible to define the connection details in Delphi, and not use the registry values?

Does the SDAC sit on top of the ODBC/OLE DB drivers and therefore use the current system configurations?

[Ikar]

>> Is it possible to define the connection details in Delphi, and not use the
> registry values?

Not, as Microsoft didn't document a possibility to transfer port number in OLE DB.


> Does the SDAC sit on top of the ODBC/OLE DB drivers and therefore use the
> current system configurations?

SDAC doesn't use ODBC. SDAC uses the most low-level way to access to MS SQL Server
through OLE DB. But, a number of the port isn't available at this level either.

[MoRpH]

the only thing that you have to do is:
in the connection string add the port just like this:
example:
200.35.157.11,2222
separate this with a coma.
that's it.
have fun