Data | Database A few days ago, the company has been running a normal ASP query procedures, installed to a client side suddenly can not run. The database that the customer uses is Informix, the server is Windows2000 Professional Simplified Chinese, and the database that we used to use the test previously is ms-sqlserver.
When the query results page is positioned (that is, set ADODB.) Recordset.absolutepage property) Error: Unsupported cursor type. This is a long time ago other people do, and I have not touched ADO for more than a year, so can only vaguely feel that may be ADO. Problem with the recordset cursor, find the Open code for the specified Recordset object and find that it does not explicitly define the cursor position of the recordset (CursorLocation), well, if it's not mistaken, ADO. The default cursor location for the Recordset is server mode. Sets the cursor position of the Recordset to the client and the cursor type as static. Refresh page, error, hint unsupported character set. Locate the Open where the error location is the Recordset object. Depressed (half an hour) ...
It is found to use SQL query statements directly in ASP scripts, and use the AS keyword to name the field names as Chinese. Well? Perhaps for this reason, the cancellation of the Chinese nickname. Refresh again, success!
I'm completely unfamiliar with the Informix database, so I don't know why this is happening, but it's enough to remind me that the application across multiple database platforms is not as smooth as it should be, and that at least a lot of detail needs to be considered and handled, which requires considerable experience and skill. In the company's next new project, which requires support for multiple databases (Oracle, SQL Server, DB2), and the middle tier to run on Unix, Linux and Windows platforms, it seems that I need to be more cautious about estimating my technical design.
