Databases

Access: Provider error ’80004005′

Posted by on October 16, 2009 at 8:22 pm

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

Posted by on May 9, 2009 at 6:30 pm

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

Posted by on March 9, 2009 at 2:02 pm

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.

Oracle : ORA-28000: the account is locked

Posted by on December 12, 2008 at 8:12 pm

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

Posted by on September 21, 2008 at 10:37 am

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 [...]