OpenKB::Server Technical Papers

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…

Comments Off more...

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.

Comments Off more...

Access: Not enough space on temporary disk

by admin on Mar.09, 2009, under Databases

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.

Comments Off more...

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;

Comments Off more...

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 

http://wiki.mysqltuner.com/MySQLTuner

Comments Off more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!