November 21, 2008 at 5:42 am
Beautiful day!
I would like to ask somebody to help me.
I have the following problem:
I have a Windows Mobile Device with SQL Server Compact Edition 3.5 and an sdf file in Program Files. I also have a desktop PC with SQL Server 2008. I would like to make an application not with .NET framework. I should connect to the sdf file with OLE DB. I set the connection string as follows:
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Mobile Device\Program Files\database.sdf;pwd=pwd
I tried it with OLE DB in CodeGear RAD Studio and in Visual Studio too. In both environment I got the following exception at Open function:
Multiple-step OLE DB operation generated errors...
What can I do? If I try to connect a local sdf file on desktop pc I get the same message.
Please somebody help me!
November 24, 2008 at 9:36 am
The installation of MSSQL CE is incomplete!
You should add the following registry key:
[HKEY_CLASSES_ROOT\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC}\OLE DB
Provider]
@="Microsoft SQL Server Compact OLE DB Provider"
That's all! Thanks for Microsoft.
November 24, 2008 at 11:52 pm
I created the key and restarted the pc but it didn't solve my problem.
February 10, 2009 at 11:49 pm
change connection string to SSCE[:]Database Password='myPassword' instead of pwd (no [] around : )
August 7, 2009 at 1:17 am
Hey,
do you get the exception while connecting or wile requesting a query?
I had the same problem with a query like "SELECT TOP 1 ...". SQL Server COmpact doesn't understand that. i had to use "SELECT TOP (1)...".
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy