This article is a list of the most
common questions asked in our forums and to our support.
Q. I'm trying to connect to my server but
there is an error message saying it couldn't connect. Why?
A. You may check the section 'What do to in case of problems' in the DBManager Online Help
for details and answer.
Q. I'm trying to connect to my MySQL server
but I'm getting the error "access denied for user@host
(Using password: YES)". What can I do?
A. Check the privileges for this user,
specially if he/she has privilege to connect to the server from the host where
the DBManager is installed. You can find more information in
What do to in case of problems section of DBManager's online help.
Q. I'm trying to import a MS-Excel worksheet
into a table but I'm getting an error Numeric Overflow. Why?
A. The columns defined in the worksheet
should be formatted identically. Avoid using different formats (like text and numeric)
in the same column in different rows. It's also very important to reorder the
rows to have the empty columns at the end. The DAO drivers tries to guess the
field type from the first couple of rows (I'm not sure how many). When finding
empty cells they are treated as text. One solution to avoid these problems is
importing the worksheet into a MS-Access table and then to convert/import this
data using the DAO Import
Q. The DBManager is crashing every time I
try to Import a MS-Access 2000 database. Why?
A. To import MSOffice 2000 or higher files
(MS-Access, MS-Excel) you need to use DAO 3.6. If you have
installed MSOffice it's just a matter of checking the option Settings
Þ Data Þ Use Dao
Q. If I try to import a very simple Access97
database table I get SQL errors, but I can't see why.
A. MS-Access allows you to use reserved words
as table and column names. MS-Access also allows for some special characters
to be used in these names,
like: spaces, quotes and a variety of strange chars. The DAO Import Data
Wizard replaces these chars with _ (underline). In DBManager Professional
there is a table in the Catalog to register reserved words. If
the wizard finds a reserved word it adds fd_ at the beginning. This solves the
Q. When using the Table Editor, After I save
and try to add more fields I get a message about the MYISAM file not able to
rename it because its locked (Error 13). My database server is installed on a
Window NT4 or 2000 Server. Why?
A. This problem has been reported by many
users using MySQL on Windows NT 4 or 2000 servers. We tried to debug the MySQL
C API to solve this problem but without success. It only causes problems on
Windows systems. If you are using the database server on a Linux Box
everything works like it should.
Q. I'm trying to import a DBF or paradox
table into my database server. When I select the data source in the DAO Import
Wizard I get an error message like "Couldn't find the ISAM driver". Why?
A. Run the MSOffice setup again and install
the additional ISAM drivers you need. By default the DAO drivers only works
accessing MS-Access Databases (*.mdb). For other sources (Clipper/Dbase/FoxPro
DBF, Paradox, MS-Excel, etc) you need an extra driver, called ISAM installable
driver. These drivers may also be required if you are trying to import from
these sources using DAO ODBC.
Q. I inserted a server and it is connecting
just fine. The problem is whenever I create a new database it doesn't show up
in the Tree control. I can't select another database other than the one I
chose in the Server Manager connection. How can I fix that?
A. When configuring a
new server connection the database options will only used for only that database. This is specially useful
when connecting to some servers which are configured not to show the databases
available on the server. If you want this connection to handle all databases
you must leave the database field empty. This only affects MySQL servers.
Q. My MySQL servers has at least 10
databases but I only can see just a few when I connect to the server. I left
the database field empty, so I could manage all of them in one connection. What is happening?
A. Probably the user you are using to
connect to the server doesn't have enough privileges on some databases. Whenever a
connection is made to the database server, a list of the available databases
is recovered and a USE db is issued against it to test if you have sufficient privileges
for it. You can solve this by giving at least the privilege USAGE on each
database. Remember that USAGE is not available on all MySQL versions. Check
the MySQL manual for additional information.
Q. I'm connecting successfully to a
PostgreSQL server over a modem connection. The problem is every time I try to
select one of the databases to see its tables it takes a long time to perform
the task. Why?
A. PostgreSQL doesn't allow issuing a USE
database command like MySQL does. In fact each connection to the server needs
a database. The DBManager handles this by closing the previous connection and
opening a new connection with the new database. Using a modem connections can be
slow. In this case try using a different connection for each database
you need to manage, creating extra connections in the Server Manager. Remember that if your database has many tables, it will take a long time
Q. I have just created a Foreign Key on a
InnoDB Table in my MySQL database. Why doesn't it show up or raise any error
A. MySQL doesn't have any C API function
nor SQL command to recover that information from its catalog. The only place
where you can retrieve this information is issuing a SHOW TABLE STATUS and take a
look the comment field. Unfortunately, this is not a good solution since many
things may appear on this field, including table comment and InnoDB free
Q. I have successfully created a Foreign Key
in a InnoDB table. The problem is that I'm trying to drop it but I couldn't. Why?
A. This is a InnoDB problem. MySQL and
InnoDB currently don't support DROP CONSTRAINTS. Please, check the
MySQL manual for additional information on this matter. MySQL developers have
been releasing new versions very quickly.
Q. I'm trying to create a Foreign Key in a
MySQL table. Although no error message is raised the Foreign Key is not
created. Yes, I checked the table comment to find that out. Why?
A. Only InnoDB tables support Foreign Keys.
Check if you are trying to create constraints on another table type.
Q. I'm running a query, with correct syntax, but I'm getting an error message "Query is Empty". I tested the query
in the mysql/pgsql console and it worked just fine. What's wrong?
A. In the mysql/pgsql console you need to
end a query with the character semicolon (;). This is only needed if you are
running a query in the console application. In the Query Editor the query
needs no ending character. Remove the semicolon and run the query again. This
happens because the query editor parses the query to send the queries
individually. After reaching the semicolon and nothing after it, it results in
a empty query, which causes the error.
If you have any questions, please check out support center for detailed information.