How to Connect

[RussOSU]

I am looking to connect a Microsoft Access Database in which I created to a couple .asp pages. I have direct access to the webserver for our local intranet This is where I am running into my problems is that I do not know how to handle the making of the connection. I know that it is possible to connect the database and an .asp page because I was able to do it on a small test page I created in Access 2K. However I now need to be able to apply more features to the webpage that access won't do. I have saved the page as a .asp and then opened it in UltraDev, this works however it doesn't work with what I am wanting to do because I loose the form. How do I connect my webpage to the database?

 

[ToCondo]

First you need to create a System DSN on the webserver and point it to the location of the database. Create another DSN (local or system) on the PC on which you are doing the development; give it the same name and point it to a copy of the database on your PC (within your local site folder).

Then, in UD, go to Modify | Connections and add a new connection; select Data Source Name. In the Connection Name give it a name, then select the DSN that you created on your local PC. Test it out.

That should be it.