Re: Installing MSDE 2000 Release A on a XP Home Machine

From: Mark Holahan (mark.holahan_at_unifiedllc.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 06:46:32 -0500

Thanks Jim! Yes...of course. Can you tell I haven't done this before?

Do you have any comment regarding my second question?

Many thanks.

"Jim Young" <thorium48@hotmail.com> wrote in message
news:%23ioGNN0DFHA.3536@TK2MSFTNGP15.phx.gbl...
> You application should utilize a configuration file or the registry to
> store the ADO connection string or the parameters for the connection
> string. Then you would simply change the configuration information to
> point to another server. Making a connection string for a different server
> is easy - just replace one server name with another. See the Books Online
> for more information about ADO or ADO.NET connection strings and how to
> construct them.
>
> Jim
>
> "Mark Holahan" <mark.holahan@unifiedllc.com> wrote in message
> news:unoBXFtDFHA.2600@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> I'd like to install MSDE 2000 Release A on a XP Home machine via the
>> command-prompt switches and parameters. I have two areas of ignorance:
>>
>> 1) At first blush, it seems to me that I'll have disparate server names.
>> By this I mean that when I install MSDE on my computer to conduct the
>> development, it will have the name "Server_Name"\"Instance_Name". My
>> server's called "Dell," So I'll have a MSDE instance of,
>> DELL\"Instance_Name" On the other hand, the target server, an XP Home
>> machine, is called "SherPerf." So this server instance will be named
>> SHERPERF\"Instance_Name"
>>
>> I plan on using an Access adp front end. I don't know how to code viable
>> connection strings around disparate server names. I.E. in development I'm
>> connecting to server name #1; but, in production I'm connecting to server
>> name #2.
>>
>> What am I missing?
>>
>> 2) If I want to use Windows Authentication, should I create a new user?
>> If so, what groups should this user be part of? Is it standard practice
>> to create a user account for MSDE programmatically? If so, how do I do
>> this? LDAP?
>>
>> I realize this is a lot to ask. Thanks in advance.
>> --
>> --
>> Mark Holahan
>>
>
>

Relevant Pages

  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: using (local) server on SQL 2K
    ... addressing points to the "default" SQL Server instance. ... you install MSDE or SQL Server Express with a name, ... >> coded into the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)