LiveCode Forums.

Hi,

I have a slight problem that I cannot find reference to.

What I am able to do successfully:
- Connect to a database on a hosted GoDaddy server with two types of access (full and read-only).
- Disconnect from the database.

Okay, so that is less than impressive. When I try any query, I get the error that the table does not exist in the database. Using other database tools, I know exactly what the structure of my database is. Here is an example of my problem:

Example Database Name: thename
Example Table Name: account

Any query on the table "account" returns an error that the table "thename.account" does not exist. What I cannot figure out is why the database name is being prepended to the database table name.

Any help would be greatly appreciated.

Thanks,
Ed

edljr wrote: Any query on the table "account" returns an error that the table "thename.account" does not exist. What I cannot figure out is why the database name is being prepended to the database table name.
Ed

Are you sure that the connexion is successfull ? If you can't make any query, how do you know you if the connexion is "full" or "read" only ?

You should show us the script you use for the connexion, and the script for the query.

A few thoughts...
1) like bangkok, I wonder if you are actually getting a genuine connection. This sounds like you're accessing the DB via a remote connection, so is the "Allow Direct Database Access" option enabled?
2) I can also believe you have a valid connection. I am assuming that "thename" and "account" are fake values for your explanation. If not, then maybe you are using "thename" as a variable and the query is taking it as a literal.
3) Assuming those are not the case, it is possible that your real db and table names are reserved words. If you enclose all references to the names in `backticks` (usually the key to left of digit 1 on the keyboard) does that help?
4) Really just guessing, to help any more we really need some more code lines.