TMSCompactConnection could not create database v 3.5

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
akm
Posts: 13
Joined: Mon 16 Apr 2007 01:01
Contact:

TMSCompactConnection could not create database v 3.5

Post by akm » Sun 26 Apr 2009 23:47

Step to reproduce

1. Open Demo Project
C:\Program Files\Devart\Sdac for RAD Studio 2009\Demos\TechnologySpecific\MSSQLCompact\MSSQLCompact.bdsproj

2. Run this project
3. When select from combo version 3.0 - all is well
Database created and opened

BUT if select version 3.5 - appear error message
"Database not found. Check path to database".

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 28 Apr 2009 06:31

The problem is that a database, created by SQL Server Compact Edition version 3.0, is not compatible with the created by SQL Server version 3.5.
To create a database version 3.5 you should delete the "test.sdf" file and after that establish connection. New database will be created automatically.

Post Reply