Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread Step By Step Explanation of Connection To MySQL
Sun, Oct 28 2012 4:35 PMPermanent Link

Joe

Roadmaster

Hi Tim

How to connect to existing MySQL data?
A step by step explanation will clarify my newbie's state of affair.

JOe
Mon, Oct 29 2012 1:52 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Joe,

<< How to connect to existing MySQL data?  A step by step explanation will
clarify my newbie's state of affair. >>

You need to define a dataset in the DataSet Manager in the IDE first:

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=DataSet_Manager

For MySQL, you'll at least need the ODBC driver for MySQL installed, and the
easiest way to connect is to define a DSN using the ODBC administrator
(Control Panel/Administrative Tools/Data Sources (ODBC) and then set the
following properties the Connection Properties page for the dataset in the
EWB DataSet Manager:

Data Source=<ODBC DSN Name>
Provider=MSDASQL

You can then use the Test Connection button to make sure that everything is
working okay.

I'll be adding property editors for the dataset Connection Properties page
shortly, and that will make selecting/setting such properties *a lot*
easier.

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

Tim Young
Elevate Software
www.elevatesoft.com




Tue, Apr 9 2013 9:52 AMPermanent Link

Paul Waegemans

IMS bvba

Avatar

Can the "connection properties" databasename,RemoteUser,RemotePassword (and others) been changed at runtime?



"Tim Young [Elevate Software]" wrote:

Joe,

<< How to connect to existing MySQL data?  A step by step explanation will
clarify my newbie's state of affair. >>

You need to define a dataset in the DataSet Manager in the IDE first:

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=DataSet_Manager

For MySQL, you'll at least need the ODBC driver for MySQL installed, and the
easiest way to connect is to define a DSN using the ODBC administrator
(Control Panel/Administrative Tools/Data Sources (ODBC) and then set the
following properties the Connection Properties page for the dataset in the
EWB DataSet Manager:

Data Source=<ODBC DSN Name>
Provider=MSDASQL

You can then use the Test Connection button to make sure that everything is
working okay.

I'll be adding property editors for the dataset Connection Properties page
shortly, and that will make selecting/setting such properties *a lot*
easier.

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

Tim Young
Elevate Software
www.elevatesoft.com




Tue, Apr 9 2013 4:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Paul,

<< Can the "connection properties" databasename,RemoteUser,RemotePassword
(and others) been changed at runtime?  >>

No, these are controlled by the web server/back-end.  The next release will
have dataset adapters for use with custom modules, and that will give you
that level of control in the EWB Web Server and modules, but right now the
dataset management is all "black box".

BTW, I'm still looking into your issue.  I had the framework "torn apart"
yesterday, so I'm still putting it back together before I can test your
project.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Apr 10 2013 8:45 AMPermanent Link

Matthew Jones

> I had the framework "torn apart"
> yesterday, so I'm still putting it back together before I can test
> your project.

Would I be right in thinking that the Monday expectation isn't likely to be this
week based on this? Just need to plan scheduling so I'm assuming not going to get
1.02 this week...

/Matthew Jones/
Wed, Apr 10 2013 3:08 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Matthew,

<< Would I be right in thinking that the Monday expectation isn't likely to
be this week based on this? Just need to plan scheduling so I'm assuming not
going to get 1.02 this week... >>

No, I'm pretty far behind at this point - support has been crazy this week
and I've run into some issues with the way that I implemented the static
theme style management in the last release.  The new event management is all
done, and working quite well, though, so that's a plus.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Apr 10 2013 3:53 PMPermanent Link

Matthew Jones

Thanks for the update.

--
Matthew Jones
Fri, Apr 12 2013 7:43 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Matthew,

The good thing is I'm done tearing up the framework, it's back together and
working great, and I'm back to finishing up the 1.02 release.  I'm going to
push hard for a release early next week.

In case anyone is wondering, there was an issue with class
methods/properties and how I had modified the style loading for themes to
improve performance.  I had to rewrite the entire way that the theme styles
are loaded and then "tagged" to a particular class of control.

Tim Young
Elevate Software
www.elevatesoft.com
Image