Hi Tim

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

JOe

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

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

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

> 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/

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

Thanks for the update.

--
Matthew Jones

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