General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Getting Table not found from a MySQL select
Environment versions
Network:
Windows 2008 Server
I'm using FoxPro. On the MySQL at my office that I control I can connect via ODBC, query the tables and insert new records.
At my client with MySQL, from my compiled VFP app, I get a successful connection via ODBC to the VOX database, but every attempt to access a table eg "select * from Vox_Projects" I get an error "..Table vox.vox_projects not found.
I'm on a machine that accesses and updates this table in the VOX database thru Access.
I don't have the MySQL command program on the computer I'm on at the client's office. The programmer who set it up is in NY and says it was years ago, so is not a big help.
Could this be a privileges issue? Can they hide the tables from a different program? Is there a SQL command I could execute in my compiled program to test for it?
Or do I need to get access to their computer with the MySQL command program to see and change the privileges?
Or can I download the free MySQL onto the machine I use there and run the MySQL command line and change from there?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only