By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,010 Members | 2,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,010 IT Pros & Developers. It's quick & easy.

Alias name for addressing SQL databases

P: n/a
I have a number of MS Access apps that link to SQL Sever tables. If
the SQL Sever database is moved to another server, or the server is
replaced, the unc address to the database changes as the server name
has changed. All my apps fall over as the linked tables are addressed
using the server name.

Is there a way to set up an alias name for an SQL database so that you
can link to the tables through an ODBC connection without using the
server name.

Thanks in advance
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can setup an alias for the server using the SQL Server Client Network
Utility. You can also do this while setting up an ODBC DSN.

I'm not sure I fully understand your situation, though. If you've linked
SQL Server tables using an ODBC DSN, only the DSN is stored in your
connection string. Moving/renaming the server shouldn't require changes to
your app but you'll still need to change the server name on each client
using the Client Network Utility or ODBC DSN Administrator.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Grant Hammond" <te*******@clear.net.nz> wrote in message
news:5e**************************@posting.google.c om...
I have a number of MS Access apps that link to SQL Sever tables. If
the SQL Sever database is moved to another server, or the server is
replaced, the unc address to the database changes as the server name
has changed. All my apps fall over as the linked tables are addressed
using the server name.

Is there a way to set up an alias name for an SQL database so that you
can link to the tables through an ODBC connection without using the
server name.

Thanks in advance

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.