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 )