Home  |  Overview  |  Download  |   Purchase  |  Support  
 
Frequently asked questions
 
  Ordering process

General questions

Technical questions

 


Ordering process

I've ordered ERDConcepts through the Share-it website but I am still waiting for the registration email
In most cases you will receive a confirmation email within 24 hours. All orders are individually checked and processed. Please contact sales once you are waiting over 48 hours. Also make sure the registration email is not deleted by your anti spam software.
   
The website says I receive a discount for future major releases. What does it  mean?
You buy a license for a major version. Minor versions, including new features are free of charge. When a new major version is released you must buy a new license when you like to upgrade. Existing customers may receive an additional discount.
   
Do you offer any satisfaction guarantee, such as that I can return the product and get a refund within a certain period?
There is no refund period. You can download the trial version and evaluate all features ERDConcepts provides before purchase. The trial is not restricted in any way and is the same as the full version. However in special cases we can decide to make an exception. With regard to this subject, please contact us before purchasing the software.
   
As I am considering using ERDConcepts in my Oracle training classes, could you provide some information on the reseller/affiliate arrangement?
As a reseller/affifliate you will receive a fee for each license you sell. You can register as an affiliate through the Share-it control panel (Share-it will handle all sales related issues). For more details on the Share-it affiliate program you can visit the Affiliate program page.

You can also place your orders directly with Polderij (contracted) by sending us a fax order form with the license keys you need. You will then receive an invoice per order. Each license has a unique registration name / license combination. If you need a personalized copy of ERDConcepts for each student (including home use) the affiliate program is the best way to go.
   
I am considering purchasing 5 licenses of ERDConcepts here in the USA but need a conversion to US dollars
You can visit our site and click on the link "buy now". You will then go to the Share-it order page were you can select US dollars as the transaction price.
   
I am currently evaluating database design tools for use in an academic research project at a university. Accordingly, I am writing to inquire whether your company offers a discounted version of ERDConcepts for academic use.
We provide no special academic/student licenses just because it is very hard to determine if someone is really a student or not. Documents differ between countries, and we also do this to prevent everyone involved from going through a lot of paperwork. But we try to keep the price of the software at such a level that it is affordable for everyone.

General questions

