Copy link to clipboard
Copied
Hi All,
I have installed Colfusion 2016 in my Windows 10 pc, and I have some problem setting the data source on ODBC 32Bit.
Regards,
Sonny
Copy link to clipboard
Copied
What problem? Can you provide specific errors or other information? Also, Windows 10 32-bit or 64-bit?
Copy link to clipboard
Copied
Hi Carl,
Thank you for giving time, ColdFusion 2011 has not problem on it, only occur on ColdFusion 2016
Adding ODBC
When verify the connection.
Copy link to clipboard
Copied
The first screenshot suggests you are configuring an ODBC connection to a database, but the second (the verification error) indicates you are using the Microsoft Access driver. Which is it?
Copy link to clipboard
Copied
Also, I'm going to move this into the ColdFusion Database sub-forum, as many of the database experts hang out in there and don't necessarily monitor the main forum.
Copy link to clipboard
Copied
Hi Carl,
I'm trying to connect on Microsoft Text Driver which is in 32bit.
Thanks,
Sonny
Copy link to clipboard
Copied
Did you install the 32-bit or 64-bit version of ColdFusion?
Copy link to clipboard
Copied
Hi Carl,
I have installed 64bit version.
Copy link to clipboard
Copied
Then try configuring a 64-bit ODBC Data Source. On 64-bit versions, there are two ODBC Data Source Administrator applets. If you search "odbc" in the Windows 10 search box, you'll see "Set up ODBC datasources (64-bit)" and "Set up ODBC datasources (32-bit)". Launch the 64-bit one.
Copy link to clipboard
Copied
Hi Carl,
I have try the ODBC 64-bit, it will have the same problem. in your environment is ok?
Regards,
Sonny
Copy link to clipboard
Copied
I don't have ColdFusion 2016 installed anywhere, so I can't dig in from that angle. After a closer look at the error message you get in CF Administrator, I'd guess a permission issue in your registry? Do you run the ColdFusion under a specific account, or just Local Machine? If a specific user, you need to go into the registry using Regedit.exe, navigate to the key that is listed in the error ( HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI ) and grant permissions to that user (I think read is adequate).
Copy link to clipboard
Copied
Can you share the details with screenshot at cf.install@adobe.com