My VFP app connects to a MYSQL (soon to be a MariaDB) server running on
a dedicated Linux box via the Internet. My current design is that when
the app starts up it connects to the MySQL server and then keeps that
connection 'live' by using a timer every 15 minutes, sending 'SELECT
@@identity'
Short answer: Yes.
On Tue, Jun 4, 2013 at 6:00 PM, Mike Copeland wrote:
> My VFP app connects to a MYSQL (soon to be a MariaDB) server running on a
> dedicated Linux box via the Internet. My current design is that when the
> app starts up it connects to the MySQL server and then keeps that
> co
Oops. Hit 'Send' too soon.
Long answer: you're bring the Achille's Heel of FoxPro, the need for a
stable, long-term connection to the data, and transporting that to "the
cloud."
The internet was designed to survive nuclear war, but it doesn't guarantee
your connection won't get re-routed and need
ome testing.
Is there a way to test an existing sqlstringconnect() connection handle
to see if it's valid, without throwing an error? Or should I just trap
for the 1466 error and deal with it accordingly?
Thanks again for the wize-ness!
Mike
Original Message ----
Subject: R
On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote:
>
>
> Thanks for any wisdom or opinions.
>
My €0.02 is that exposing any database server to the public internet is
a bad idea, and web services are the way to go.
___
Post Messages to: ProFox@
Agreed, Alan. Thanks! Currently my server is locked down... only accepts
connections from specified IP addresses, extremely convoluted and long
password for login, connections are encrypted.
Mike
Original Message
Subject: Re: Client--Server via Internet
From: Alan Bourke
To
At 23:33 2013-06-04, Mike Copeland wrote:
[snip]
Is there a way to test an existing sqlstringconnect() connection
handle to see if it's valid, without throwing an error? Or should I
just trap for the 1466 error and deal with it accordingly?
Trap the error.
A point to keep in mind
Thanks Gene, point well taken. Appreciate the input!
Mike
Original Message
Subject: Re: Client--Server via Internet
From: Gene Wirchenko
To: profoxt...@leafe.com
Date: 6/5/2013 1:09 PM
At 23:33 2013-06-04, Mike Copeland wrote:
[snip]
Is there a way to test an existing
On Wed, Jun 5, 2013 at 11:25 AM, Mike Copeland wrote:
> Thanks Gene, point well taken. Appreciate the input!
>
> Mike
As was mentioned already, you gotta double check your connection
status each time you want to talk back to the mothership...
As to whether or not to maintain one connection or e
packet alignment, that
could expand rapidly and create sludge.
Thanks Matt!
Mike
Original Message
Subject: Re: Client--Server via Internet
From: M Jarvis
To: profoxt...@leafe.com
Date: 6/5/2013 1:44 PM
On Wed, Jun 5, 2013 at 11:25 AM, Mike Copeland wrote:
Thanks Gene
On 6/4/2013 6:00 PM, Mike Copeland wrote:
My VFP app connects to a MYSQL (soon to be a MariaDB) server running on
a dedicated Linux box via the Internet. My current design is that when
the app starts up it connects to the MySQL server and then keeps that
connection 'live' by using a timer every 1
On 6/4/2013 9:16 PM, Ted Roche wrote:
Oops. Hit 'Send' too soon.
Mike,
Here's my GetHandle routine:
PROTECTED FUNCTION GetHandle(tlForce as Logical) as Integer
* Returns connection handle to caller.
LOCAL liHandle as Integer, lcDSN as String, loException as Exception,
liRe
Do you ever destroy the connection? Leave the form could be a reason or
kill the app.
On Wed, Jun 5, 2013 at 4:42 PM, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> On 6/4/2013 9:16 PM, Ted Roche wrote:
>
>> Oops. Hit 'Send' too soon.
>>
>
>
> Mike,
>
> Here'
On 6/5/2013 12:56 PM, Mike Copeland wrote:
only accepts connections from specified IP addresses, extremely convoluted and
long
password for login, connections are encrypted.
This is another reason I feel fine with my VFP/MySQL approach, despite
the outcry from others for web services. Grant
Can you search your exe and find your connection string in raw text?
On Wed, Jun 5, 2013 at 4:47 PM, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> On 6/5/2013 12:56 PM, Mike Copeland wrote:
>
>> only accepts connections from specified IP addresses, extremely
valid understanding
of the consequences and risks, and let 'er rip, tater chip!
Mike
Original Message
Subject: Re: Client--Server via Internet
From: MB Software Solutions, LLC
To: profoxt...@leafe.com
Date: 6/5/2013 4:47 PM
On 6/5/2013 12:56 PM, Mike Copeland wrote:
DOH!
Okay, this isn't your first rodeo, is it Stephen?
Not to worry, I'll move the passcode to an encrypted file I use for
managing subscriptions on each workstation. Thanks for the eye-opener!
Darned pseudo-code...
Mike
Original Message
Subject: Re: Client--
On 6/5/2013 5:46 PM, Stephen Russell wrote:
Do you ever destroy the connection? Leave the form could be a reason or
kill the app.
Oh yes...I do a SQLDISCONNECT(0) on the exit of the program.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwar
On 6/5/2013 5:54 PM, Stephen Russell wrote:
Can you search your exe and find your connection string in raw text?
Nope...encrypted.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock
I am using amazon hosted mysql. Called rds. , quite secure
Just my 2c
Bob Lee
1amsoftware.com
On Jun 5, 2013, at 1:07 AM, Alan Bourke wrote:
>
>
> On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote:
>>
>>
>> Thanks for any wisdom or opinions.
>
>
> My €0.02 is that exposing any databa
I would agree with you, Bob, but to facilitate further discussion to
make it more clear, why would you say so? What makes your solution secure?
Thanks,
--Mike
On 9/15/2013 3:31 PM, Bob Lee wrote:
I am using amazon hosted mysql. Called rds. , quite secure
Just my 2c
Bob Lee
1amsoftware.com
With a WS you have security instead of just "userID/PW." You can set up
tokens, have another param passed in as well to allow presentation of
User/PW creds.
A raw exposed db is vulnerable Putting a layer between it and the world is
so much safer.
On Mon, Sep 16, 2013 at 8:07 AM, MB Software
On Sep 15, 2013, at 2:31 PM, Bob Lee wrote:
> I am using amazon hosted mysql. Called rds. , quite secure
What is special about this that makes it 'quite secure'?
-- Ed Leafe
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http
e.com
Subject: Re: Client--Server via Internet
I would agree with you, Bob, but to facilitate further discussion to make it
more clear, why would you say so? What makes your solution secure?
Thanks,
--Mike
On 9/15/2013 3:31 PM, Bob Lee wrote:
> I am using amazon hosted mysql. Called rds. , quit
On Sep 16, 2013, at 11:01 AM, Bob Lee wrote:
> I would have bet 100 bucks that your reply would include a RackSpace :)
I only offered that for comparison. You didn't get my sales pitch. ;-)
> Btw, you could do the same thing with Amazon, so you could host a
> webserver on their EC2 and th
On Sep 16, 2013, at 9:17 AM, Bob Lee wrote:
> In addition to firewall (static ip deny /allow) you can also setup vpc (like
> vpn ) connection .
> So with vpn/static ip/'s encrypted ssl data going over the internet/ and
> traditional mysql user/password it appears to me to be secure
> Howeve
On Mon, Sep 16, 2013 at 11:01 AM, Bob Lee wrote:
> I would have bet 100 bucks that your reply would include a RackSpace :)
>
> Btw, you could do the same thing with Amazon, so you could host a
> webserver on their EC2 and the database - as managed service (called
> RDS)
> and if you only w
of hosted solution.
Bob Lee
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Monday, September 16, 2013 8:40 AM
To: profoxt...@leafe.com
Subject: Re: Client--Server via Internet
On Sep 16, 2013, at 9:17 AM, Bob Lee wrote:
> I
Alan Bourke wrote on 2013-06-05:
>
>
> On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote:
>
>
> Thanks for any wisdom or opinions.
>
>
>
> My €0.02 is that exposing any database server to the public internet is
> a bad idea, and web services are the way to go.
>
Alan,
Since y
Me neitherin terms of current .NET
This might help:
http://www.codeproject.com/Articles/148762/NET-4-0-RESTful-Web-Service-Introduction
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
I tend to separate my projects for this type of solution into the class
functionality I need.
Your presentation of the link had code. The [ServiceContract] to me is an
entire set of classes that create presentation data for outsiders.
I separate, in the solution, this data from what internally
31 matches
Mail list logo