Multi-Database
A few days ago, the company had been running a normal procedure for ASP, installed a client suddenly can not run the side. Customers to use the Informix database server is Windows2000 Professional Simplified Chinese, in the past, we have been testing the use of the database is MS-SQLServer.
In the search result page orientation (that is, attribute settings ADODB.Recordset.AbsolutePage) error, suggesting that the effect: do not support the cursor type. This is a long time ago NEE others do, and I have not touched ADO more than a year, it can only vaguely feel is the issue of ADO.Recordset cursor to find designated Recordset object Open Office code, found no significant - Recordset definition of the cursor location (CursorLocation), ah, if not remember it correctly, the default cursor position ADO.Recordset server model. Recordset cursor to the position as a client, as well as for static cursor type. Refresh page, the error, suggesting that do not support character sets. Find fault location for the Open Recordset object. Depressed (half-hour)……
Found in the ASP script using SQL query directly, and the use of AS keyword which will be known as the field of other Chinese. Ah? Possible stop is for this reason, therefore Quxiaodiao other Chinese said. To refresh and success!
I am completely unfamiliar with Informix database, so I do not know why there would be such a situation, but it reminds me enough to achieve the multi-database-application platform is not imagine so smooth all the way, at least a lot of details need to be considered and dealt with , and this is the need considerable experience and skills. Next in the company of a new project, the request must support multiple databases (Oracle, SQLServer, DB2), and the middle layer in the Unix, Linux and Windows platforms running, it seems that I need to be more cautious approach to the PWC I assessed the technical design of the programme.
Tags: database
0 Comments to “Multi-Database”
No Comments. Send your comment.
Leave a Reply
You must be logged in to post a comment.