ODBC - Call failed

[rkrause]

i am getting a ODBC -- Call failed error
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect Syntax near 'dbo' (#102)
when running reports.

This is an access 07 application created on a windows 7 64 bit PC. I have 2 linked tables to a Microsft Dynamics views i created, i am linking them through ODBC connection. Everything works fine on my pc, but when another user tried to use it she gets the above error. Shes got a Winxp 32bit PC.

Any help would be awesome! Thanks!

 

[boblarson]

You did use the 32 bit ODBC driver (which would have required you to open the ODBC manager at C:\Windows\WOW64\ODBCAD32.EXE) didn't you? You didn't just use the one at Control Panel > Administrative Tools > Data Connections (ODBC)

 

[rkrause]

Yes i used the one in the WOW64

 

[boblarson]

Could it be that they don't have the correct security set to be able to do this? Can you log into their computer and see if it happens when you are logged in under your username?

 

[rkrause]

Not sure what the deal was, but i deleted her ODBC and recreated it and it seemed to work...