Dreamweaver 8 access database connection

[braedswork]

I have installed dreamweaver 8 on a local server running IIS 2
I am trying to connect to an access database also located on the local sever
all connections appear to work and you can see the live data
that is in the database, but when I try to preview the page
or view from a diffrent machine. It displays a page not found error
I think this may be related to the testing server, I am not sure
I am running windows server 2003 and creating a .asp files
file and have configured the testing server as local

any ideas or is there a better way to sync my database to dreamweaver


thanks
bradswork@yahoo.com

[Newsgroup_User]

It's obviously your connection to your db. Have you created a DSN (via
Control Panel) or a connection string?

If you've created a DSN, which I suspect, try editing your connection from
the Database panel, and chosoe Use DNS on Testing Server. The reason it may
not work on another machine is your connection uses a DSN, but of course the
DSN hasn't been created on the other machine. This would be the same for any
other machines.

You may prefer to use a connection string instead. Should look something
like this (modify path and file name):
"Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Folder\mydatabase.mdb"

Let me know if you need more on this,

Piers

[DONNA6985]

I am having a very similar problem. Our network staff recently upgraded our web server to Windows Server 2003. Prior to that our database was working fine. We now get the "Page Cannot Be Displayed Error". We are using a DSN and have it set to Use DSN on Testing Server. Any suggestions on what could be causing the problem? Thanks.