<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=687335503-19022003><FONT face=Arial color=#0000ff size=2>I
would like to think that the answer is yes, but have not discovered said
portable solution. Where does this list of connections come from? That's the
problem! Best I've come up with is a data-driven list of previous connections,
to which the user can add. But this is not equivalent to
intellisense!</FONT></SPAN></DIV>
<DIV><SPAN class=687335503-19022003></SPAN> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003>Since I have several dev-boxes, I typically rename them
to match the server owned by the current client. </SPAN><SPAN
class=687335503-19022003><FONT>Imperfect solution, I readily admit,
but no-brainer may be. Alternatively, sidestep any autoexec macros
&c. and have at least one box upon which all your dev-software is loaded, so
that you can build an ADE on-site and then distribute
that.</FONT></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003>Currently I have a need for some more elegant solution
to said problem. I want the app to open with the default connection, and failing
said connect, to prompt the user to select an appropriate db. Possible answers
include previously visited dbs on remote servers, local dbs with a name-pattern,
and new servers containing dbs corresponding to said naming
pattern.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003>I am not at all sure how to provide this functionality.
Any suggestions, algorithms (Al Gore Rhythms) welcomed! Since I am just
sketching this out, you cannot hurt my feelings or my code-pride :-) I'm willing
to read the most unorthodox solutions.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003>I want my ADP to open on the previously declared
database, but also to allow the user to select any previously-declared
compatible database (residing anywhere on the accessible intranet) or to create
a new connection to some db residing on a hitherto-unknown server. In the
absence of said previously-declared db/server, I want the user to be able to
define and navigate to some new db of interest. (We just bought a company in
DesMoines and want to inhale its data; find me a server, link me to it, and
apply said cubes to said db. Is this possible?</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=687335503-19022003>A.</SPAN></FONT></FONT></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
dba-sqlserver-admin@databaseadvisors.com
[mailto:dba-sqlserver-admin@databaseadvisors.com] <B>On Behalf Of </B>Myke
Myers<BR><B>Sent:</B> February 18, 2003 2:19 PM<BR><B>To:</B>
dba-sqlserver@databaseadvisors.com<BR><B>Subject:</B> [dba-SQLServer]Access
2000 Adp Connection<BR><BR></FONT></DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial size=2>I am responsible
for enhancing a frontend Access 2000 Adp that is used in two locations by a
corporate client.</FONT></SPAN></DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial size=2>The server I use
for development does NOT have the same name as either of the two production
servers.</FONT></SPAN></DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial size=2>Is there any way
to build in an "auto detect" feature so it looks for a server name on start up
and selects the appropriate server in the list of
connections?</FONT></SPAN></DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial
size=2>TIA,</FONT></SPAN></DIV>
<DIV><SPAN class=835451419-18022003><FONT face=Arial
size=2>Myke</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>