Home Dashboard Directory Help
Search

specify port using SQLNative Client ODBC by JasonJason


Status: 

Closed
 as Won't Fix Help for as Won't Fix


0
0
Sign in
to vote
Type: Suggestion
ID: 252812
Opened: 1/19/2007 5:55:57 AM
Access Restriction: Public
0
Workaround(s)
view

Description

With the ss2000 odbc connection, you could specify the port through a configuration screen. With ss2005 odbc client that screen no longer exists. It would be nice if it still did for use when connecting to sql server on the non-default port.
Details
Sign in to post a comment.
Posted by Microsoft on 3/23/2007 at 3:14 PM
This is still possible. The SS2000 ODBC driver provided a direct link to cliconfg from the ODBC administrator to define a server alias with the same name as the server. SQL Server Native Client does not have the same link from DSN admin, but you can still use cliconfg from the Start/Run menu to define aliases manually, and this will allow you to define an alias with the same name as the server name in a DSN and then configure protocol/TCP port or other connection options.
Posted by Microsoft on 1/22/2007 at 5:59 PM
This is still possible. The SS2000 ODBC driver provided a direct link to cliconfg from the ODBC administrator to define a server alias with the same name as the server. SQL Server Native Client does not have the same link from DSN admin, but you can still use cliconfg from the Start/Run menu to define aliases manually, and this will allow you to define an alias with the same name as the server name in a DSN and then configure protocol/TCP port or other connection options.
Sign in to post a workaround.