Databases
Access: Provider error ‘80004005′
by admin on Oct.16, 2009, under Databases
Provider error ‘80004005′
Unspecified error
Open the .mdb in access. Go to Tools->Options->Advanced. Deselect the “Open databases using record-level locking” option. Press “OK” Close Access.
and restart your server…
Accessdb: unicode connection to access
by admin on May.09, 2009, under Databases
Provider cannot be found. It may not be properly installed.
possible issue may be your query is using reserved words for M$ Access
check out
Reserved Words for Access 2000
Reserved Words for Access 2002 and later
This may access ASPNET, ColdFusion , and other programming languages.
Access: Not enough space on temporary disk
by admin on Mar.09, 2009, under Databases
Add the following syntax to your query/application code .
DBEngine.SetOption dbMaxLocksPerFile, 65000
technet information on Maxlockfiles
Error :
Microsoft OLE DB Provider for ODBC Drivers error ‘8007000e’ [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.
Oracle : ORA-28000: the account is locked
by admin on Dec.12, 2008, under Databases
To resolve ORA-28000 in cases like this, you can request that the administrator unlocks the account using something like the below, the user name is ‘mas’ and password is ‘hmm123′ as an example:
SQL> alter user mas identified by hmm123 account unlock;
Mysql : Reset MySQL root password
by admin on Sep.21, 2008, under Databases
If you’ve forgotten the root password for a MySQL server, but you know the system root, you can reset the MySQL root password pretty easily. Just remember to work quickly since the server is wide open until you finish working.
First, add skip-grant-tables to the [mysqld] section of /etc/my.cnf and restart the MySQL server.
Next, run mysql from the command line and use the following SQL statement:
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
FLUSH PRIVILEGES;
Remove the skip-grant-tables from /etc/my.cnf and restart the server
also check out
