IIS configuration

Ron,
I'd be glad to help you.
First of all you need to tell what exactly is the problem. Simply saying "it doesn't work" won't get you anywhere. Give me more details on this.

First of all you need to tell what exactly is the problem. Simply saying "it doesn't work" won't get you anywhere. Give me more details on this.

Wel, that's the problem. If I knew what was wrong I might solve it.

First: XP Pro and IIS is difficult to configure because of all the security settings.

Enabling "full access" to folders and files might put the door open to all kinds of unwanted visitors.

True, I'm not familiar with these matters, but who is?
Second: I have read many postings about database access problems.

I think mainly because of the above.
I would like to understand the basics of database and odbc and its relation to ASPrunner. Following the manual with examples.mdb in step 2 of 12 ther should be an page ADBC DSN. I haven't seen it!?
Further, the examples.mdb database is connected to SQL Server: why is that? Why not to Microsoft Access *.mdb driver?
Errors: I do have a connection now to my examples website and when I edit and save a record I get this error:

Error type: Provider (0x80040E21).........../test/cars_edit.asp, line 292
Adding a user: when saving I get error:

Error type: Provider (0x80020005) type mismatch... /test/users_add.asp line 200
I could add a car to the list.

Q: shouldn't the Id of the user recorded automaticly? I can fake a different user. this is important if users are only allowed to edit their own records. Once users are logged on this ID is known.
That's it for now.

ron

Ron,
what kind of database and ASPRunner basics you looking for?
If everything goes right you do not have to touch anything in IIS settings. If something doesn't work - tell me what exactly.
When you connect to MS Access database simply choose first connection option (database file) and point to MS Access database.
If users are allowed to edit their own data only you cannot fake a username.
On the edit page make sure you not putting letters into a numeric or date field which will give you Type mismath error. You can open cars_edit.asp in any text editor and proceed to line 292 to see what field gives you this error.

On the edit page make sure you not putting letters into a numeric or date field which will give you Type mismath error. You can open cars_edit.asp in any text editor and proceed to line 292 to see what field gives you this error.

O.K. just one more error:

I try to copy a record in the cars table.

When saving I get this error:
The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the evectra home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Provider (0x80040E21)

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/test/Cars_add.asp, line 392
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:

POST 1878 bytes to /test/Cars_add.asp
POST Data:

error '80020009'

Exception occurred.
/iisHelp/common/500-100.asp, line 223
-----------------------

Explanation
/test/Cars_add.asp, line 392:

rs("Picture") = Null
/iisHelp/common/500-100.asp, line 223 :
Respons.Write Server.HT<MLEncode(Left(Request.Form, lngMaxFormBytes)) & " . . . "
You see, you have to junmp to all kind of files to get code and than you still are in the dark.

From a user point of view this is cumbersome and unwanted.
I'll give a try for a couple of more days, but I'm not hopeful that I will master this product.
Ron

Ron,
per my email I sent you ealier this problem happens because you set Edit as type of Picture field to Text field while it should be Database-based image.