>>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
>...
>

Hi Boris,
i've tried as your suggest w/o extra options buts still same :( but now provider not found may be not properly installed
but i've registered it.