Microsoft Access and IIS

[domuk]

hi all,

I am trying to create a database “data access page” in Microsoft access 2002 run on an Internet Information Server.

When I run it on my local machine it works fine, however when I run it over the web or on my internal network (running internet information server) I get two error messages:

1) data provider could not be initialized
2) not a valid filename

The database and the htm file are in the same root web directory on the server. I am not sure if I have set the server up to interact with databases so it may be an IIS problem rather than a database/data access problem.

Could someone please point me in the correct direction?

Thanks,

Dom.

[PeOfEo]

Please paste the error messages into a text files and upload them here so we can see what they say exactly. Also, .htm files? You are not going to be connecting to any data bases with a client side format like that unless you played with the extentions.

[domuk]

Hi PeOfEo

The errors that I get are two alert boxes pop up with the following messages:

1) data provider could not be initialized
2) not a valid filename

also when I press ok twice the input boxes that should contain data from the database are filled with “#Name?”

I was thinking it was a Open DataBase Connectivity problem or a file permissions problem on the server (I can not set them and not sure what they default to). I am assuming that there is an error log in the server software, however I have not found it yet.


htm/html I was always told that it did not matter which extension that you used as long as the code was accurate (I have exported the database input page from Microsoft Access as a data access page which defaults to htm). I have never understood why dream weaver defaults to htm (one less letter maybe?). I am sure there is a good reason (future standards maybe?).


Hope you can help,

Thanks,

Dom.

[PeOfEo]

when i said copy the error messages, I mean the whole thing. What is not a valid name lol? How are you doing this anyway? You are using an html page with a form method="post" action="thescript.aspx" and then naming the elements and on the asp.net page using
request.forms("elementname") correct? Why would you not do it all from a page with an .aspx extention and use the asp.net elements?

[domuk]

Hi,

I don’t know if I am making my self clear. The error messages are not from a log file they are “popup alert boxes” that follow me trying to access the htm file running on my local machines Internet Information Server.

I have not written the code for them, as I designed the database and relevant forms in Microsoft Access and exported them to “data access pages which come out of Access as htm files (for the web).

The files use XML to pass data from htm files to the access database that I have in the web directory of my (home) server.

I have got so cheesed of with it that I have got a mysql /php database working in the mean time, however I still want to get the Microsoft thinninggy to work. I am not using asp (quite frankly php / mysql and anything that’s not Microsoft looks good at present.)

So as far as the error messages (could you please explain how to get them out of IIS before i go totally bonkers..)

Thanks,

Dom.:eek:

[PeOfEo]

Well in that case I have no idea... this is the .net forum :p. I know asp.net, and that is what I assumed your question was about. Why would you use just xml instead of a server side technology... xml is going to limit you.

[domuk]

thanks for trying,

Dom.