In article <[log in to unmask]>, "Rexor" <[log in to unmask]> writes:

>
>Thanks a lot to Birket Foster for your first answer, you explains are very
>clear and very helpfull.
>
>I have still a little problem. Everything works till the SQL string.
>I have the following error message (translated from the french):
>
>    Execution error "3146"
>    ODBC -- Call aborted
>
>My database DBFB01 is attached to the DBENVIRONMENT DBDBE on the HP3000
>The DSN "BASES HP3000 REXOR" is attached to the DBENVIRONMENT DBDBE.
>
>The Open Database Works, with my DSN (don't need password because they are
>configured in the ODBC)
>
>I would like to acced to my database DBFB01, set FREMDB-D, using the DSN
>"BASE HP3000 REXOR"
>
>

When using ALLBASE set maxstatements to 1

This will solve this problem ...

Birket Foster
M. B. Foster Associates .. the 1-800-ANSWERS people!
Supplying DataExpress w/cross-platform ODBCLink Option ( 3000,9000&NT)
EC/EDI(3000,9000,NT) Phone (613) 448-2333 or (613) 448-2588 (FAX)
(See our website at http://WWW.MBFoster.com )