Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread EWB, ADO and MySql
Mon, Sep 2 2013 1:42 AMPermanent Link

Eivind

Dear Support

I just downloaded EWB as a trial. The product looks great and exactly what I need as a long term Delphi programmer. I'm trying to connect to MySql and have a few questions.

1. Am I correct assuming that using the Elevate web server, I dont need any other 3'rd party JSON lib's etc? Meaning the, add, edit, delete database operations are handled for me?

2. Using EWB I click on new "Add new dataset". I already installed ODBC drivers for MySql and it connects successfully in the ODBC manager. I choose type = ADO. I then build a connection string choosing "Microsoft OLE DB Provider for ODBC". I select the previously created ODBC source and click test connection. It fail with the following error message:

"Test connection failed because of an an error initializing provider. [Microsoft][ODBC Driver Manager] The specified DNS contains an architecture mismatch between the driver and the application."

If I can get some info on how to connect and use EWB, I'm sold. At the time, my budget can cover a license for the EWB, but if I need any further db lib's like dbIsam or ElevateDB it can take a while longer

Thanks in advance for any info.

Eivind
Tue, Sep 3 2013 1:45 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eivind,

<< 1. Am I correct assuming that using the Elevate web server, I dont need
any other 3'rd party JSON lib's etc? Meaning the, add, edit, delete database
operations are handled for me? >>

Correct.

<< 2. Using EWB I click on new "Add new dataset". I already installed ODBC
drivers for MySql and it connects successfully in the ODBC manager. I choose
type = ADO. I then build a connection string choosing "Microsoft OLE DB
Provider for ODBC". I select the previously created ODBC source and click
test connection. It fail with the following error message:

"Test connection failed because of an an error initializing provider.
[Microsoft][ODBC Driver Manager] The specified DNS contains an architecture
mismatch between the driver and the application." >>

You're using a 32-bit ODBC driver with a 64-bit DSN, or vice-versa.  EWB's
IDE is 32-bit, so you need to make sure that you're accessing a 32-bit
DSN/Driver combo.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image