I would like to use ERD Concepts model on my website. May I use the XML model files and screenshots?
You are allowed to use the XML information in the *.hf/*.ecm files and screenshots to generate your own custom reports and tools. Also showing them on your own website is no problem. There is no support however for the XML contents within the ERDConcepts design files. Besides the software there is no copyright on the model files, derived reports and images.
   
I have bought ERD Concepts. I have a serial number how do I convert the trial to a full version?
You first need to download the full version of the software from our website. You can find the url or download link in your registration email. Keep this email in a safe place because you need it to download any future updates.

Technical questions

Enabling SQL Native Client (SQLNCLI) from ADO:
When I run "Execute SQL" with a SQL server ADO connection some columns are not displayed in the resulting grid. How can we solve this?

To enable the usage of SQL Native Client, ADO applications will need to implement the following keywords in the connection strings:

Provider=SQLNCLI
DataTypeCompatibility=80

This flag specifies the mode of data type handling to use. Recognized values are "0" for provider data types and "80" for SQL Server 2000 data types.

   

The specified DSN contains an architecture mismatch between the Driver and Application.

I downloaded the ODBC driver for Postgresql and created a data source from Control Panel. The testing on the data source itself was successful. However, I was unable to connect to the database using that data source. I received an error like:

Microsoft Data Link Error:
Test connection failed because of an error in initializing provide. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

To manage a data source that connects to a 32-bit driver under a 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe.

If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:

The specified DSN contains an architecture mismatch between the Driver and Application

To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN. A data source associates a particular ODBC driver with the data you want to access through that driver. For example, you might create a data source to use the ODBC dBASE driver to access one or more dBASE files found in a specific directory on your hard disk or a network drive. Using the ODBC Data Source Administrator, you can add, modify, and delete data sources.

http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx
    
Does ERD Concepts support Submodels aka Subdiagrams?
Yes, submodels are supported, however they are called "pages" (design page) in ERD Concepts. There is one main page which you can divide into sub-pages. In combination with the page completion tools you can add, edit and delete objects from the sub-pages.
    
How do I connect to an Access 2007 (and above) (.accdb) database?

You will need the "Microsoft.Ace.OLEDB.12.0" office driver. This is installed with Office 2007. Please visit the Microsoft website for additional information. Or, if you don't have Acccess 2007/2010 on your machine, you need to download the Microsoft Access Database Engine 2010 Redistributable (32 bit).

Make sure you install the 32 bit version of the drivers.

Your connection string should look like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<your database>.accdb;Persist Security Info=False

   
I have connected to an Oracle 10i database instance and choose ‘Database->Reverse Engineer...’ menu item. The dialog window is displayed, but the drop down list is empty and nothing happens
Try to connect to a simple database like MS Access and see if it works.

Most probably you have no read access rights to the meta data of the database. Also make sure you have selected the correct database script in the database connection editor. Default the ADO framework method is used but in your case you need to select Oracle 9i Script
   
How do i connect to a MySQL database?
1. Open ODBC MySQL driver configuration (windows configuration)
2. Enter a datasource name, the required username and password
3. You must select an intial database in this dialog!!!
4. Start ERD Concepts and create a new Database connection
5. Select the OLEDB provider for ODBC drivers
6. Press Next
7. Select the ODBC MySQL datasource you specified earlier
8. Reenter your username and password
9. Don't select an initial catalog!!!
10. Test the connection, it should work now
   
Connecting to a database through ADO fails
Try to connect to a simple database like MS Access. If that also fails make sure you've have the latest MDAC ADO drivers installed. You can also visit the very useful site http://www.connectionstrings.com
   
I've just downloaded your software and cannot get the reverse engineering feature to work
Make sure you are using the correct database script. You can select this script in the database connection editor. By default the ADO general framework method is used which is very limited in reverse engineering capabilities.
   
Whenever I reverse engineer my database, my datatypes are being swapped (varchar to nvarchar, datetime to timestamp, etc.). How can I prevent this from happening?
In general this happens when you reverse engineer for example a MySQL "database" into a SQL Server "model". You can also have data type translations when you reverse engineer with the database script ADO Framework. In that case you can change the ADO data type settings which you can find under the tool menu.

1. Make sure you use the correct database script (Connection Editor)
2. Make sure you have the correct model (database platform) open

   
When I reverse engineer my existing database in SQL Server, views and routines do not have their script populated.  When I try to validate the model I get an error for every view or stored procedure saying that the script definition is empty.
Make sure you are using the correct database script. You can select this script in the database connection editor. Default the ADO general framework method is used which is very limited in reverse engineering capabilities.
   

I added a new page to my ERD and then imported existing tables from the main page. It looks like everything was brought over with the exception of the relationship lines. I can add the lines in manually but it adds another column and relationship. Is there a way to show the lines from the main page?

1. You can copy the relationships from the main page to your new page
Activate the main page and use the right mouse button on the relationship. Select the option <position><Copy to Page>
 
2. In your new page use the add objects dialog
Activate your new page and use the right mouse button anywhere on your model area. Select the option <add model objects>. There you can add the missing relationships.
   
I have been working with a data model for some time now. However when I open a table and go to the trigger tab and try to open an existing trigger ERDConcepts seems to freeze.
* Open the environment settings window, tab "cache"
* Press the clear form cache button to reset all windows to their default position
 
Maybe the trigger window got misplaced somehow and ended outside your desktop boundaries as each window position is saved after closing. This could cause a problem as you never get to see the dialog while it is active.
 
  
   DB Toolbox
  Data Generator
  Paradox to MDB
  CSV Splitter
  Dataset to CSV
  Connection string checker
  Empty Tables
  
 
 
 



 

Home Product Purchase Support  
 News
 Affiliates
 DB Toolbox
 Overview
 Model gallery
 
What's new
 
Release history
 Buy now
 Upgrade now
 
Upgrade policy
 
Request invoice
 FAQ
 
Bug report
 About
 Contact