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..
Newbie question...
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?
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?
In the Query demo of DbxSda the standard Northwind database is used. To change this database set an appropriate parameter for TSQLConnection, like this:
Also to solve the problem delete the declaration of the DBExpress unit from the uses clause of the Main.pas file.
Code: Select all
SQLConnection.Params.Values['DataBase'] := 'DataBaseName';