Hi Statalisters,
I am running Stata 13 on a 64-bit Windows machine and trying to configure an ODBC connection to pull data from MS Access 2010. I was able to successfully set up the Data Source my_source using C:\Windows\SysWOW64\odbcad32.exe and when I run
my_source appears.
However, running:
Returns:
I think the issue is that the 32-bit driver is in the wrong place. Has anyone run into this issue? I'm not sure whether I should be trying to configure the 64-bit driver instead, or if I need to move a 32-bit driver into the folder specified in the error message.
Thanks,
Mike
I am running Stata 13 on a 64-bit Windows machine and trying to configure an ODBC connection to pull data from MS Access 2010. I was able to successfully set up the Data Source my_source using C:\Windows\SysWOW64\odbcad32.exe and when I run
Code:
odbc list
However, running:
Code:
odbc query "my_data", dialog(complete)
The ODBC driver reported the following diagnostics
Specified driver could not be loaded due to system error 126: The specified module could not
be found. (Driver do Microsoft Access (*.mdb), C:\Windows\system32\odbcjt32.dll).
SQLSTATE=IM003
Specified driver could not be loaded due to system error 126: The specified module could not
be found. (Driver do Microsoft Access (*.mdb), C:\Windows\system32\odbcjt32.dll).
SQLSTATE=IM003
Thanks,
Mike
Comment