[DUG] Delphi ADO Components with MS SQL 2005

[Eric A]

Neven,

Thanks for the response.

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.

I changed those settings previously (see attached WORD doc with screenshots)

Eric
> Date: Fri, 22 Aug 2008 10:46:12 +1200
> From: neven at mwk.co.nz
> To: delphi at delphi.org.nz
> Subject: Re: [DUG] Delphi ADO Components with MS SQL 2005
> 
> Eric
> 
> Check how you are connecting espo the idiotically named 'Surface Area' 
> config for your server, by default tcp/ip
> is not enabled nor 'remote connections'
> 
> HTH
> 
> Neven
> > 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.
> >
> > 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)
> >
> > Questions:
> >
> > 1) Can one use the Delphi ADO components in both D7 and D2007 with MS 
> > SQL 2005 instead of MS SQL 2000?
> >
> > 2) Is my issue something to do with the nature of the SQL Server 2005 
> > install done by Visual Studio 2005?
> >
> > 3) Alternatively is there a workaround using some kind advanced 
> > parameter in the connection string?
> >
> > Eric
> >
> >
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> > Click here Find singles in your area with Match. 
> > <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> 
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi at delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
> 
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe

_________________________________________________________________
Free Windows Live software. Chat, search, share pics and more
http://get.live.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080822/e5ff8ae2/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQL 2005 Config.doc
Type: application/msword
Size: 167936 bytes
Desc: not available
Url : http://listserver.123.net.nz/pipermail/delphi/attachments/20080822/e5ff8ae2/attachment-0001.doc