>>>>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 :(
>
>hmmm,
>and how about all options but with PRETEXT?

last state

Local lcLocalConnectionstring As String Pretext 15 &&8
TEXT TO lcLocalConnectionstring NOSHOW
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5
Data Source=d:\soykan.sdf
ENDTEXT

Local osqlce As adodb.Connection
osqlce=Createobject('ADODB.Connection')
osqlce.ConnectionString=lcLocalConnectionstring
lnConn=osqlce.Open()

error : not found may be not properly installed ughh :(