FlySpeed SQL Query

A: There is no complete user's guide for FlySpeed SQL Query, but there is a guide for Visual Query Builder that included in the tool.

A: This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:

• A string value is being inserted into a numeric field.
• An invalid date expression is being inserted into a date field.
• A string value being inserted is longer than the size of the string field.
• A null value is being inserted into a field that does not allow nulls.

You have to re-look at your database and make the appropiate changes in the database i.e. change field to accept null(s) or increase field length.

Also you may update your MDAC package from the Microsoft web site.

A: You may repair/reinstall MDAC on Windows XP by yourself by following the steps below.

1. Open the folder C:\Windows\inf and locate the file "mdac.inf".
   Note: Your Windows folder could be named differently, e.g. C:\Windows
2. Right-click the file "mdac.inf" and click Install.
3. When prompted for a location, point to C:\Windows\servicepackfiles\i386
4. When prompted for the file "handler.reg", either point to C:\Program files\Common files\System\msadc, or put the Windows XP CD in your CD-ROM drive. (you may receive file not found error(s), click cancel and the continue with the installation)

For more details see this support article at Microsoft web site.

If this won't help you, try to (re)install Microsoft Data Access Components (MDAC). The appropriate package for your operating system can be found on the Microsoft web site. Wine users may use the following link to download MDAC: Microsoft Data Access Components (MDAC) 2.8 and use Wine-Doors to install Microsoft libraries.

A: The solution is to repair your Microsoft Data Access Components (MDAC). You may try this free-to-use tool to repair your MDAC installation: MDAC Repair Tool.

Also you may repair/reinstall MDAC by yourself by following the steps in the answer above.

A: You have to install the Oracle client software in order to connect to Oracle databases.

You can download the Oracle Instant Client at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html

To download the standard Oracle Database 10g Client or later, choose your client platform at http://www.oracle.com/technology/software/products/database/index.html

You can download the Oracle Database 9i Client for Microsoft Windows 98/2000/NT/XP at: http://www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html

You will need to register, but this is free and you can then access other useful pages on the Oracle web site.

Alternatively, contact your Oracle Database Administrator for the Oracle distribution CD. The standard Oracle Client is included in the Oracle distribution.

A: Make sure that "<OracleHome>\bin" folder is in PATH, and that some version of oraxy.dll, e.g., oci.dll, ora71.dll, ora72.dll, etc. exists in that folder or elsewhere in the PATH. For Oracle8, the OCI dll is named OraClient8.dll. For Oracle9, the OCI dll is named OraClient9.dll.

A: There are several reasons why you cannot connect to the local database. If during the connection you get the error "Can't connect to MySQL server on 'localhost' (10061)", then probably MySQL server is installed incorrectly or the service (usually with the name "mysql") is not running. To check if the service is launched, open "Control Panel" -> "Administrative Tools" -> "Services" and find the MySQL service. If you cannot find this service, you should try to reinstall MySQL. In case you find it, run it with the Start button or use Start item in the context menu. If you get the error "Access denied for user 'root'@'localhost' (using password: YES)", then check if you enter the password for the root user correctly in case you change it during installation. If you installed MySQL with default values, you should use the user name root with the blank password and port 3306 to connect to the server.
(More info ...)

A: There could be several possible reasons that prevent you from successful connection to remote database. If the error message says "Can't connect to MySQL server on ‘some host' (10061)" then probably you should check the correctness of port and host name you've entered and also if the remote server is run. It often happens that the port through which the connection is set with MySQL server (normally, it's 3306) is closed for the security reasons by local firewall, corporate firewall or remote server firewall. The remote server port can also be closed by ISP, or TCP/IP protocol support is disabled on MySQL server. Please check this with your system administrator or ISP.
If the error message says "Access denied for user: root@somehost.somedomain" or "Host not allowed to connect to server", then the reason is that the user doesn't have permission to access the database.

A: MySQL server uses client's login ('myuser' in your case) and the name of the host which it tries to set the connection from ('myhost.mydomain' in your case) for the client authentication. In your case the reason is that your 'myuser' user from the 'myhost.mydomain' host doesn't have permissions to access your MySQL server. It's quite possible that you successfully connected to your database with the same login and password in your PHP scripts or with the help of phpMyAdmin, but in this case MySQL server recognizes you as the 'myuser' user from the 'localhost' host who has the necessary permissions and allows you the access.
To solve this problem you should grant the necessary permissions to user myuser@ myhost.mydomain. You can do this with the help of phpMyAdmin or with the following SQL commands:

/*!50003 CREATE USER ‘myuser’@ ‘myhost.mydomain’*/;
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@ ‘myhost.mydomain’ IDENTIFIED BY 'user_password';

A: This error occurs because you don't have a permission to connect to remote MySQL server from your host. Please contact your database administrator or, if you have access to MySQL server with grant privilege, you can use the GRANT statement to add a new user. For example, the following command will give full access from your host to the user:

/*!50003 CREATE USER 'user'@'user_host'*/;
GRANT ALL PRIVILEGES ON *.* TO 'user'@'user_host' IDENTIFIED BY ' user_password ';