2 Replies Latest reply on Apr 23, 2010 1:43 AM by Wayne Bodimeade

    No Local DSN List

    sukuso Level 1

      I am unable to view the list of System DSN's in Dreamweaver. I have recently upgraded my operating system to Windows 7 Ultimate 64bi
      t and installed Creative Suite.

       

      I have created System DSN's connecting to a SQL Server (which connect to their databases successfully), however, when adding a datab
      ase to my site (ASP/VBScript) I select 'Using Local DSN' but the drop down menu next to 'Data source name' is blank.

      Operating System: Windows 7

        • 1. Re: No Local DSN List
          bregent Most Valuable Participant

          Did you define the datasource with the 32-bit or 64-bit dsn tool?

          • 2. Re: No Local DSN List
            Wayne Bodimeade

            I am having the exact same problem. Been tearing my hair out for the past two days - even phoned and emailed support and they suggested I look up the problem on the web - great support guys!

             

            Anyway, enough ranting, SOLVED IT!!!

             

            You were right about creating the DSN being created by the wrong tool. You need to create it by launching C:\Windows\SysWOW64\odbcad32.exe.

             

            All of the previously created DSN's will not be there and when you create a new one.... voila!... it now appears in the local DSN list! HOORAY!!!

             

            Thanks bregent, you're a star!