Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Microsoft sql server compact edition oledb provider
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Microsoft sql server compact edition oledb provider
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Network:
Windows XP
Divers
Thread ID:
01382195
Message ID:
01382195
Vues:
179
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()
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform