Connection to ODBC access database failure

Hi!
You could try this It worked for me on all my connections.
I found a extension called SP2DBFix1.0.2.mxp
Down load here,
http://download.macromedia.com/pub/dreamweaver/extensions/SP2DBFix1.0.2.mxp
to fix a XP pro service pack2 connections.
To fix: I went to Sites/Advanced/Remove connection Scripts, ran that removed
my
connection scripts. I then shut down Dreamweaver 8 installed the extension
then opened dreamweaver 8 made a new connection and it works now Great! Im
happy.
You have to run this same routine on every site you have setup with
connection scripts
Good Luck.
Dave

"JOhnny Odgaard" <webforumsuser@macromedia.com> wrote in message
news:ersvva$2hd$1@forums.macromedia.com...
> I have made several sites using ACCESS databases via ODBC DSN name. But
> suddenly it does not work any more. I can not use the Database wizards in
DM
> 8.02. When I have made a connection, tested it OK and I try to se the
> tables/views. I only got the word "none". If I in the advanced recordset
wizard
> write the SQL command, the data is showen correctly!!???
>
> There is something wrong with DM's abillitry to connect to the ODBC DNS
> name...Everything is updateted to the latest version.
>
> Is there anybody who have any clue to what could be wrong. It is the same
> story on an old 2000 Server, a new 2003 small busines server and from DM
> installed on two different clientmaschines and on the two servers.
>

Make sure your DSN is pointing to the correct database.