Articles

  error:The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

Error Type:   Microsoft OLE DB Provider for ODBC Drivers error '80004005'...

 Can I connect to your MS SQL 2000 server with MS SQL 7.0 Enterprise Manager?

The information in this article applies to: MS SQL 2000  MS SQL 7.0 Enterprise...

 Connect to a msaccess database using a dsn-less connection via asp

Following demonstrates on how to make and use the Access database connection:   01....

 Connect to a mysql database using a dsn connection via asp

If you have defined the DSN on the Web Server, then the connection string is simply: <%...

 Connect to a mysql database using a dsn-less connection via asp

"<% dim adoConn dim adoRS set adoConn = Server.CreateObject("ADODB.connection") set adoRS =...

 Connecting to MSSQL with a DSN

You can use the following string to connect to MSSQL with a DSN <%Set Conn =...

 Connecting to MSSQL with out a DSN

You can use the following string to connect to MSSQL with out a DSN. It uses an OLEDB connection...

 Connecting to SQL database using SQL Enterprise Manager

Please follow the steps below:   STEP 1: Open the SQL Server Client Network...

 Connecting to a ms-access database using a DSN

Using an ODBC DSN (Data Source Name) is a two step process.   1) You must first create the...

 ERROR 2008: MySQL client ran out of memory

Problem:   If you issue a query and get something like the following error: mysql: Out of...

 Error:Microsoft OLE DB Provider for ODBC Drivers Error '80004005' -- DSN Not Found...

Solution Problem:   I'm getting the following error message: Microsoft OLE DB Provider...

 How can I protect my access database from being downloaded over the Internet?

The best way to protect your database is to FTP to your account and place it in the db folder in...

 How do I obtain the MS SQL database disk usage?

To find out the database disk usage, you can execute this SQL command in Query Analyser.  ...

 How do I set write permissions on my MS Access database?

There are 2 ways to set the correct write permissions on an Access database.   >>The...

 How to Export and then Import a MySQL database using PhpMyADMIN

The following are the steps to Export and then Import a MySQL database usnig phpMyAdmin Export...

 I'm getting a strange error message: Operation must use an updateable query(error '80004005')?

The database and the folder the database are stored in require write permissions for the...

 I'm getting a strange error message: Operation must use an updateable query(error '80004005')?

  Problem:   Microsoft OLE DB Provider for ODBC Drivers error...

 Microsoft OLE DB Provider for ODBC Drivers error '80004005' (Access Driver) Not a valid password...

This error is caused when your Access database is password protected and your connection string...

 Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time

This is a known issue and can be resolved using SQL Server 2000 Service Pack 1. It must be...

 Securing MS Access Database

We highly recommend storing your MS Access databases outside your website directory. This makes...

 Transferring SQL databases from client to SQL server

Use following steps:   STEP 1:   From the Start Menu  select...

 Uploading A Microsoft SQL Database

The first step in loading your MSSQL Database is to create the database on our system. This is...

 What is the ports do SQL Server clients (Enterprise Manager, Query Analyser, etc) use?

SQL Clients (Enterprise Manager, Query Analyser, etc) use TCP port 1433.  

 Where should I put my Access database?

There are two suggested locations to store your access database:   1. In the db folder,...

 Which port should I use, 80 or 3306 ?

You should ALWAYS use port 3306, port 80 is for web access ONLY.The only exeception is when your...

 error: Too few parameters

error type:   Microsoft OLE DB Provider for ODBC Drivers error '80040e10'...

 error: file already in use

Error Type:   Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC...

 error:Login Failed for User 'testSQL', Not Associated with a trusted SQL Server Connection

  This error occurs because by default SQL 2000 does not support SQL Server...

 error:Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Problem:   Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft] [ODBC...

 error:Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

Problem:   Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC...

 error:Why do I get the error 8000045 when running my MS Access scripts?

Normally, this is caused by file permissions not being set correctly on your MS Access database....

 get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

The information in this article applies to: MS SQL Enterprise Manager DETAILS...

 how we can setup a system DSN to access our MySQL database through ASP

#Setting up a system DSN :   >>click on the start menu -> Settings -> Control...

Powered by WHMCompleteSolution