One, the user-defined type is undefined
The user-defined type is not defined at the time of login, and then the error is displayed in the definition of CNN to be ADODB. when Connection
Workaround:
the question is, in fact, a direct view. ADO question, and then I'll put ADO2. X ( Various versions have been tried all over ), but still not solved. Finally , ADO2.8 and microsoftactive data Object (multi-dimensional) 2.8 are referenced, but generally others only need to refer to the ado2.x on it, my understanding is that the ADO version is different, so caused by my reference is the need for one more Multi-dimensional(Multidimensional).
Second, real-time error 381 subscript The problem of more limited.
The error line is as follows:
Textmatrix = "Gender"
Explain:
(Textmatrix array/string Sets/returns the text content of a selected row, column of cells)
. Textmatrix (1, 2) = "Gender" is the first row of MSHFlexGrid, the second column is gender
Workaround:
vb the more limited the subscript is not the data you requested
Change MSHFlexGrid number of columns, available code: Mshflexgrid.cols = 8
Three: Real-time error 91, object variable or with block variable not set
Object variable or with block variable not defined is actually the database object you set up is not instantiated well, that is, there is no connection to your database or code has some details of the problem!
1 , the database connection is not successful factors, you can compare:
1. Service Manager does not start the service
2. Data source (ODBC) inside " file DSN" There is a database added
3. " Enterprise Manager - Security - Login " The default database accessed is not set to the database you want to access, and can be changed in the properties
4. in the code , "Select*from" should be followed by the name of the table, not the database name
5.connectstring inside the user name or password error (in the Enterprise Manager corresponding server security landing inside can be modified), here I am a little puzzled, before running on my laptop if this place is wrong, and on the landlord's desktop regardless of user name and password error or deleted, Can be a normal connection success, but the first few words wrong is not just, in ExecuteSQL () This function will trigger the process of connectstring (), so connectstring () is equivalent to a database connection must be set up an event, the string must be written correctly, or directly affect the connection to the database
2, carefully check their own code, there is no nonstandard place.
Error analysis of student information System 1