<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0cm;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:14.0pt;
font-family:Arial;
font-style:italic;}
h3
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:13.0pt;
font-family:Arial;}
h4
{margin-top:3.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.Code, li.Code, div.Code
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:17.85pt;
punctuation-wrap:simple;
text-autospace:none;
font-size:12.0pt;
font-family:"Courier New";}
p.code0, li.code0, div.code0
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:17.85pt;
punctuation-wrap:simple;
font-size:12.0pt;
font-family:"Courier New";}
p.code00, li.code00, div.code00
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:17.85pt;
punctuation-wrap:simple;
font-size:12.0pt;
font-family:"Courier New";}
span.emailstyle18
{font-family:Arial;
color:windowtext;}
span.emailstyle20
{font-family:Arial;
color:navy;}
span.EmailStyle22
{font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It may well do so, and you’d think
the class would provide this most basic functionality, but I don’t see it
in the class browser or in intellisense. So at the moment I’m parsing the
connection string and grabbing the components myself. The code is just simple
arithmetic and all the GETs call the same function, just passing a different
string in (i.e. “Initial Catalog=”) and getting back the word(s)
after that string up to the next semi-colon. But it does seem odd that I have
to write it myself.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>A.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Drew Wutka<br>
<b><span style='font-weight:bold'>Sent:</span></b> February 28, 2003 12:56 AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'accessd@databaseadvisors.com'<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Connection
class?</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;
margin-bottom:.0001pt'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Just out of curiousity
Arthur, are you talking about an ADO Connection object? Can't you just
get the properties from the object itself, or doesn't it split the 'components'
when you give it a connection string? (I would think it would, but I
usually create and open my connection by their individual properties
anyways....)</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;
margin-bottom:.0001pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;
margin-bottom:.0001pt'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Drew</span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
36.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Arthur Fuller [mailto:artful@rogers.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 27, 2003
5:27 PM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Connection
class?</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Thanks a
lot. I think your new nick is ChayLo </span></font><font size=2 color=navy
face=Wingdings><span style='font-size:10.0pt;font-family:Wingdings;color:navy'>J</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Charlotte Foust<br>
<b><span style='font-weight:bold'>Sent:</span></b> February 27, 2003 3:08 PM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Connection
class?</span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:72.0pt;
margin-bottom:.0001pt'><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>Be our guest,
Arthur! I'll download and steal your code when you finish
it.<VBG> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:72.0pt;
margin-bottom:.0001pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:0cm;margin-left:72.0pt;
margin-bottom:.0001pt'><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>Charlotte Foust</span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
72.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Arthur Fuller
[mailto:artful@rogers.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 27, 2003
10:54 AM<br>
<b><span style='font-weight:bold'>To:</span></b> AccessD<br>
<b><span style='font-weight:bold'>Subject:</span></b> [AccessD] Connection
class?</span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Is there a convenient way to extract
the components of a connection string? I wrote some code to do it, using
substring extractions, but hell, there has to be a built-in way that's better
than that! Alternatively, has anyone written such a class? If not, I'll do it
and post it.</span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>TIA,</span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Arthur</span></font></p>
</blockquote>
</blockquote>
</div>
</body>
</html>