Error Installing a SQL database - ADODB.Recordset (0x800A0E7D)
Sample Error
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
admin/dbstructure.asp, line 476
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
admin/dbstructure.asp, line 476
Solution or Workaround
WHAT THIS MEANS:
The error message could mean any of the following:
1. The "blank" SQL database was not created, which you have to do before running this script.
2. The security on the database is incorrect, and the script could not access the database to create the tables, fields.
3. The login username/password could be incorrect in the setup.asp file.
4. There is a problem with the connection string that you are using, see your "setup.asp" file, is incorrect.
You did not specify that it is an SQL database (you must uncomment the dbsql="Y" line)
5. If using a DSN, the dsn was not setup correctly, or the login account used is incorrect.
The error message could mean any of the following:
1. The "blank" SQL database was not created, which you have to do before running this script.
2. The security on the database is incorrect, and the script could not access the database to create the tables, fields.
3. The login username/password could be incorrect in the setup.asp file.
4. There is a problem with the connection string that you are using, see your "setup.asp" file, is incorrect.
You did not specify that it is an SQL database (you must uncomment the dbsql="Y" line)
5. If using a DSN, the dsn was not setup correctly, or the login account used is incorrect.
Related Topics
Search for help...