ODBC Connection on a non-default port

[Olaf S]

Hi,

thanks (again) for your reply. However, it didn't help. So I monitored what happens when you de-klick the "dynamically determine port" checkbox and enter the port your config needs. It creates and HKLM entry (at least for a "system" ODBC entry):

Code: Select all

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo]
"[server]\\[instance]"="DBMSSOCN,[server]\\[instance],[port]"

This helped, I can now connect to the database.

[Daniel]

Hello Olaf,

Thank you for your follow up on this and for sharing your solution with us. Certainly this info will be useful for other users too.

All the best,
Daniel