IIS or .Net server cant open database

help please ODBC hell!

[brettski]

Hi there im a newbie recently getting to grips with asp.net
I had MSaccess XP running fine last time my machine was running good,
however after a reinstall all windows, updating e.t.c, asp.net pages work fine, (running XP PRO, IIS v5.1 .NET framework and SDK v1.1)

BUT NO DATABASE INFO gets displayed. and no error message.

Ive set up access drivers in the ODBC admin, ive shared the directory where my .mdb file is, I really dont know what else to do.

I dont know wether its ADO.NET, because it was running fine,
I dont know if i need to change some security settings with the .net server or IIS.
or if the database is trying to talk on a port thats being used by something else.

If anyone could please help that would be great because Im going insane!

thanks brett

[bakedjake]

Post your SQL query, please.

[brettski]

Ive found that its not the database, asp code alltogether cannot be executed ie

<p>This page was created at <b>
<% Response.Write("Hello World!")%>
</b> on the computer running ASP.</p>

this displays the HTML, but no asp ,
IIS says its running fine, everything seems to be installed, ive reinstalled IIS again just to make sure.

the .net framework is installed correctly too.

any ideas would be soo helpfull,

poeple seem to think its the code, i dont think it is, coz even code written by pro's that I had working before perfectly is now not working.

What I suspect is that when I installed an update from MS, it some how upset something. becuase it was all running fine before

[bakedjake]

Does the website have script execute permissions?