PDA

View Full Version : MS Access, DSN, ODBC Tool


Leom
04-07-2004, 03:10 AM
HI,
I'm having a problem hitting my database on the dasp.net server. I have a form (form1.asp) that collects a group of data. There is a second asp page (managedata.asp) that receives the data from form 1. When I execute form1.asp the managedata.asp page displays the following message:

There is a problem with the page you are trying to reach and it cannot be displayed.
....(other text)
HTTP 500 - Internal server error
I used the ODBC tool to set up my database but I don't know if I used it correctly, since there is almost no documentation on it.
The form on the ODBC tool setup page seems to indicate that the name should be "mydomainnamehere00_mydatabasename", and the path I should provide to be "\_database\mydatabasename.mdb"
What do I name the DSN in my asp page in order for the page code to execute properly? mydomainnamehere00_mydatabasename or simply mydatabasename?
Thanks in advance,

bruce
04-08-2004, 05:18 AM
500 Internal server error is a generic error.

Make sure you configure your browser to display the true error, see http://kb.discountasp.net/article.aspx?id=10052

[b]quote:Originally posted by Leom


HI,
I'm having a problem hitting my database on the dasp.net server. I have a form (form1.asp) that collects a group of data. There is a second asp page (managedata.asp) that receives the data from form 1. When I execute form1.asp the managedata.asp page displays the following message:

There is a problem with the page you are trying to reach and it cannot be displayed.
....(other text)
HTTP 500 - Internal server error
I used the ODBC tool to set up my database but I don't know if I used it correctly, since there is almost no documentation on it.
The form on the ODBC tool setup page seems to indicate that the name should be "mydomainnamehere00_mydatabasename", and the path I should provide to be "\_database\mydatabasename.mdb"
What do I name the DSN in my asp page in order for the page code to execute properly? mydomainnamehere00_mydatabasename or simply mydatabasename?
Thanks in advance,
</blockquote id="quote"></font id="quote">