A few days ago, the company originally runs a normal ASP query program, and it is suddenly unable to run on a customer. The database used by the customer is Informix, the server is Windows2000 Professional Simplified Chinese, and the database we have been using the test is MS-SQLServer. When the Positioning Query Result Page (ie, when setting the adoDb.recordset.absolutePage property), the prompt is very good: the type of cursor is not supported. This is a long time to do Dongdong, and I haven't touched the ADO for more than a year, so I can only feel the problem with the ado.recordset cursor, find the Open code specified by the Recordset object, and find that it is not explicit Define the cursor location of the Recordset, Well, if you have not remember, the default cursor position of Ado.recordset is the server mode. Set the RECORDSET's cursor position to the client and the cursor type is static. Refresh the page, an error, and prompt the unsupported character set. Find the wrong position for the Open of the Recordset object. Depressed (half an hour) ... found that it uses the SQL query statement directly in the ASP script, and uses the AS keyword to refer to the field name as Chinese. Ok? It may be because this reason is abolished, so it is canceled. Refresh, success!
I am completely unfamiliar with the Informix database, so I don't know why there will be such a situation, but this is enough to remind me that it is not imagined that the application is not imagined, at least many details need to consider and process. And this is quite experienced and technically. In a new project next to the company, it is necessary to support multiple databases (Oracle, SQLServer, DB2), and the intermediate layer can run on UNIX, Linux, and Windows platforms, it seems that I need more cautious attitudes to pre- Estimate my technical design.