Thanks, Myles et al. Problem solved.
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.
Date: Fri, 22 Aug 2008 10:55:31 +1200
From: [EMAIL PROTECTED]
To: delphi@delphi.org.nz
Subject: Re: [DUG] Delphi ADO Components with MS SQL 2005
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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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.
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.
_________________________________________________________________
SEEK New Zealand's #1 jobsite
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
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
