Devart Forums

Hi,

I have Embarcadero® C++Builder® XE Professional Version 15.0.3953.35171.

Based on looking at other forums, they say with Professional version you cannot use dbexpress for SQLServer, atleast the design time components.

Kasturi

- I uninstalled the dbexpress drivers.
- Then I searched for dbexpsda*.dll. Did not find anything.
- Then reinstalled the dbexpress trial version.
- Then changed the product name option under the dbxdrivers.ini file to Microsoft SQL Server.
- Created a new project droped a SQLConnection and a SimpleDataSet component to the DataModule form. SQLConnection worked fine and was able to connect to the database. For SimpleDataSet, I was not able to select the table name under the Command Text property. The same error is coming.

I think the "dcldbxsda150.lib" is not available with the C++ Builder professional version and therfore I cant use it with the design time components.

Hi,

I'm using Devart SQLServer (v 4.80.0.29) dbexpress TRIAL version.

Thanks

Hi,

I have dbxdrivers.ini only at "C:\Documents and Settings\All Users\Documents\RAD Studio\dbExpress\8.0".

I have another dbxdrivers.ini at "C:\Documents and Settings\All Users\Documents\RAD Studio\8.0\Samples\DelphiPrism\DelphiPrismWebApp" which just have [Interbase] alone.

Thanks

Hi,

I had changed the ini file, I still get the popup to add the driver unit. The library file "dcldbxsda150.lib" is part of C++ Builder correct, and is not part of DEVART. If that's the case looks like I have the .bpl file but not the related .lib file in my machine. I have copied the modified ini to make sure the parameters are set correctly.
[DevartSQLServer]
GetDriverFunc=getSQLDriverSQLServer
LibraryName=dbexpsda40.dll
VendorLib=sqloledb.dll
BlobSize=-1
HostName=
DataBase=
User_Name=
Password=
ProductName=Microsoft SQL Server
DriverAssemblyLoader=Devart.DbxSda.DriverLoader.TCRDynalinkDriverLoader,Devart.DbxSda.DriverLoader,Version=1.0.0.5001,Culture=neutral,PublicKeyToken=09af7300eec23701
DriverUnit=DBXDevartSQLServer

Thanks

Hi,

I tried the code snippet you had mentioned. It worked but when I add the TSimpleDataSet to a form and try to select a table it shows an error, "dcldbxsda150.lib" is needed.
"dcldbxsda150.lib" is the design package and this file is not present in my machine. We're migrating from BDE to DBExpress and all our components are design time, so let me know how can I get the library files.

Thanks

Hi,

Already my SQLConnection parameters are set correctly as you have mentioned. The TSQLTable component works fine.
For the "TSimpleDataSet", I get the Add driver error when I try to select the table name from "Command Text" property.
My understanding is for TSimpleDataSet, I set the connection property to working SQLconnection, set the command type to "ctTable" and I should be able to get the list of tables in the Command Text.

Kasturi

Hi,

I'm using C++ Builder XE, connecting to MS SQLServer 2005 using the Devart SQLServer (v 4.80.0.29) dbexpress. I'm able to successfully add SQLConnection, SQLTable.
I added a TSimpleDataSet, set the connection property to SQLconnection, set the command type to "ctTable", when I click on the command Text to select the table it throws an error
"Cannot load metadata for Microsoft SQL Server. Add driver unit to your uses (DbxInterBase or DbxDb2 or DbxMsSql or DBXMySQL or DbxOracle or DbxSybaseASA or DbxSybaseASE)."

I understand that I need to include "DbxMsSql", but not sure how to include this.

Thanks
Kasturi