David Yin's Blog

Currently Viewing Posts Tagged access

Classic ASP program with Access database on Windows server 2008

November 15, 2013
0 Comments

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

February 27, 2012
10 Comments

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”

Error 0x800C0133 of Outlook Express

December 17, 2008
2 Comments

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.

Continue reading “Error 0x800C0133 of Outlook Express”

AT&T Yahoo! DSL Internet package

November 7, 2006
0 Comments

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

.

Continue reading “AT&T Yahoo! DSL Internet package”

Error regarding collating sequence for Access

September 3, 2006
0 Comments

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”

  • Archives