[Mono-list] SQL2K named instance support in System.Data.SqlClient?

Jerkins, Phillip Phillip.Jerkins@morgankeegan.com
Fri, 31 Jan 2003 08:36:45 -0600


This is a multi-part message in MIME format.

------_=_NextPart_001_01C2C936.2E082D60
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello!
=20
I am new to the mailing list concept, and to contributing to open-source
software.  However, I have a great interest (personal and professional)
in mono.  I was wondering if anyone has begun support for named
instances of SQL2K in the System.Data.SqlClient.SqlConnection object.
If not, I would like to contribute.  I have looked at the code for
SqlConnection, and understand it well enough to add this support.  I
have also researched named instance browsing, and I have prototype code
in C# that works.  If no one else is working on this, I will begin
integrating.
=20
1)       Is anyone already working on this?
2)       Which version of the code should I start with?  The latest CVS,
or 0.19?
3)       Is it preferable to develop in WinXP w/ Cygwin, or under RedHat
8.0? (I intend to test under both).
4)       In what format, and where or to whom should I submit my
changes?  Entire replacement files?  DIFFs with the originals?  I may
have firewall issues with CVS - I definitely do at work, and I only have
NetZero (free) Internet at home.
=20
The reasons I'm interested in contributing this are:
1)       I need it - I regularly use the \NetSDK instance installed by
VS.NET as my development SQL instance, and we have several major servers
at work that use named instances (or, at least, non-standard port
numbers).  I checked today's snapshot, and there's still no way to
change the port number.  This feature would be a prerequisite for us to
use mono at work.
2)       I want to gain familiarity with contributing to the mono
project, since it holds so much promise.  It would also be easy, since
it's written in the language I know best (C#).
=20
Thanks!
=20
Phil Jerkins
=20


*************************************************************************=
*************************
Morgan Keegan & Co., Inc. DOES NOT ACCEPT ORDERS AND/OR=20
INSTRUCTIONS REGARDING YOUR ACCOUNT BY E-MAIL.  Transactional details=20
do not supersede normal trade confirmations or statements.  The informati=
on=20
contained in this transmission is privileged and confidential. It is inte=
nded for the use of=20
the individual or entity named above. The information contained herein is=
 based on=20
sources we believe reliable but is not considered all-inclusive. Opinions=
 are our current=20
opinions only and are subject to change without notice.  Offerings are su=
bject to prior=20
sale and/or change in price.  Prices, quotes, rates and yields are subjec=
t to change=20
without notice.  Morgan Keegan & Co., Inc., member NYSE, NASD and SIPC, i=
s a=20
registered broker-dealer subsidiary of Regions Financial Corporation.  In=
vestments are=20
NOT FDIC INSURED, NOT BANK GUARANTEED and MAY LOSE VALUE.  Morgan=20
Keegan & Co., Inc. reserves the right to monitor all electronic correspon=
dence.


http://www.morgankeegan.com
*************************************************************************=
*************************

