Page 1 of 1
Using with SQL Server 2005 Compact
Posted: Tue 10 Jul 2007 19:40
by mbinette
Can the dbExpress drivers be used with SQL Server 2005 Compact? I've tried with a demo version of v4 but was unable to make them work.
Posted: Wed 11 Jul 2007 07:03
by Antaeus
Yes, it can. Please describe the situation in more details. What is the problem? When does the problem appear? Is there any error raised? What is the text of the message?
Posted: Wed 11 Jul 2007 12:43
by mbinette
I am using Delphi 2007.
1) I drop a TSQLConnection component on a form.
2) I right click and select "Edit Connection Properties".
3) On the left under "Connection Name", I select SQLServerConnection.
4) On the right, I fill in the path to the database next to "Database".
5) "Host Name" is blank (should it be something else?)
6) I click OK to close that screen and go back to the Object Inspector.
7) DriverName=SQLServer, LibraryName=dbexpsda40.dll, VendorLib=sqloledb.dll
When I try to set Connected to True it pauses for about 10 seconds and then I get "SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]"
Posted: Wed 11 Jul 2007 14:13
by Antaeus
You should use the SQLServerCompactConnection connection name to work with SQL Server 2005 Compact Edition.
Posted: Wed 11 Jul 2007 15:56
by mbinette
That isn't an option when I go to "Edit Connection Properties". I downloaded v4.0.0.1.
Posted: Fri 13 Jul 2007 09:01
by Antaeus
You should download the last version of DbxSda from
our site and install it.