Good Implementation for SQL Server and SQL Server CE

redline · Post by **redline** » Tue 26 Oct 2010 09:44

Dear Devart Team,
in my Application I support currently 2 Databases. The SQL Server (Express or normal) and the SQL Server Compact Edition. Perhaps I add other Provider later. If the user choose Compact Edition, I add the SpecificOption: 'SQL Server.OLEDBProvider=prCompact' to the TUniconnection. This works very well.
Now I have two Problems:
1. All Parameters have to be "ftVariant"
In Params not working for SQL 2005 Compact you said that this is not a recommended solution. Do you have other Solutions for this Problem?

2. The SQL-Server Compact Edition is very slow
Of course it can´t be very fast. But it is possible to set Properties that I have forget. Until now I had nothing configure without the SpecificOption.

AndreyZ · Post by **AndreyZ** » Thu 28 Oct 2010 07:56

Hello,

1. In this topic we said that we recommend to use exact data types like ftInteger or ftString instead of ftVariant.
2. Please read the Using UniDAC with SQL Server topic of UniDAC Reference Manual. There you can find all available options for SQL Server Compact Edition. All names of these options begin with "Compact".