Mega Search
23.2 Million


Sign Up

Make a donation  
XE4 or 6, TSqlConnection and MS Sql Server 2000  
News Group: embarcadero.public.delphi.database.dbexpress

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

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 14-Jul-2014, at 6:45 AM EST
From: Martyn Ayers
 
Re: XE4 or 6, TSqlConnection and MS Sql Server 2000  
News Group: embarcadero.public.delphi.database.dbexpress
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.

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 14-Jul-2014, at 8:51 AM EST
From: quinn wildman