Banana Hosting - Be Different! Kattouf.com

|Home| |Portfolio| |FAQ| |Contact me|


Faq page

Database Connection Problems

1.
What is ODBC or what is a DSN? how do i create one? do i need one?
2.
I get this error: "Provider error '80004005' Unspecified error
3.
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
4.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
5.
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
   
1.

What is ODBC or what is a DSN? how do i create one? do i need one?

ODBC and DSN are the same way to establish a connection from the ASP script to the database. You MUST create one before any of my scripts will work. Login into your webhosting control panel and find out how to do it or ask your webhost to create one for you in the name that was explained in the instructions file.

2.

I get this error: "Provider error '80004005' Unspecified error

Most probably you are trying to run a script on your home server. Restart the server after creating the DSN to correct this, or try restarting IIS.

Another thing to try is to to check the permissions on the database folder. Give the IUsr or anonymous account higher permissions.

3.

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

You don't have 'Write' or 'Modify' permission on the database folder. Email your Webhost to change this.

4.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

This error occurs becuase the data you are posting is not compatible with the format the database expects it to be in. This happens when the you are hosting in Europe where the server regional settings would be different than the databse settings i created. For example, all my script use US style pricing. eg: 24.99 and NOT 24,99.
But in Europe the page might show 24,99. Email me for a fix to this.

5.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

You have not created a DSN connection to the database. Please do so before using the script. If you have then the path you entered was wrong. Consult your webhost for this issue.

 


© Kattout Internet Services Ltd. - Made in the UK 2006
Email: Johnny@kattouf.com - Tel: +44 (0)7753351548