Re: MDAC 2.1 and SQL Server 2000
From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 06/28/04
- Next message: PEACEMAKER: "how to get a list of constraint names or ids from sql server 2000?"
- Previous message: Ross McKay: "Re: ADO and Oracle PL/SQL Table"
- In reply to: Phil: "Re: MDAC 2.1 and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Jun 2004 05:06:10 GMT
"William (Bill) Vaughn" wrote:
>> MDAC 2.1 is fraught with problems. Memory leaks, and a bevy of other issues.
>> Yes, there are "issues" galore.
Phil wrote:
>But are there any issues specific to using it with SQL Server 2000,
>other than its inability to handle named instances?
It will work, at least against the default server name. If you have a
named instance (e.g. BIGSERVER\SQL2K) then it will not work with that
name, but you can configure an alias using SQL Server's Client Network
Utility and connect that way, I believe.
However, as Bill says, there are problems in 2.1 that have been resolved
in later versions, so you'd be *much* better off using a later version.
-- "There is more to life than simply increasing its speed." - Mahatma Gandhi
- Next message: PEACEMAKER: "how to get a list of constraint names or ids from sql server 2000?"
- Previous message: Ross McKay: "Re: ADO and Oracle PL/SQL Table"
- In reply to: Phil: "Re: MDAC 2.1 and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
