Newbie question...

[StefanA]

I have Dephi 2010 pro and bought the Sql server package since it's not in that version of Delphi.. I run XP SP3 and SQLExpess 2008..
With ADO there's no problem accessing tables in databases on the server, with dbExpress driver I get:

Unable to cast object of type 'Devart.DbxSda.DriverLoader.TCRDynaLinkDriverLoader' to type 'Borland.Data.TDBXDriverLoader'

Even when trying to access the demo databases provided...

I know, I'm missing something obvious... bare with me..

[Dimon]

Please specify if you are using the SDAC components or DbxSda (dbExpress driver for SQL Server).
If you are using DbxSda try to use Query Demo and check if the problem persists.

[StefanA]

Thank's for the reply!

I bought and installed the DbxSda for SQL Server, sorry I missed to mention that. I have recomplied the suggested libs mentioned in the readme file, but noticed when compiling the Query example the warning 'Unit DBExpress is deprecated'... wonder what I missed?

I run the example but get errors that the database don't exists or can't be opened...

If I try to look at the tables in Data Explorer I get the error mentioned above...

The server is local on the development machine if that has anything to do with it?

[Dimon]

In the Query demo of DbxSda the standard Northwind database is used. To change this database set an appropriate parameter for TSQLConnection, like this:

Code: Select all

  SQLConnection.Params.Values['DataBase'] := 'DataBaseName';

Also to solve the problem delete the declaration of the DBExpress unit from the uses clause of the Main.pas file.

[Dimon]

Note: DbxSda does not support Data Explorer of RAD Studio 2010 because Data Explorer is a .NET application, and DbxSda does not support .NET under RAD Studio 2010.

[StefanA]

Thank's!!!

You pinpointed the problem, many thank's!!
Now I have tested the Query example on my own database and tables, works great!

Didn't know that Data Explorer was a .NET version, good to get that clearified!

I'm happy, case closed!