Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: XE4 or 6, TSqlConnection and MS Sql Server 2000



Permlink Replies: 1 - Last Post: Jul 14, 2014 8:51 AM Last Post By: quinn wildman
Martyn Ayers

Posts: 73
Registered: 10/7/99
XE4 or 6, TSqlConnection and MS Sql Server 2000
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 14, 2014 6:45 AM
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
quinn wildman

Posts: 856
Registered: 12/2/99
Re: XE4 or 6, TSqlConnection and MS Sql Server 2000
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 14, 2014 8:51 AM   in response to: Martyn Ayers in response to: Martyn Ayers
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.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02