Asp

[sol4love]

Hi,
Am working with ASP. I have no problem of getting my database records. But when i try to insert new records, i couln't.I used the adOpenStatic, adOpenDynamic,adLockPessimistic,adLockOptimistic, etc but i couldn't insert new records to my database. So what can be the problem? anyone with help?

[nbcrockett]

Do you have write permissions on the database file itself?

[sol4love]

Thank you for your concern
I had full permission. But i have solved the problem by using 3,2 instead of using adOpenStatic, adLockOptimistic or so. And also i removed some extra codes which i thought were blocking me from updating my db.

[nbcrockett]

Sorry, didn't think of that. You can use the long names by adding the global.asa file to your root folder. Here's an example of mine.


Remote Data Services:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft Remote Data Services Server 2.5 Library"
UUID="{9381D8F6-0288-11D0-9501-00AA00B911A5}"
VERSION="1.5"
-->

ADO 2.0:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft ActiveX Data Objects 2.0 Library"
UUID="{00000200-0000-0010-8000-00AA006D2EA4}"
VERSION="2.0"
-->

ADO 2.5:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft ActiveX Data Objects 2.5 Library"
UUID="{00000205-0000-0010-8000-00AA006D2EA4}"
VERSION="2.5"
-->

ADO 2.6:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft ActiveX Data Objects 2.6 Library"
UUID="{00000206-0000-0010-8000-00AA006D2EA4}"
VERSION="2.6"
-->

CDO for Windows 2000:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft CDO for Windows 2000 Library"
UUID="{CD000000-8B95-11D1-82DB-00C04FB1625D}"
VERSION="1.0"
-->

Scripting Runtime:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft Scripting Runtime"
UUID="{420B2830-E718-11CF-893D-00A0C9054228}"
VERSION="1.0"
-->

MS XML v3.0:
<!-- METADATA
TYPE="TypeLib"
NAME="Microsoft XML, v3.0"
UUID="{F5078F18-C551-11D3-89B9-0000F81FE221}"
VERSION="3.0"
-->