Using with SQL Server 2005 Compact

mbinette · Post by **mbinette** » Tue 10 Jul 2007 19:40

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.

Antaeus · Post by **Antaeus** » Wed 11 Jul 2007 07:03

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?

mbinette · Post by **mbinette** » Wed 11 Jul 2007 12:43

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]"

Antaeus · Post by **Antaeus** » Wed 11 Jul 2007 14:13

You should use the SQLServerCompactConnection connection name to work with SQL Server 2005 Compact Edition.

mbinette · Post by **mbinette** » Wed 11 Jul 2007 15:56

That isn't an option when I go to "Edit Connection Properties". I downloaded v4.0.0.1.

Antaeus · Post by **Antaeus** » Fri 13 Jul 2007 09:01

You should download the last version of DbxSda from our site and install it.