<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Thanks, Myles et al. Problem solved. <br><br>I should have tried that. Its just that instances of SLQ2000 show up automatically in the connection string builder's server selection combo box, but not SQLEXPRESS.<br><br><hr>Date: Fri, 22 Aug 2008 10:55:31 +1200<br>From: myles@ams.co.nz<br>To: delphi@delphi.org.nz<br>Subject: Re: [DUG] Delphi ADO Components with MS SQL 2005<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .EC_shape
{;}
</style>
<style>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_EmailStyle18
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
</style>
<div class="EC_Section1">
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);">Is not an issue with either, you probably need to include the
instance name in the connection string.</span></p>
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);">E.g. server\instancename i.e. MyServer\SQL2005</span></p>
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);">Myles.</span></p>
<p class="EC_MsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="EC_MsoNormal"><b><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';" lang="EN-US">From:</span></b><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';" lang="EN-US"> delphi-bounces@delphi.org.nz
[mailto:delphi-bounces@delphi.org.nz] <b>On Behalf Of </b>Eric A<br>
<b>Sent:</b> Friday, 22 August 2008 10:38 a.m.<br>
<b>To:</b> NZ Borland Developers Group - Delphi List<br>
<b>Subject:</b> Re: [DUG] Delphi ADO Components with MS SQL 2005</span></p>
</div>
</div>
<p class="EC_MsoNormal"> </p>
<p class="EC_MsoNormal" style="margin-bottom: 12pt;"><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';">I'd like to use Delphi 7 (Delphi 2007 second
choice) with SQL Server 2005. Initially this will be just for development
using the version installed with Visual Studio 2005 Professional.<br>
<br>
I've previously used the Delphi ADO connection objects etc very
successfully with MS SQL 2000 but I can't see the 2005 SQL server (on the local
machine) when I try to set up the connection string in Delphi 7. I can
see the SQL Server 2005 instance OK from Visual Studio so it would appear
to be something to do with the Delphi ADO components not being compatible (or
something that I'm missing)<br>
<br>
Questions:<br>
<br>
1) Can one use the Delphi ADO components in both D7 and D2007 with MS SQL 2005
instead of MS SQL 2000?<br>
<br>
2) Is my issue something to do with the nature of the SQL Server 2005 install
done by Visual Studio 2005?<br>
<br>
3) Alternatively is there a workaround using some kind advanced parameter in
the connection string?<br>
<br>
Eric<br>
<br>
<br>
<br>
<br>
<br>
</span></p>
<div class="EC_MsoNormal" style="text-align: center;" align="center"><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';">
<hr align="center" size="2" width="100%">
</span></div>
<p class="EC_MsoNormal"><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';">Click
here <a href="http://a.ninemsn.com.au/b.aspx?URL=http://match.nz.msn.com/channel/index.aspx?trackingid%3D1043416&_r=WL_EMAL_TAG&_m=EXT" target="_blank">Find singles in your area with Match.</a></span></p>
</div>
<font face="Verdana" size="1">Attention:<br>This communication is confidential
and may be legally privileged. If you are not the intended recipient,
please do not use, disclose, copy or distribute it, other than to return it to
us with your confirmation that it has been deleted from your
system.<br></font>
<br /><hr />Click here <a href='http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fmsn%2Eseek%2Eco%2Enz%2FID%5FSEEKNZMAIN%5FUSR%2FPages%2Falliance%5Fhomepage%2Eascx%3FComeFrom%3Dmsnnz%26tracking%3Dsk%3Asptlmini%3Ask%3Amsnnz%3A0%3Awindowslive%3A%231&_t=757263783&_r=Seek_NZ_tagline_no1&_m=EXT' target='_new'>SEEK New Zealand's #1 jobsite</a></body>
</html>