Re: Networking

re:
I certainly wouldn't even consider it for
any database with under a hundred users.

you mean.. if you had 99 users, then you would just run around and
change the server names (IN FOUR DIFFERENT AREAS) on 99 different
desktops?

that sure sounds to me -- like you don't know WTF you're talking about

-Aaron




On May 16, 9:35 am, "Arvin Meyer [MVP]" <a...@xxxxx> wrote:
A CName or Canonical name is the fully qualified domain name and has nothing
at all to do with a particular server other than being listed by a
responsible DNS server. ALL servers within that domain share that CName. If
you are an enterprise with a large number of users (many times more than
would ever be using an Access database), it might save a slight amount of
time to create a CName of a database server, or for a cluster of servers. I
wouldn't bother for a single server which hosted less than a few hundred
user connections. The performance hit for it to resolve a CName, especially
on a LAN is totally unnecessary. I certainly wouldn't even consider it for
any database with under a hundred users. The technique that you mentioned is
new and untested by more than a few, and I doubt that you've ever seen a
first-hand implementation. If you'd bother to look, this is an Access forum,
where most questions have to do with less than 20 users. It is NOT a
SQL-Server forum, although we can and do answer relevant questions
concerning structure and connectivity.

The reason you are here is more than likely the SQL-Server experts have
roundly laughed you out of their newsgroups. The Access experts are doing
the same. Reading a new technique and spouting unrelated answers is a waste
of your own time, as well as ours. Do something useful for this newsgroup or
go away.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

<aaron.ke...@xxxxxxxxx> wrote in message

news:3677e92e-3523-447f-985d-503e92b238bc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx://blogs.techrepublic.com.com/networking/?p=460

The DNS CNAME record is probably the greatest tool as an administrator
that we can use to facilitate moves and changes in the backend when
using Active-Directory integraded DNS. Using the CNAME record for
database connectivity is a new strategy I have started to use to
facilitate server moves simply with the DNS change. Take the following
example:

FQDN Server Name:  DATASERVER1.AMCS.TLD
Associated CNAME:   CORPDB.AMCS.TLD

Now, DATASERVER1 is a Windows cluster for Microsoft SQL Server with a
disaster recovery site with the databases mirrored. If that is needed
to be used, the CORPDB record points to DATASERVER2 to redirect client
traffic to that database server. But, the management does not stop
there. This accomodates for a single change in DNS to point the server
in question to the remote data center (RDC) database engine as a
different FQDN name. But, I’ve been taking this a step further with
CNAME use. For each database, I have been creating a CNAME record that
points to the relevant server or DNS CNAME that the database is
currently housed upon. Further, I make these CNAME records self-
documenting in their nomenclature so that looking at the DNS records
tells you everything needed. Here is an example:

Associated CNAME:   DB-DATABASENAME-STATE.AMCS.TLD
FQDN server name of target host:  CORPDB.AMCS.TLD

In this example, DB indicates a database, DATABASENAME would be the
application name and STATE would refer to the implemenation level
(Live, Test, etc.). All of these relevant records starting with DB-
helps in alphabetical sorting in the DNS console. By using CNAME
records in this fashion, all client connectivity is pointed to the DNS
record instead of the server name. This permits a move of the server
and a move of the individual database to be transparent of any
configuration outside of DNS record management. By pointing all client
connectivity to the CNAME record, configuration changes are not
required (other than clearing a DNS cache) on the clients accessing
the databases.

On May 15, 9:51 pm, "Arvin Meyer [MVP]" <a...@xxxxx> wrote:



Son, go find somewhere else to play. You have no idea what you're talking
about. I can't image any responsible DBA doing that. DNS records are used
to
publish domain and mail server IPs, and that's it.

The number of inaccurate answer you post is nothing short of phenomenal.
It
sounds like you've read a book or 2 and remember some key words but
nothing
else. We all know better. Do us all a favor and take your nonsense
somewhere
where no one has any idea what you are talking about and thinks you might
be
intelligent. How about alt.abuse.offender? Perhaps you can learn some
manners and good sense there as well.
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv....

<aaron.ke...@xxxxxxxxx> wrote in message

news:8230d2d2-930d-4714-be8c-4ef39710b7f8@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
and for the record, I usually implement DNS C Names in order to use
pointers for all my apps.
Then instead of changing the connection string (IN ONE PLACE) I just
change the DNS pointer.

now _THAT_ is an enterprise level idea!

-Aaron

On May 15, 1:07 am, "Arvin Meyer [MVP]" <a...@xxxxx> wrote:

Linking an ADP is no different than linking an MDB to SQL-Server or any
other RDBM for front-end changes. It isn't easier at all since if one
moves
the server, because one needs to build a new DSN or rewrite the
connection
strings, and one only needs to relink to the native JET DBMS.
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...

<aaron.ke...@xxxxxxxxx> wrote in message

news:4cb4f3b0-5ad5-4f67-bbaa-a1860bbc2ca6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
yes, if you change a table, then you've got to relink it in 5
different places.

that is why it is considerably easier to move to SQL Server / ADP.

-Aaron

On May 8, 3:55 am, Roger Bell <RogerB...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have designed a data base which I wish to install on 5 remote
computers.

My idea is to link the Backend (Tables). My question is if i change
any
reports/mailing labels etc on the server data Base, do I then have to
change
the design on each of the remotes.

Is there any difference between splitting and linking, or is there a
way
to
change any report designs that will automatically update on the
remotes.

Many thanks for any help- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: My FC3 machine appears to be compromised, please help
    ... CNAME wc.funnel.revenuedirect.com.akadns.net. ... DNS server is correct and there are no canonical entries. ... On outbound mail, sendmail normally reverse-resolves its ...
    (Fedora)
  • Re: Networking
    ... responsible DNS server. ... ALL servers within that domain share that CName. ... time to create a CName of a database server, or for a cluster of servers. ... The DNS CNAME record is probably the greatest tool as an administrator ...
    (microsoft.public.access.gettingstarted)
  • Re: My FC3 machine appears to be compromised, please help
    ... CNAME wc.funnel.revenuedirect.com.akadns.net. ... DNS server is correct and there are no canonical entries. ... On outbound mail, sendmail normally reverse-resolves its ...
    (Fedora)
  • Re: Networking
    ... DNS records are used to ... publish domain and mail server IPs, ... The DNS CNAME record is probably the greatest tool as an ... traffic to that database server. ...
    (microsoft.public.access.gettingstarted)
  • Re: Help with anonymous access
    ... If you change it in the database, ... That sharepoint central administrator url is populated by whatever you have ... Go to iis administrator on the server. ... You want the IP address of this server, port 80, and the DNS* you will be ...
    (microsoft.public.sharepoint.windowsservices)