(2) What is the purpose of "Use Default User name" is for? it was checked by default. I did not see this option in CF v7.
>> For some reason, it populates the email account that I entered in CF admin Mail Server Settings sectionAre you sure? AFAIK, the 2 are totally unrelated, so something like that would be a really big bug on CF's part.
>> There is no password for any of my ACCESS databases.Then leave the "Use default user name" box checked (do not enter a username or password). That tells CF there's no special credentials on the database. CF will just use the defaults instead.
I am curious why CF v7 does not have anything and CF v11 creates one when I create a datasource and I have to create another one manually??
- key: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{Data Source Name here}
- value: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\{Data Source Name here}
- key: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\{Data Source Name here}
- value: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources\{Data Source Name here}
... To illustrate, just perform these 4 additional steps:
11. Delete the 64-bit DSN entries from the registry (after creating a registry backup):
- key: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODB C.INI\{Dat a Source Name here}
- value: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODB C.INI\ODBC Data Sources\{Data Source Name here}
12. Run <cfquery datasource="MyAccessDSN" and wahlah!
13. CF Admin > Data Sources
14. Click the Verify checkmark icon for the same data source. See Status is "OK"!