Setting up Visual query builder

I used to run querybuilder in my old computer. Now I transferred all my files to a new system and before setting up visual query builder, I ran one of my programs which had some SQL commands. I get this error now "Registry Editor - Cannot export C:\docume~1\locals~1\temp\ODBC.INI: Error opening the file. There may be a disk or file system error". This is a file path in my old system. After this error, if I click OK, the querybuilder opens but does not show the ODBC drivers when I click Define ODBC source -> MS Access database -> Add. But when I open C:\Windows\SysWOW64\odbcad32.exe, it shows the MS Access drivers.

I am using Windows 7 Professional 64 bit, MATLAB 2010b. I am not sure about how to edit the registry because I know it might create some problem if I do something wrong with registries. Can anyone please help me with this? Any help would be really useful. Thank you

-Mani

Answer 1

[Manikandan]

I will make it more clear. My ODBC data source points to C:\windows\system32\odbcad32.exe, while my original installed drivers are at C:\windows\sysWOW64\odbcad32.exe. This is the reason why it is not able to access the drivers. Any solution for this?

Thanks M

Answer 2

[Manikandan]

Solution:

The visual query builder does not work when you have MS Access 2010 (32 bit) and you install MATLAB (64 bit). So I installed MATLAB 32 bit and everything works fine as before.