1. Where can I get information on all of the connection string options for
this provider?
2. when I attempt to do a simple select * from <table>, I get an error
"Unsupported Conversion" from OLEDB. I don't know why I am getting this
error, I was wondering if it could have something to do with my connection
string.
Here is the string that I am using:
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data
Source=e:\ProjectData\MailMergeDatabase.sdf
(note, I'm not sure if the "provider" parameter is correct -- I am using
3.5/sp1. Do I need to specify SP1 somehow?
"ErikEJ" <Eri...@discussions.microsoft.com> wrote in message
news:C339F7E5-74BB-488B...@microsoft.com...
> If you are using managed code, use System.Data.SqlServerCe ADO.NET
> provider.
>
> The OLEDB provider from a .NET app has some issues with ntext and image
> columns, that is why your select * fails.
>
> Connection string parameters here:
> http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring.aspx
>
> For the OLEDB provider, use the ssce: prefixed values.
> --
> Erik Ejlskov Jensen - MCTS: Mobile App Dev
I think so! I don't know.