MS SQL Server ODBC - ODBC and SQL Alias

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ODBC and SQL Alias

Robert Taylor

2005-05-12, 9:23 am

I'm working in an environment where I'm trying to connect from an
application server using ODBC to a SQL server alias and just want to
make sure I'm not making any assumptions about my configuration.

When configuring the Connection properties for TCP our server setting is
set to the hostname of the server and the alias is hostname\alias_name.
Is this correct?

To add complexity to the process, we are going through a firewall and
the port is set to a port other than 1433 so we are setting the port to
the alternate_port.

Have I understood the Help files correctly for the slightly tweaked
configuration?

Thank you.

Robert

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links