Question: What is the purpose of using the fetch and declare cursor in Informix.4GL?How do you use the scroll cursor, and what are its advantages? Answer: Cursors allow you to
Question: I have been receiving the following (albeit general) error sporadically: “Microsoft OLE DB Provider for ODBC Driverserror ‘80004005’ [Informix][Informix ODBC Driver]General error.” This error has occurred when the code
Question: How can I release all existing database locks for all the sessions a specific user has started? Answer: The easiest way probably is to log that user out. Otherwise,
Question: I have about 50 users on an “old” Exchange Server (version 5.0 SP2), and I need to move them to a new server. The problem is that the new
The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a
Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT
Question: Is there a command-line way to back up my Exchange databases without stopping the services, like the GUI can? Or, for that matter, is there any automated method of
Question: Outbound messages are being delayed randomly. You can send them to the same host—sometimes they don’t queue up long enough to even see. Other times they are there for
Question: I have a parameterized SQL statement like the following: “insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES(?,?,?)” It’s parameters are ‘bbb’,’name’ and ‘2000/01/01 22:23:25′, using an ODBC connection. I can’t