Knowledgebase

The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.

Search

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'...
Views: 661

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...
Views: 661

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....
Views: 653

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: <%...
Views: 649

Connect to a mysql database using a dsn-less connection via asp
"<% dim adoConn dim adoRS set adoConn = Server.CreateObject("ADODB.connection") set adoRS =...
Views: 659

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...
Views: 618

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

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...
Views: 621

Connecting to SQL database using SQL Enterprise Manager
Please follow the steps below: STEP 1: Open the SQL Server Client Network...
Views: 662

ERROR 2008: MySQL client ran out of memory
Problem: If you issue a query and get something like the following error: mysql: Out of...
Views: 651

error: file already in use
Error Type: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC...
Views: 657

error: Too few parameters
error type: Microsoft OLE DB Provider for ODBC Drivers error '80040e10'...
Views: 654

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...
Views: 627

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

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...
Views: 643

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

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....
Views: 640

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...
Views: 656

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...
Views: 637

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. ...
Views: 653

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...
Views: 639

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...
Views: 659

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...
Views: 630

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...
Views: 635

I'm getting a strange error message: Operation must use an updateable query(error '80004005')?
Problem: Microsoft OLE DB Provider for ODBC Drivers error...
Views: 604

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...
Views: 642

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...
Views: 626

Securing MS Access Database
We highly recommend storing your MS Access databases outside your website directory. This makes...
Views: 629

Transferring SQL databases from client to SQL server
Use following steps: STEP 1: From the Start Menu select...
Views: 643

Uploading A Microsoft SQL Database
The first step in loading your MSSQL Database is to create the database on our system. This is...
Views: 662

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.
Views: 656

Where should I put my Access database?
There are two suggested locations to store your access database: 1. In the db folder,...
Views: 617

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...
Views: 657