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
Did you define the datasource with the 32-bit or 64-bit dsn tool?
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!