>Hi All,
>i've a problem about connection to microsoft sql server compact edition via oledb provider.i've allready registered sqlceoledb35.dll
>but i am getting error :( "ole dispatch exception code 0 from SQL Server Compact OLEDB Provider : ?.. "
>
>at lnConn=osqlce.Open() line
>
>where is my mistake ?
>
>TIA
>
>here is my trying codes
>
>

>Local lcLocalConnectionstring As String Pretext 8
>TEXT TO lcLocalConnectionstring NOSHOW
>Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;
>Data Source=d:\soykan.sdf;
>Mode=ReadWrite|Share Deny None;
>SSCE:Max Buffer Size=640;
>SSCE:Database Password='';
>SSCE:Encrypt Database=False;
>SSCE:Default Lock Escalation=100;
>SSCE:Temp File Directory="";
>SSCE:Default Lock Timeout=5000;
>SSCE:AutoShrink Threshold=60;
>SSCE:Flush Interval=10;
>SSCE:Test Callback Pointer=0;
>SSCE:Max Database Size=512;
>SSCE:Temp File Max Size=128
>ENDTEXT
>
>Local osqlce As adodb.Connection
>osqlce=Createobject('ADODB.Connection')
>osqlce.ConnectionString=lcLocalConnectionstring
>lnConn=osqlce.Open()
>
>
>
>

http://connectionstrings.com/sql-server-2005-ce

Try first w/oextra options:

TEXT TO lcLocalConnectionstring NOSHOW PRETEXT 15 && PRETEXT also :-)
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;
Data Source=d:\soykan.sdf;
ENDTEXT
...