Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Connection to ODBC access database failure

Community Beginner ,
Feb 25, 2007 Feb 25, 2007
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.
TOPICS
Server side applications
387
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 25, 2007 Feb 25, 2007
Make sure your DSN is pointing to the correct database.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 25, 2007 Feb 25, 2007
LATEST
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.
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines