Connecting to SQL Server using Delphi and dbExpress

Question

I use RAD Studio 2010 including latest updates 4 and 5, my database is SQL Server Express.

I set up a TSQLConnection but it won't connect, error message is "DBX-Error: the driver could not be initialized correctly. A client library may be missing, may not be installed correctly, or may have the wrong version" (error messagetranslated from German).

Connecting to the database via TADOConnection works fine with both ADO drivers ("Microsoft OLE DB Provider for SQL Server" and "SQL Native Client").

Can anybody give me a hint how to connect via dbExpress?

Jonathan D · Accepted Answer · 2010-01-05 09:08:26Z

3

you need to install the sql native client, if you read the read me that comes with RAD studio 2010 its says that it is a requirement for connecting to sql server 2000/2005/2008

I’ve also discovered that in dbxdrivers.ini they haven’t added the proper option for MSSQL 2000/2005 you need to edit the top bit to add in MSSQL9=1

example:

[Installed Drivers]
DBXTrace=1
DBXPool=1
BlackfishSQL=1
DataSnap=1
ASA=1
ASE=1
DB2=1
Firebird=1
Informix=1
Interbase=1
MSSQL=1
MSSQL9=1
MySQL=1
Oracle=1

you can then select MSSQL9 as a dbExpress option and it should also appear in data explorer as well

edited Jan 5, 2010 at 9:08

answered Jan 4, 2010 at 23:48

Jonathan D

1,3642 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Joe Meyer Over a year ago

In fact I have sql native client installed

Joe Meyer Over a year ago

The missing entry in the ini was the problem. Now it works fine, thanks a lot

GNiessen · Accepted Answer · 2011-12-13 21:01:47Z

1

I had a similiar issue with Delphi XE2 ad SQL Server 2005. I uninstalled and installed several versions (including MSSQL 2008 R2) of SQL Native Client to no avail. But adding MSSQL9=1 to the ini file worked.

answered Dec 13, 2011 at 21:01

GNiessen

561 bronze badge

Comments

RR-NL · Accepted Answer · 2009-12-17 07:18:29Z

-1

Maybe this thread on the EDN (Embarcadero Developer Network) can be helpful.

answered Dec 17, 2009 at 7:18

RR-NL

1963 silver badges7 bronze badges

1 Comment

Joe Meyer Over a year ago

unfortunately installing sql native client is not an option because I cannot change anything on the target machines

Collectives™ on Stack Overflow

Connecting to SQL Server using Delphi and dbExpress

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related