devxlogo

July 17, 2000

Date Time Values in Parameterized Queries

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

ASP Error: ODBC Driver General Error

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

Releasing Database Locks

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,

Retrieving Messages After Restore

Question: This weekend I did a restore of my Information store. I had to do a repairmidway through. This morning, a few people have told me they can’t opensome mail

Create a Table with Autonumbering

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

Redirecting E-Mail

Question: How can I redirect mail sent to a particular mailbox to an external address? Answer: Outlook 2000 has the ability, in the Rules Wizard, to redirect mail. You’ll find

Backup Exchange in Windows 2000

Question: I have a Windows 2000 server where I have installed the Exchange Server 5.5 Service Pack 3. I want to do a backup, but the Exchange option is empty

Receiving Mail from the Internet

Question: How can I place my Exchange Server on a network with private addresses and have my MX record point to the server even though the server is behind a

Running Ace Reports from Within 4GL

Question: My ace report/shell script did not wait for user intervention. I have solved that with: script.sh < mytty > mytty But now the screen needs refreshing with a CTRL-R.