Just finished installing SQL 2008 R 2 in a Windows 8 Pro PC. We can query the databases using the SQL Studio 2008 but can't seem to connect to the instance with an ODBC.
We want to connect an ODBC in the computer the SQL instance is located.
When creating the ODBC, at the user/password lever, we get the error:
e have tried using both 32 bit and 64 bit ODBC.
How can we have a working OBDC within the same PC where SQL instance is installed?