exception class EOLEDBError with message 'QueryInterface failed' with D2007

tprami · Post by **tprami** » Thu 17 Apr 2008 07:28

Hello,

I am trying to configure the dbexpsda40.dll driver.

Created block in the dbxdrivers.ini for the driver: (Copied one from CodeGear driver and changed parts mentioned in Support.html.

Is there something completely wrong here, could not find an example how to configure Connection from the file.

[CoreLabsMsSql]
SchemaOverride=%.dbo
DriverUnit=DBXDynalink
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXDynalinkDriver100.bpl
DriverPackage=DBXCommonDriver110.bpl
DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borland.Data.DbxDynalinkDriver,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
DriverAssembly=Borland.Data.DbxCommonDriver,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=a91a7c5705831a4f

GetDriverFunc=getSQLDriverSQLServer
LibraryName=dbexpsda40.dll
VendorLib=sqlncli
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False
Prepare SQL=False
MetaDataPackageLoader=TDBXMsSqlMetaDataCommandFactory,DbxReadOnlyMetaData100.bpl
MetaDataAssemblyLoader=Borland.Data.TDBXMsSqlMetaDataCommandFactory,Borland.Data.DbxReadOnlyMetaData,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b

tprami · Post by **tprami** » Fri 18 Apr 2008 05:22

Ok,

I got registered version and it had one file with some info.

I canged the ini to look like this, still I have same error message...

[CoreLabsMsSql]
GetDriverFunc=getSQLDriverSQLServer
LibraryName=dbexpsda40.dll
VendorLib=sqloledb.DLL
ProductName=MSSQL
DriverAssemblyLoader=CoreLab.DbxSda.DriverLoader.TCRDynalinkDriverLoader,CoreLab.DbxSda.DriverLoader,Version=X.X.X.XXXX,Culture=neutral,PublicKeyToken=ff94d6466298df78
BlobSize=-1
DataBase=
User_Name=
Password=

Antaeus · Post by **Antaeus** » Wed 23 Apr 2008 15:05

Please, specify on which operation does the problem appear.

tprami · Post by **tprami** » Thu 24 Apr 2008 04:14

Antaeus wrote:Please, specify on which operation does the problem appear.

code path starting from: TDBXMorphicCommand.ExecuteQuery

Code works with Code Gear drivers (or settings, don't know what exactly is not correct for the CoreLabs tough...)...

-TP-

Antaeus · Post by **Antaeus** » Thu 24 Apr 2008 13:18

Please send us a complete small sample at dbxsda*crlab*com to demonstrate the problem, including script to create server objects.

Also supply me the following information:
- exact version of DbxSda;
- exact version of your IDE (including updates);
- exact version of SQL server and client.

tprami · Post by **tprami** » Fri 25 Apr 2008 06:04

Hello,

I don't exatly understand everyting that you wan't to see

Error happens trying to execute this query:

Select convert(varchar,ServerProperty('Edition')), convert(varchar,ServerProperty('ProductLevel')), convert(varchar,ServerProperty('ProductVersion')) as ProductVersion

-TP-

Antaeus · Post by **Antaeus** » Sat 26 Apr 2008 07:14

Thank you for information. I have answered you by e-mail.