Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
V6s5, ODBC, OLD-DB: ODBC will OLE-DB won't
Message
De
11/08/2003 09:42:48
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00818534
Message ID:
00818869
Vues:
18
>>BTW I never tried this. Maybe works. Try to add 'ENGINEBEHAVIOR=70' to your connection string.
>>Cetin
>
>The Extended Properties was auto appended when I put in ;ENGINE BEHAVIOR=70 text at end of original string
>
>Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="ENGINE BEHAVIOR=70"
>
>Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="ENGINEBEHAVIOR=70"
>
>Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="Engine Behaviour=70"
>
>
>Now it doesn't seem to append Extended Properties
>
>Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;ENGINEBEHAVIOUR=70
>
>Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;ENGINE BEHAVIOUR=70
>
>
>None of the above worked.

It's 'ENGINEBEHAVIOR=70'. I tried but didn't work. OK try this one sounds to be working :
oConn = NewObject('ADODB.Connection')
with oConn
 .ConnectionString = 'Provider=VFPOLEDB.1;'+;
 'Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;'
 .Open
 .Execute('SET ENGINEBEHAVIOR=70')
endwith
Then call your report manager routine as before.
I haven't tried this within in an exe but in development mode when I do this once and then close the connection (and even close all, clear all etc.), any connections after that behave as 'ENGINEBHAVIOR=70'.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform