Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5, ODBC, OLD-DB: ODBC will OLE-DB won't
Message
From
11/08/2003 09:42:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00818534
Message ID:
00818869
Views:
17
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform