XE4 or 6, TSqlConnection and MS Sql Server 2000 |
|
I have new installs of XE4 Ent & XE6 Ent on a machine that has only
ever had the 2000 version (with SP4) of Sql Server installed on it. I
know SS2000 is a bit long in the tooth, but don't have the option of
upgrading it.
I can connect to this Sql Server from D7 fine. However, with XE4 and
XE6, if I set SqlConnection1Connected := True I get the error
'DBX Error: Driver could not be properly initialized. Client library
may be missing, not installed properly, of the wrong version, or the
driver may be missing from the system path.'
The XE4/6 Bin folder is on the system path, but the DBX driver is
trying to use sqlncl10.Dll as the vendor lib, but this is nowwhere on
my system. I have an MSDN URL about it,
http://msdn.microsoft.com/en-us/library/ms131321%28v=sql.100%29.aspx
but that seems to be specific to Sql Server 2008. Will it work with
Sql Server 2000 or is there a SS2000 version available somewhere?
System is Win7Pro 64-bit, btw.
Cheers & TIA
|
Re: XE4 or 6, TSqlConnection and MS Sql Server 2000 |
|
Martyn Ayers wrote:
> The XE4/6 Bin folder is on the system path, but the DBX driver is
> trying to use sqlncl10.Dll as the vendor lib, but this is nowwhere on
> my system.
The file comes from the MSSQL Client install. If you cannot find it,
contact Microsoft on how to get it.
Note that can see support DBX servers here:
http://docwiki.embarcadero.com/RADStudio/XE6/en/Release_Notes_for_XE3#Supported_Servers.
There is notes that MSSQL 2000 is still supported.
|