Currently Viewing Posts Tagged database

Classic ASP program with Access database on Windows server 2008

Got error 800a0cb3 from the Web log file at Windows Server 2008. It is IIS7. The Web application is made by ASP. Actually classic ASP, not ASP.Net.

And also with Access database.  The page is try to add new record into the Access database file. But the browser return 500 internal error. The detail error code in log file is 800a0cb3 with the description: Recordset does not support updating. This may be a limitation of the provider or of the selected locktype.

I did a lot of research and found it is a right issue.

Continue reading “Classic ASP program with Access database on Windows server 2008”

How to fix the error of collating sequence not supported with the specified file format

When I use a ASP script to retrieve the data from a Access MDB file, I got an error: collating sequence not supported with the specified file format.
Actually, it happened when I move the site to a new server.
The solution was to go to the File tab in 2010, click the options link and set the sort order for new databases to ‘General – legacy’.

mdb-sorting-option

Continue reading “How to fix the error of collating sequence not supported with the specified file format”

Solved MySQL 5 – Incorrect integer value: ” for column ‘id’ at row 1

I move one site to a new server with Windows 2003.
It is a MySQL database. I use PHP script to connect the database file and query it.
I run the same script more than 5 years on the old server. After I move it to new one, it gives me the error as subject.
I did a lot of Googling. Found the answer at this blog(the link is not working any more), but now it is not available. So, I quoted the most important part from the Google Cached page.

This is an sql-mode issue, the mode defines what SQL syntax should be supported and what kind of data validation should be performed. In my problem MySQL is trying to assign an empty string to an auto-increment INT field and, as we should all know, strings into INTs don’t go. Cue errors and the script dies.
Longer term I am going to have to re-work my code to fix this issue, but in the short term, I am going to reduce the sensitivity of the control. To lower the level of data validation we can set the sql-mode to a lower level or comment it out altogether.

Solution is below:
Edit the my.cnf (my.ini in windows) file and find and comment out the line:
#sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Continue reading “Solved MySQL 5 – Incorrect integer value: ” for column ‘id’ at row 1″

7z command to compress file with date as file name

It is one step of my backup script under Windows 2000. Of course it works under Windows XP.
First, I use 7z as my default compress tool. Not because of it is a free, Open Source software, but it supports more format and compress methods.
The command program is 7z.exe under the installation of 7z package.
You can download it from here.

Continue reading “7z command to compress file with date as file name”

Server Upgrade and Database moveing

Last weekend, the server which I put my Blog on, is upgraded based on the Dreamhost schedule.
The new server is 64bit, and Linux is 64bit too.
SO I have to rebuild my customized PHP on it, and doing a lot of extension upgrade too.
Later I found I can not add new database and use the existing mysql host.
There is no option of “Use Hostname”.
I have to ask for upgrading databse too.
Today,they moved my MySQL database from alvin:ruano to my main MySQL server: lingling:myler.
Everything looks fine. If you find any strange issue, just comment here. Thank you.

Types of Table Relationships

To create a good database, I have to know the relationship between tables.
It is clear, the database I talking about is relationship database.
There are three types of table relationships.

  • One-to-one relationships
  • One-to-many relationships
  • Many-to-many relationships

One-to-one relationships
In a one-to-one relationship, a key will appear only once in a related table. It is the most simply relation.
One-to-many relationships
In a one-to-many relationship, keys from one table will appear multiple times in a related table.
The exapmle is a connection between department and employees. One department has many employees. One employee can only be in one department.
It is a very common type of relationship.

Continue reading “Types of Table Relationships”

Main Features of MySQL

I choose MySQL as my program’s database.
The main features of MySQL are:

  • Speed
  • Portability
  • Ability to interface with any programming languare
  • Price

MySQL is a multithreaded server, meaning that each time a connection is made, a new server process is started.
If you have to switch operating systems or languages mid-stream, use the mysqldump program to get your data out, and mysqlimport to get your data back into the system.
The ability for MySQL to interface with virtually every programming language – PHP, Perl, C/C++, Java, Python, and Tcl.
The selling point of MySQL is that it’s free, in most cases.

  • Archives