PDA

View Full Version : Webapp Server talking to MySql on Linux



Eric Vaughen
10-Jan-2006, 10:03 AM
How would I get an web services running on a Webapp server to talk to a
MYSQL database running on Linux and/or Windows.... (not sure which way I
am going to go)

Mark Rutherford
10-Jan-2006, 10:43 AM
I am not sure how to answer this...
You have an existing VDF application using MySQL data?
Or, is this data that is out there unrelated to df/vdf/webapp, ect?

As a rule, Webapp cant use a MySQL backend without a driver.
I dont know if you can use a schema that is alreay im place and have it
like the data, thats a question for the driver guys.

Eric Vaughen wrote:
> How would I get an web services running on a Webapp server to talk to a
> MYSQL database running on Linux and/or Windows.... (not sure which way I
> am going to go)

Eric Vaughen
10-Jan-2006, 11:22 AM
Mark Rutherford wrote:
> I am not sure how to answer this...
> You have an existing VDF application using MySQL data?
> Or, is this data that is out there unrelated to df/vdf/webapp, ect?
>
> As a rule, Webapp cant use a MySQL backend without a driver.
> I dont know if you can use a schema that is alreay im place and have it
> like the data, thats a question for the driver guys.
>
> Eric Vaughen wrote:
>
>> How would I get an web services running on a Webapp server to talk to
>> a MYSQL database running on Linux and/or Windows.... (not sure which
>> way I am going to go)

No do not have anything yet. I am hoping to setup a WebApp server using
MS/IIS on Windows and MySQL on a Linux( or windows) box... This is a
TEST BED setup... I need to get up to speed on these technologies.

I would like the WebApp to be able to retrieve data from the MySQL
server. I noticed the MySql website drivers for ODBC and .net... I am
not concerned right now about having VDF apps taling to the MYSQL
database but that may become an issue.

David Martinko
10-Jan-2006, 11:46 AM
You _should_ be able to use ODBC to connect to MySQL. VBScript can access
data from SQL databases as well, but that is outside your business rules.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com
www.redeemedhosting.com

"Eric Vaughen" <evaughen@gmail.com> wrote in message
news:VWB6OIgFGHA.5164@dacmail.dataaccess.com...
Mark Rutherford wrote:
> I am not sure how to answer this...
> You have an existing VDF application using MySQL data?
> Or, is this data that is out there unrelated to df/vdf/webapp, ect?
>
> As a rule, Webapp cant use a MySQL backend without a driver.
> I dont know if you can use a schema that is alreay im place and have it
> like the data, thats a question for the driver guys.
>
> Eric Vaughen wrote:
>
>> How would I get an web services running on a Webapp server to talk to
>> a MYSQL database running on Linux and/or Windows.... (not sure which
>> way I am going to go)

No do not have anything yet. I am hoping to setup a WebApp server using
MS/IIS on Windows and MySQL on a Linux( or windows) box... This is a
TEST BED setup... I need to get up to speed on these technologies.

I would like the WebApp to be able to retrieve data from the MySQL
server. I noticed the MySql website drivers for ODBC and .net... I am
not concerned right now about having VDF apps taling to the MYSQL
database but that may become an issue.

Garret Mott
10-Jan-2006, 11:57 AM
Hi All -

PMJI, but Mertech (www.mertechdata.com) has a VDF driver for MySQL.

Bo Lincoln has done a lot with VDF (not WebApp) & MySQL - but you might
want to check with him.

HTH,

Garret Mott

Auto-Mate Software www.automatesoftware.com
Northeast DataFlex Consortium www.nedataflex.com

"Eric Vaughen" <evaughen@gmail.com> wrote in message
news:jwvk9bfFGHA.4260@dacmail.dataaccess.com...
> How would I get an web services running on a Webapp server to talk to a
> MYSQL database running on Linux and/or Windows.... (not sure which way I
> am going to go)

wila
10-Jan-2006, 11:59 AM
Hi Eric,

Eric Vaughen wrote:
> Mark Rutherford wrote:
>> Eric Vaughen wrote:
>>
>>> How would I get an web services running on a Webapp server to talk to
>>> a MYSQL database running on Linux and/or Windows.... (not sure which
>>> way I am going to go)

Try the mertech data drivers for MySQL, it should just work, even if
your database is on linux.
There are demo versions available from the website.
Just start by developing your webapp on DataFlex, see if it works for
you and then simply migrate the database to MySQL.

--
Wil

Bob Worsley
10-Jan-2006, 12:31 PM
See Bo Lincoln's posting in the VDF forum, "Advantages of VDF" thread.
Bob

"Eric Vaughen" <evaughen@gmail.com> wrote in message
news:jwvk9bfFGHA.4260@dacmail.dataaccess.com...
> How would I get an web services running on a Webapp server to talk to a
> MYSQL database running on Linux and/or Windows.... (not sure which way I
> am going to go)

Peter van Mil
12-Jan-2006, 03:21 AM
Eric,

Talking about "freeware": isn't MS SQL Server 2005 an option? When you
didn't make a decision it might be a (free) option...

Peter van Mil

Eric Vaughen schreef:
> Mark Rutherford wrote:
>
>> I am not sure how to answer this...
>> You have an existing VDF application using MySQL data?
>> Or, is this data that is out there unrelated to df/vdf/webapp, ect?
>>
>> As a rule, Webapp cant use a MySQL backend without a driver.
>> I dont know if you can use a schema that is alreay im place and have it
>> like the data, thats a question for the driver guys.
>>
>> Eric Vaughen wrote:
>>
>>> How would I get an web services running on a Webapp server to talk to
>>> a MYSQL database running on Linux and/or Windows.... (not sure which
>>> way I am going to go)
>
>
> No do not have anything yet. I am hoping to setup a WebApp server using
> MS/IIS on Windows and MySQL on a Linux( or windows) box... This is a
> TEST BED setup... I need to get up to speed on these technologies.
>
> I would like the WebApp to be able to retrieve data from the MySQL
> server. I noticed the MySql website drivers for ODBC and .net... I am
> not concerned right now about having VDF apps taling to the MYSQL
> database but that may become an issue.