Problem Displaying Table Information - Please Help

[gemora]

This problem has to do with .ASP and Access database using both DSN an DSNless
connections.

I have a bunch of websites hosted with a local host (same host for years), and
have run into a very odd but disturbing problem. I was trying create some pages
using an existing database and connection, but for some reason DW will not
display the table information. DW does in fact connect successfully to the DB
however, so I am really stumped. It gives me 2 popup error windows....One that
says.

"Unable to retrieve tables from this connection, click on the 'Define...'
button to test this connection."

Followed by this popup window...

"The relative path to the Connections folder is no longer valid.
This will be corrected automatically when you click OK in the server behavior
dialog box."

I am genuinely confused to what I have done to cause this problem. At first I
thought it was only going on with one of my defined sites, but it turns out
every one of my defined sites is having this same problem.

It also gives me these errors on recordsets in .ASP pages that are already in
existance and are currently working on the server (in recordset panel or server
behaviour panels I get little red exclamation points where there are problems).

I am hoping that I am just overlooking something completely obvious here. Any
help is appreciated!

Thanks in advance,

gemora

[gemora]

Forgot to mention that I am using DreamweaverMX v6.1

[gemora]

Bump! Should I be contacting Macromedia directly regarding this issue? I am
dead in the water with about 20 clients until I can get this resolved, putting
me in a VERY scarry position.

I figured Murray or one of the regular gurus here would be able to help me
(Murray you have helped me in the past before when I was getting started back
in the newsgroup only days).

Anyhow thanks again for any responses.

[gemora]

Bump!! Anyone?!

I am really stumped and frustrated.

[Lionstone]

Sounds like the folder structure changed.
If the path to the connection file is "connections/yourconn.asp", and you're
in a page within a subdirectory of your site, then the path will be invalid.
Change it to "../connections/yourconn.asp".
If your host doesn't allow .., then you'll have to do something else. I
wonder if you can do root relative links in the include statement. That
would work.

If your local and remote directory structures don't agree, then, well, good
luck keeping it all straight. :)

"gemora" <webforumsuser@macromedia.com> wrote in message
news:d5tfhd$d7q$1@forums.macromedia.com...

> This problem has to do with .ASP and Access database using both DSN an
> DSNless
> connections.
>
> I have a bunch of websites hosted with a local host (same host for years),
> and
> have run into a very odd but disturbing problem. I was trying create some
> pages
> using an existing database and connection, but for some reason DW will not
> display the table information. DW does in fact connect successfully to the
> DB
> however, so I am really stumped. It gives me 2 popup error windows....One
> that
> says.
>
> "Unable to retrieve tables from this connection, click on the 'Define...'
> button to test this connection."
>
> Followed by this popup window...
>
> "The relative path to the Connections folder is no longer valid.
> This will be corrected automatically when you click OK in the server
> behavior
> dialog box."
>
> I am genuinely confused to what I have done to cause this problem. At
> first I
> thought it was only going on with one of my defined sites, but it turns
> out
> every one of my defined sites is having this same problem.
>
> It also gives me these errors on recordsets in .ASP pages that are already
> in
> existance and are currently working on the server (in recordset panel or
> server
> behaviour panels I get little red exclamation points where there are
> problems).
>
> I am hoping that I am just overlooking something completely obvious here.
> Any
> help is appreciated!
>
> Thanks in advance,
>
> gemora
>

[gemora]

Thank you for the reply Lionstone!

Nothing in the structure has changed on my end. In fact after much testing
today, I have found that I have 3 accounts with them that are still working
and displaying table info as normal. These accounts are all on different
servers, and I am still thinking that it may be something on the hosts end.
They have insisted that it is something on my end however.

I sent an email to the host asking about the ../ in the connection include
being a problem as well as letting them know there are some working accounts
still.

Thanks again for your input Lionstone. If anyone has any other ideas or
suggestions, please share. :)