------_=_NextPart_001_01C2C936.2E082D60
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:=
schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html=
40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C2C903.E34CEEF0">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:536871559 0 0 0 415 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:windowtext;}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes;}
span.GramE
	{mso-style-name:"";
	mso-gram-e:yes;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 @list l0
	{mso-list-id:23478979;
	mso-list-type:hybrid;
	mso-list-template-ids:-455941394 67698705 67698713 67698715 67698703 676=
98713 67698715 67698703 67698713 67698715;}
@list l0:level1
	{mso-level-text:"%1\)";
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l1
	{mso-list-id:1011568783;
	mso-list-type:hybrid;
	mso-list-template-ids:1802959012 67698705 67698713 67698715 67698703 676=
98713 67698715 67698703 67698713 67698715;}
@list l1:level1
	{mso-level-text:"%1\)";
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
ol
	{margin-bottom:0in;}
ul
	{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>
<![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple style=3D'tab-interval:.5in'=
>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'>Hello!<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'>I am new to the mailing list concept, and to contribut=
ing to
open-source software. <span style=3D'mso-spacerun:yes'>&nbsp;</span>Howev=
er, I
have a great interest (personal and professional) in mono.<span
style=3D'mso-spacerun:yes'>&nbsp; </span>I was wondering if anyone has be=
gun
support for named instances of SQL2K in the <span class=3DSpellE>System.D=
ata.SqlClient.SqlConnection</span>
object.<span style=3D'mso-spacerun:yes'>&nbsp; </span>If not, I would lik=
e to
contribute.<span style=3D'mso-spacerun:yes'>&nbsp; </span>I have looked a=
t the
code for <span class=3DSpellE>SqlConnection</span>, and understand it wel=
l enough
to add this support.<span style=3D'mso-spacerun:yes'>&nbsp; </span>I have=
 also
researched named instance browsing, and I have prototype code in C# that
works.<span style=3D'mso-spacerun:yes'>&nbsp; </span>If no one else is wo=
rking on
this, I will begin integrating.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l0 level1 lfo1;
tab-stops:list .5in'><![if !supportLists]><font size=3D2 face=3DArial><sp=
an
style=3D'font-size:10.0pt;font-family:Arial;mso-fareast-font-family:Arial=
'><span
style=3D'mso-list:Ignore'>1)<font size=3D1 face=3D"Times New Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; </span></font></span></span></font><![endif]><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>=
Is anyone
already working on this?<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l0 level1 lfo1;
tab-stops:list .5in'><![if !supportLists]><i style=3D'mso-bidi-font-style=
:normal'><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;m=
so-fareast-font-family:
Arial;font-style:italic;mso-bidi-font-style:normal'><span style=3D'mso-li=
st:Ignore'>2)<font
size=3D1 face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Ro=
man"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></span></font></i><![endif]><font size=3D2 face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial'>Which version of the code sh=
ould I
start with?<span style=3D'mso-spacerun:yes'>&nbsp; </span>The latest <spa=
n
class=3DGramE>CVS,</span> or 0.19?<i style=3D'mso-bidi-font-style:normal'=
><span
style=3D'font-style:italic;mso-bidi-font-style:normal'><o:p></o:p></span>=
</i></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l0 level1 lfo1;
tab-stops:list .5in'><![if !supportLists]><i style=3D'mso-bidi-font-style=
:normal'><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;m=
so-fareast-font-family:
Arial;font-style:italic;mso-bidi-font-style:normal'><span style=3D'mso-li=
st:Ignore'>3)<font
size=3D1 face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Ro=
man"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></span></font></i><![endif]><font size=3D2 face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial'>Is it preferable to develop =
in <span
class=3DSpellE>WinXP</span> w/ <span class=3DSpellE>Cygwin</span>, or und=
er <span
class=3DSpellE>RedHat</span> 8.0? (I intend to test under both).<i
style=3D'mso-bidi-font-style:normal'><span style=3D'font-style:italic;mso=
-bidi-font-style:
normal'><o:p></o:p></span></i></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l0 level1 lfo1;
tab-stops:list .5in'><![if !supportLists]><i style=3D'mso-bidi-font-style=
:normal'><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;m=
so-fareast-font-family:
Arial;font-style:italic;mso-bidi-font-style:normal'><span style=3D'mso-li=
st:Ignore'>4)<font
size=3D1 face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Ro=
man"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></span></font></i><![endif]><font size=3D2 face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial'>In what format, and where or=
 to whom
should I submit my changes? <span style=3D'mso-spacerun:yes'>&nbsp;</span=
>Entire
replacement files?<span style=3D'mso-spacerun:yes'>&nbsp; </span><span
class=3DSpellE>DIFFs</span> with the originals?<span
style=3D'mso-spacerun:yes'>&nbsp; </span>I may have firewall issues with =
CVS &#8211;
I definitely do at work, and I only have <span class=3DSpellE>NetZero</sp=
an> (free)
Internet at home.<i style=3D'mso-bidi-font-style:normal'><span style=3D'f=
ont-style:
italic;mso-bidi-font-style:normal'><o:p></o:p></span></i></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'>The reasons I&#8217;m interested in contributing this =
are:<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l1 level1 lfo2;
tab-stops:list .5in'><![if !supportLists]><font size=3D2 face=3DArial><sp=
an
style=3D'font-size:10.0pt;font-family:Arial;mso-fareast-font-family:Arial=
'><span
style=3D'mso-list:Ignore'>1)<font size=3D1 face=3D"Times New Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; </span></font></span></span></font><![endif]><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>=
I need it &#8211;
I regularly use the \<span class=3DSpellE>NetSDK</span> instance installe=
d by
VS.NET as my development SQL instance, and we have several major servers =
at
work that use named instances (or, at least, non-standard port numbers). =
<span
style=3D'mso-spacerun:yes'>&nbsp;</span>I checked today&#8217;s snapshot,=
 and there&#8217;s
still no way to change the port number.<span style=3D'mso-spacerun:yes'>&=
nbsp;
</span>This feature would be a prerequisite for us to use mono at work.<o=
:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in;text-indent:-.25in;mso-lis=
t:l1 level1 lfo2;
tab-stops:list .5in'><![if !supportLists]><i style=3D'mso-bidi-font-style=
:normal'><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;m=
so-fareast-font-family:
Arial;font-style:italic;mso-bidi-font-style:normal'><span style=3D'mso-li=
st:Ignore'>2)<font
size=3D1 face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Ro=
man"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></span></font></i><![endif]><font size=3D2 face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial'>I want to gain familiarity w=
ith
contributing to the mono project, since it holds so much promise.<span
style=3D'mso-spacerun:yes'>&nbsp; </span>It would also be easy, since it&=
#8217;s
written in the language I know best (C#).<i style=3D'mso-bidi-font-style:=
normal'><span
style=3D'font-style:italic;mso-bidi-font-style:normal'><o:p></o:p></span>=
</i></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'>Thanks!<i style=3D'mso-bidi-font-style:normal'><span
style=3D'font-style:italic;mso-bidi-font-style:normal'><o:p></o:p></span>=
</i></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size=
:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span style=3D'font-s=
ize:10.0pt;
font-family:Verdana;mso-no-proof:yes'>Phil Jerkins<o:p></o:p></span></fon=
t></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D=
'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

<FONT SIZE=3D3 COLOR=3DBLUE><PRE>****************************************=
**********************************************************
Morgan Keegan & Co., Inc. DOES NOT ACCEPT ORDERS AND/OR=20
INSTRUCTIONS REGARDING YOUR ACCOUNT BY E-MAIL.  Transactional details=20
do not supersede normal trade confirmations or statements.  The informati=
on=20
contained in this transmission is privileged and confidential. It is inte=
nded for the use of=20
the individual or entity named above. The information contained herein is=
 based on=20
sources we believe reliable but is not considered all-inclusive. Opinions=
 are our current=20
opinions only and are subject to change without notice.  Offerings are su=
bject to prior=20
sale and/or change in price.  Prices, quotes, rates and yields are subjec=
t to change=20
without notice.  Morgan Keegan & Co., Inc., member NYSE, NASD and SIPC, i=
s a=20
registered broker-dealer subsidiary of Regions Financial Corporation.  In=
vestments are=20
NOT FDIC INSURED, NOT BANK GUARANTEED and MAY LOSE VALUE.  Morgan=20
Keegan & Co., Inc. reserves the right to monitor all electronic correspon=
dence.


http://www.morgankeegan.com
*************************************************************************=
*************************
</PRE></FONT>
</body>

</html>
=00

------_=_NextPart_001_01C2C936.2E082D60--