I have MicrosoftR Visual FoxProR OLE DB Provider 220.127.116.1104 installed. In the visual database tool, when I run "SELECT DATE() FROM MYTABLE", visual studio will give me the follow error:
Error in SELECT clause: expression near ')'.
Error in SELECT clause: expression near 'FROM'.
Missing FROM clause.
Unable to parse query text.
However in visual studio 2003 on another machine, everything works fine.
I tried to reinstall visual studio 2005 and the fox pro ole db provider many times. I still get the errors. Also, I remember it works on my friend's visual studio 2005.
Can someone give me some help to fix this
Also, "Verify SQL Syntax" returns "This command is not supported by this provider".