Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DSN ? & Path

DSN ? & Path

Thread began 2/12/2010 11:19 am by martin1028340912 | Last modified 2/12/2010 5:48 pm by Eric Mittman | 672 views | 1 replies |

2/12/2010 11:19 am | #1 martin1028340912

DSN ? & Path

I have an Access database that I need to pull the results from. I have setup a DSN connection with my host. How do I work locally with DataAssist?

Also, if my site is in the wwwroot with the host and my database is in the data folder shouldn't the path be data/mydatabase.mdb?

All other directions for using DataAssist makes sense to me but getting a connection is my problem. Any help here is appreciated.

2/12/2010 5:48 pm | #2 Eric Mittman

To work locally and test you might want to have a local testing server. If you have it setup like this you can go to control panel > administrative tools > odbc and setup a new system DSN. When it is setup there you can then go into DW and in the db tab add a new DSN connection, then select the DSN from the list.

If your host has the DSN setup you should be able to specify your hosted site as the testing server and access the DSN in a similar fashion.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.