I was able to set my access database to the IIS server on windowsXP pro. To do this I just saved my access file (created in the previous clips), to the location on my computer I wanted the DSN to point to. Then, I selected PROGRAM > CONTROLS. Then, click "Administrative Tools" and the TAB "Data Sources (ODBC).
Next, click tab "System DSN" and ADD button.
Next, scroll thru drivers to "Microsoft Access Driver".
Next, in the field 'Data Source Name', I enter "SkillsTest".
Next, click on the Database "Select.." button. And surf to the location on the computer I have the access file saved and click OK.
Now when the ASP page calls the DSN "SkillsTest" it will connect to this locally saved file thru the IIS server on MicrosoftXP Pro.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Web Database Seminar.
