I have created the sql sever 2008 r2 datastore, but not able to fetch the external metadata tables, looks like ODBC drivers are missing on my machine.
Is there a specific place where I need to install them.
I created the SYSTEM DSN going to control panel -> Admin tools -> setup datasource, but that did not work.
If somebody can provide me the steps, I will highly appreciate that.
Error file is attached.