The very first step is to prepare the Ubuntu server.
I installed the Ubuntu 18.04 on a VM with 1CPU, 1024MB memory and 16GB storage room.
After the installation. Start the Ubuntu server and ssh to it.
Continue reading “Make the PHP support Microsoft Access MDB file on Ubuntu 18.04”
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”
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’.
One desktop with Windows 2000 pro works fine, until one day. It can not receive email any more. Any time I click send/receive button on the Outlook Express, it gives me an error box, said 0x800C0133.
What’s wrong. I go to check the email folder. The physical file store all emails.
The inbox.dbx is over 2 GB.
I can see the oldest email is March 2005. The user has never organize the email and he still want to access these emails.
He is lucky, the inbox is still not corrupt. It just can not receive email any more.
I help my parents in law to sign up for DSL Internet service from ATT
They use Dial-Up previously, cost them about 10 bucks. Now the AT&T Yahoo! High Speed Internet Basic Package is $14.99 per month with following features:
Speed: 384 Kbps to 768 Kbps downstream / 128 Kbps upstream
IP Assignment Method: 1 Dynamic
ATT has four different packages for residence. The other three packages are shown below:
Express package:
Speed: 384 Kbps to 1.5 Mbps downstream / 128 Kbps to 384 Kbps upstream
IP Assignment Method: 1 Dynamic
Price: $19.99 per month
.
I have a site driven by Access database. Today I compacted this database and browse the web page which will access this database.
I got the error message, “Selected collating sequence not supported by the operating system.”
It looks so strange, I do nothing except compacting.
The real reason is because this database file is created in another computer. The “New Database Sort Order” are different in these two computers.
To correct it, do followiong steps:
1. Open this database .
2. On the Tools menu, click Options, and then click the General tab.
3. Make sure that the New Database Sort Order is set to General and then click OK.
4. Then compact and reparie this database.
Upload it to the webserver. The error is disappeared.
Continue reading “Error regarding collating sequence for Access”
