QualityCentral

Public Report

Report From: Delphi-BCB/Database/Data Explorer [ Add a report in this area ]

Report #: 92502

Status: Closed

Error in DataExplorer when adding a new MSSQL connection

Project: Delphi

Build #: 15.0.3953.35171

Version: 15.1

Submitted By: Robert Triest

Report Type: Crash / Data loss / Total failure

Date Reported: 3/23/2011 1:35:44 AM

Severity: Serious / Highly visible problem

Last Updated: 3/23/2011 6:32:52 PM

Platform: All versions

Internal Tracking #:

Resolution: Test Case Error (Resolution Comments)

Resolved in Build: : None

Duplicate of: None

Voting and Rating

Overall Rating: No Ratings Yet

0.00 out of 5

Total Votes: None

Description

Problems connecting to SQLServer 2005 database via DBExpress in Delphi XE.

First I tried directly to setup the SQLConnection component on a form and it gave me an error.
"DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, or of the wrong version"

I searched on Google and found many problems related and I figured out that I needed
the SQL Native Driver for SQLServer 2008.

When I installed the driver everything was ok, except for the DataExplorer in the IDE.
I like to add the database in the dataexplorer tree and when I create a new connection under MSSQL,
configure the properties like in the SQLConnection component, try to connect and it gives an error:

"System.IO.FileLoadException: Could not load file or assembly "Borland.Data.DbxCommonDriver\,
Version\=$ASSEMBLY_VERSION$\,Culture\=neutral\,PublicKeyToken\=91d62ebb5b0d1b1b' or one of its dependencies.
The given assembly name or codebase was invalid. (Exception from HResult: 0x80131047)"

With the SQLConnection component on a form I can just connect and add queries but the DataExplorer
refuses to make a connection.

Steps to Reproduce:

add a database in the dataexplorer tree
create a new connection under MSSQL,
configure the properties
test connection
error.

"System.IO.FileLoadException: Could not load file or assembly "Borland.Data.DbxCommonDriver\,
Version\=$ASSEMBLY_VERSION$\,Culture\=neutral\,PublicKeyToken\=91d62ebb5b0d1b1b' or one of its dependencies.
The given assembly name or codebase was invalid. (Exception from HResult: 0x80131047)"

Workarounds

None

Attachment

None

Comments

Robert Triest at 3/23/2011 8:03:16 AM -

Maybe related to QC#87938

Robert Triest at 3/23/2011 8:41:07 AM -

I did a clean installation of XE on a new machine and
there the dataexplorer is OK and can connect.

It seems maybe related with my 1st installation of
Delphi Rad Studio 2009. I did the XE installation
on the same machine.

I still don't know what to do to let the data explorer
work in Delphi XE.

Tomohiro Takahashi at 3/23/2011 6:35:29 PM -

> ... I figured out that I needed the SQL Native Driver for SQLServer 2008. ...
Yes, if you connect any SQL Server from Delphi XE(DataExplorer), please use 'Native Client Library for SQL Server 2008', because DataExplorer is based on dbExpress layer.

Please see also this docwiki.
[dbExpress Database Specific Information]
http://docwiki.embarcadero.com/RADStudio/XE/en/DbExpress_Database_Specific_Information#MS_SQL

Robert Triest at 4/12/2011 1:04:43 AM -

See issue #92553

Problem solved.

Deleted all the dbxdrivers.ini dbxconnections.ini files
from C:\Users\Public\Documents\RAD Studio\dbExpress\8.0

From a clean DelphiXE installation on an other machine
with no other version of Delphi installed I copied all the
files from this RAD Studio\dbExpress\8.0 folder to
my machine.

I was able to make a connection via the dataexplorer
to the MSSQL server.

The problem must be mixing different Delphi versions
on one machine. In my case I installed Delphi XE on a
machine that already had Delphi Rad Studio 2009 on it.

Robert Triest at 3/24/2011 7:30:06 AM -

Yes, that I already figured out. I installed the driver for 2008 and
using DBExpress in code (components) works fine.

BUT

the Data Explorer in the Delphi IDE refuses to work.
I tried everything but it keeps me telling the "System.IO.FileLoadException" Error.

Developer Tools

Database Tools