<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
<style>.hmmessage P{margin:0px;padding:0px}body.hmmessage{FONT-SIZE: 10pt;FONT-FAMILY:Tahoma}</style>Neven,<br><br>Thanks for the response.<br><br>I wonder if its because its the 'Express' version of SQL Server 2005? I vaguely recall something about that but I thought it was to do with across the network from another machine other than the local host machine.<br><br>I changed those settings previously (see attached WORD doc with screenshots)<br><br>Eric<br>> Date: Fri, 22 Aug 2008 10:46:12 +1200<br>> From: neven@mwk.co.nz<br>> To: delphi@delphi.org.nz<br>> Subject: Re: [DUG] Delphi ADO Components with MS SQL 2005<br>> <br>> Eric<br>> <br>> Check how you are connecting espo the idiotically named 'Surface Area' <br>> config for your server, by default tcp/ip<br>> is not enabled nor 'remote connections'<br>> <br>> HTH<br>> <br>> Neven<br>> > I'd like to use Delphi 7 (Delphi 2007 second choice) with SQL Server <br>> > 2005. Initially this will be just for development using the version <br>> > installed with Visual Studio 2005 Professional.<br>> ><br>> > I've previously used the Delphi ADO connection objects etc very <br>> > successfully with MS SQL 2000 but I can't see the 2005 SQL server (on <br>> > the local machine) when I try to set up the connection string in <br>> > Delphi 7. I can see the SQL Server 2005 instance OK from Visual <br>> > Studio so it would appear to be something to do with the Delphi ADO <br>> > 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 <br>> > SQL 2005 instead of MS SQL 2000?<br>> ><br>> > 2) Is my issue something to do with the nature of the SQL Server 2005 <br>> > install done by Visual Studio 2005?<br>> ><br>> > 3) Alternatively is there a workaround using some kind advanced <br>> > parameter in the connection string?<br>> ><br>> > Eric<br>> ><br>> ><br>> ><br>> ><br>> ><br>> ><br>> > ------------------------------------------------------------------------<br>> > Click here Find singles in your area with Match. <br>> > <http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fmatch%2Enz%2Emsn%2Ecom%2Fchannel%2Findex%2Easpx%3Ftrackingid%3D1043416&_r=WL_EMAL_TAG&_m=EXT> <br>> ><br>> > ------------------------------------------------------------------------<br>> ><br>> > _______________________________________________<br>> > NZ Borland Developers Group - Delphi mailing list<br>> > Post: delphi@delphi.org.nz<br>> > Admin: http://delphi.org.nz/mailman/listinfo/delphi<br>> > Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe<br>> <br>> _______________________________________________<br>> NZ Borland Developers Group - Delphi mailing list<br>> Post: delphi@delphi.org.nz<br>> Admin: http://delphi.org.nz/mailman/listinfo/delphi<br>> Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe<br><br /><hr />Download today! <a href='http://get.live.com/' target='_new'>Free Windows Live software. Chat, search, share pics and more.</a></body>
</html>