Re: Unload to and ODBC

Unload doesn't work with ODBC. Someone to correct me?. I've used WinSQL and tryig to unload something just fail. In any case I think this approach is not very usefull since this way you can't guaranteed a consistent backup. But you could try dbaccess for Windows. Look at it in www.informix.com. J. -----Original Message----- From: "Bob" <soft@datacolfrance.com> To: informix-list@iiug.org Date: Tue, 8 Feb 2005 12:06:48 +0100 Subject: Unload to and ODBC Hello, I need to make backup of my prime database while its running, prohibiting the use of dbexport. When using dbaccess i can do an unload to 'myfile' select * from mytable without any problem. As i have a large amount of tables i thought to make a little software to backup all the tables i needed to save using ODBC ... here is the problem, the same request which work on dbaccess does not work using sqlview connected by odbc. it keep on returning "syntax error" My database is IDS 7.31 and my system is Win NT 2000 server. Any help would be great. Thanks in advance, Fred Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list