Knowledge Base

Please check first our knowledge base for solutions to your problem. If you can't find the right answer to your question select another support option on the right side.

Postgres SQL–Syntax

Question: I use POSTGRES SQL. But I see that the POSTGRES SQL SINTAXES is not implemented. Example: SELECT coalesce(ean.codean) ean FROM EAN There is an error: I think taht DB wants "as" For me it is important that all my QUERY to be used "how are now"   Answer: Currently DBxtra requires you to use [...]

Would like to try your product but am unable to connect to my Oracle 10g database.

Q: Would like to try your product but am unable to connect to my Oracle 10g database. It does not appear as though the connection screen requires enough information to properly connect.   In order to connect with the Service name you need to have the tnsnames.ora file configured on the PC on which you [...]

Oracle Connection Option

One of our customers asked if he need to have the TNSNAMES.ORA file configured on the user’s box for them to use DBxtra? Answer: There are three ways to connect to Oracle. 1. Direct Connection to Oracle You need to provide the Service name; which is the TNSName – TNSNAMES.ORA (Network Configuration File) which is [...]

MS SQL Server Windows authentication Problem

Some user who connect to MS SQL Server with Windows authentication experience problems when running the DBxtra Report Web Service. They might get a “Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection” error message. Here is the cause of the problem and the solution for it: When you use [...]

Access to MySQL database on shared hosts

Question: I can’t access my MySQL database on my shared hosting plan. Answer: Most ISP with shared hosting and also with VPS don’t allow access the the MySQL databases from outside the web-site. But in most cases you can add an exception in the CPanel. Select MySQL Databases. Enter your IP address. To get your [...]

© 2006 - 2012 - Advisionario S.A. de C.V.