Hi,
I have been using DbExpress 3 for some time with great success but have recently upgrade to to DBExpress 4. However when trying the demo application for SQL Compact it gives me the error "Required provider is not installed".
The following is my setup
*Delphi 2006
*I have copied dbexpsda30.dll into the same folder as the demo app and renamed it to dbexpsda.dll (to suit the settings in the demo app)
* I have MS SQL Compact 3.5 runtime installed on my machine
* I have the following settings for the SQL Connection (exactly from the demo app)
object SQLConnection: TSQLConnection
ConnectionName = 'SQLServerCompactConnection'
DriverName = 'SQLServer Compact'
GetDriverFunc = 'getSQLDriverSQLServerCompact'
LibraryName = 'dbexpsda.dll'
Params.Strings = (
'BlobSize=-1'
'HostName='
'DataBase=.\test.sdf'
'DriverName=SQLServer Compact'
'User_Name='
'Password='
'LongStrings=True'
'EnableBCD=True'
'FetchAll=True')
VendorLib = 'sqlceoledb30.dll'
Left = 344
Top = 40
end
* I have noticed that sqlceoledb30.dll is not present on my machine so i have also tried this with sqlceoledb35.dll. I imagine the difference in file name is due to version of sql compact on my machine.
* I have tested that connections to SQL Express 2005 is working using this version and that is OK.
* I have tried connecting to multiple different SQL compact databases (all directly in the C:\ folder". All these different DBs are created with slightly different settings eg encryption, passwords etc, but the same result for all.
The "Required provider is not installed" error occurs when connecting to the sql compact database.
Any help is greatly appreciated,
Cameron