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