Archive for the “Databases” Category

Access: Provider error ’80004005′

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…

October 16, 2009 Posted Under: Databases   Read More

Accessdb: unicode connection to access

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.

May 9, 2009 Posted Under: Databases   Read More

Access: Not enough space on temporary disk

MS KB

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.

March 9, 2009 Posted Under: Databases   Read More

Oracle : ORA-28000: the account is locked

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;

December 12, 2008 Posted Under: Databases   Read More

Mysql : Reset MySQL root password

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 

http://wiki.mysqltuner.com/MySQLTuner

September 21, 2008 Posted Under: Databases   Read More