Alias for a database name?

From: David Sworder (GilGrissom_at_CSILasVegas.com)
Date: 03/18/04 

Date: Wed, 17 Mar 2004 18:19:25 -0800

Hi there,

    I'm using SQL Server 2000.

    I've created a database that has the name "SworderNet.ProductAnalysis."
Various applications connect to this database using this name. Well, it
turns out that certain programs like Excel have a problem accessing SQL
databases that have a "." in the name. The simplest solution is obviously to
just rename the database but it would be a major hassle to try to track down
all of the various clients that use this database and change the
appropriate config files to reflect the new name. Is there a way to create
an "alias" name for this database (similar to a CNAME record in dns)? For
example, I'd like to create an alias called "ProductAnalysis"... The
original name would still work, but clients that have problems with "."
embedded in the database name can just use the alias name instead.

    Is it possible? 

-- 
Sincerely,
David Sworder

Relevant Pages

  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: Access vs SQL
    ... > to SQL. ... Are you using the database primarily as a storage place, ... If you have many updates then you need to constantly compact it. ... No additional cost to your clients. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Programatically adding Fields to an existing Database (using SQL)
    ... database to new clients, ... This piece of code is expected to return the datatype of the field ... I found SQL to be the only way to add the field on the fly but I ...
    (borland.public.delphi.database.ado)
  • Re: Synching between Access and MSSQL
    ... Look at SQL Server replication. ... How long will the clients be disconnected, i.e. max number of days without ... > SQL database and the clients would work offline with this data and later ...
    (microsoft.public.access.externaldata)
  • Re: Does my client need SBS ?
    ... using a proper database for such is much better than using word. ... Most users use a read-only SQL account so as ... More commonly my clients would maintain such a list in Excel, ... I am trying to convince one of my clients that they need SBS 2003. ...
    (microsoft.public.windows.server.sbs)