[DUG] Delphi ADO Components with MS SQL 2005

[Myles Penlington]

Is not an issue with either, you probably need to include the instance
name in the connection string.

 

E.g.  server\instancename  i.e. MyServer\SQL2005

 

Myles.

 

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]
On Behalf Of Eric A
Sent: Friday, 22 August 2008 10:38 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Delphi ADO Components with MS SQL 2005

 

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> 



Attention:
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080822/93e82e76/attachment.html