Connect via VB

[Damon]

I have been searching for post that matches my question and so far I
have not found one, which leads me to believe what I want to do iasn't
possible, but here I go...

My current web host supports MySQL and I have in fact setup a small
test database. I curerntly have a fairly simple VB app (a couple of
forms, a 3rd party activeX control, limited Access DB reads and
writes). It would be very helpful if I could run this app from home
or my office. (I work in a small office, rural location, limited
internet options - using 1-way cable modem). At this point we don't
really have the time or resources to operate our own web server
(unless I can convince my boss that it is worth it). Is there a way I
can connect my VB app to the MySql database running on my host, or can
I create an activex control to run on the server?. (The host is Unix
based, if that matters). I suspect the problem will be connecting to
that MySQL database via the Internet. I have done some vb scripting,
a couple of years ago, but nothing quite like this. And given my huge
workload, I haven't found the time to find out if this is possible.
Perhaps someone here knows a solution or can point me in the right
direction. Thanks.

Damon

[Jeff North]

On 11 Aug 2003 21:34:00 -0700, in mailing.databas e.mysql
da****@rcn.com (Damon) wrote:

| I have been searching for post that matches my question and so far I
| have not found one, which leads me to believe what I want to do iasn't
| possible, but here I go...
|
| My current web host supports MySQL and I have in fact setup a small
| test database. I curerntly have a fairly simple VB app (a couple of
| forms, a 3rd party activeX control, limited Access DB reads and
| writes). It would be very helpful if I could run this app from home
| or my office. (I work in a small office, rural location, limited
| internet options - using 1-way cable modem). At this point we don't
| really have the time or resources to operate our own web server
| (unless I can convince my boss that it is worth it). Is there a way I
| can connect my VB app to the MySql database running on my host, or can
| I create an activex control to run on the server?. (The host is Unix
| based, if that matters). I suspect the problem will be connecting to
| that MySQL database via the Internet. I have done some vb scripting,
| a couple of years ago, but nothing quite like this. And given my huge
| workload, I haven't found the time to find out if this is possible.
| Perhaps someone here knows a solution or can point me in the right
| direction. Thanks.
|
| Damon

What I think you need is a VPN connection (use the internet just like
a lan network connection.) Talk to your ISP about if this can be done
and the security implications (you could be opening your works'
network to hackers and all those unwelcomed 'visitors'.)

Converting your desktop app into a web based app is going to require a
lot of time, blood, sweat and tears :-(
---------------------------------------------------------------
jn****@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Jeff North]

On 11 Aug 2003 21:34:00 -0700, in mailing.databas e.mysql
da****@rcn.com (Damon) wrote:

| I have been searching for post that matches my question and so far I
| have not found one, which leads me to believe what I want to do iasn't
| possible, but here I go...
|
| My current web host supports MySQL and I have in fact setup a small
| test database. I curerntly have a fairly simple VB app (a couple of
| forms, a 3rd party activeX control, limited Access DB reads and
| writes). It would be very helpful if I could run this app from home
| or my office. (I work in a small office, rural location, limited
| internet options - using 1-way cable modem). At this point we don't
| really have the time or resources to operate our own web server
| (unless I can convince my boss that it is worth it). Is there a way I
| can connect my VB app to the MySql database running on my host, or can
| I create an activex control to run on the server?. (The host is Unix
| based, if that matters). I suspect the problem will be connecting to
| that MySQL database via the Internet. I have done some vb scripting,
| a couple of years ago, but nothing quite like this. And given my huge
| workload, I haven't found the time to find out if this is possible.
| Perhaps someone here knows a solution or can point me in the right
| direction. Thanks.
|
| Damon

What I think you need is a VPN connection (use the internet just like
a lan network connection.) Talk to your ISP about if this can be done
and the security implications (you could be opening your works'
network to hackers and all those unwelcomed 'visitors'.)

Converting your desktop app into a web based app is going to require a
lot of time, blood, sweat and tears :-(
---------------------------------------------------------------
jn****@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Jeff North]

On 11 Aug 2003 21:34:00 -0700, in mailing.databas e.mysql
da****@rcn.com (Damon) wrote:

| I have been searching for post that matches my question and so far I
| have not found one, which leads me to believe what I want to do iasn't
| possible, but here I go...
|
| My current web host supports MySQL and I have in fact setup a small
| test database. I curerntly have a fairly simple VB app (a couple of
| forms, a 3rd party activeX control, limited Access DB reads and
| writes). It would be very helpful if I could run this app from home
| or my office. (I work in a small office, rural location, limited
| internet options - using 1-way cable modem). At this point we don't
| really have the time or resources to operate our own web server
| (unless I can convince my boss that it is worth it). Is there a way I
| can connect my VB app to the MySql database running on my host, or can
| I create an activex control to run on the server?. (The host is Unix
| based, if that matters). I suspect the problem will be connecting to
| that MySQL database via the Internet. I have done some vb scripting,
| a couple of years ago, but nothing quite like this. And given my huge
| workload, I haven't found the time to find out if this is possible.
| Perhaps someone here knows a solution or can point me in the right
| direction. Thanks.
|
| Damon

What I think you need is a VPN connection (use the internet just like
a lan network connection.) Talk to your ISP about if this can be done
and the security implications (you could be opening your works'
network to hackers and all those unwelcomed 'visitors'.)

Converting your desktop app into a web based app is going to require a
lot of time, blood, sweat and tears :-(
---------------------------------------------------------------
jn****@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Damon]

Thanks for the input. I appreciate it. I will look into these things.
"swdev1" <ws**********@a dvmed.com> wrote in message news:<0W******* ********@newssv r24.news.prodig y.com>...

Damon -
yes - its very straightforward - get the odbc drivers for mySql , check with
your ISP to ensure that your mySql data can at least be viewed with a tool
like phpmySqlAdmin [its a rights issue here, basically] and
review this one:
http://fox.wikis.com/wc.dll?Wiki~VFPmySQLLinuxP1~VFP

its centric to VFP, but its very odbc and spt based - you should get the
right ideas from there, and shift to the concept of no need for Access at
all - just handle your data with ADO.

let me know if you get stumped, or need assistance .
----
some other thoughts -
ah - you basically wanna do client server with VB and mySql. There are
loads of white papers from MicroSoft on how to do this with VB and SQL - the
techniques are exactly the same - just a different back end in this case.

IF you can get to your data via odbc from any computer on the net - then you
don't need a VPN. If you cannot get to it - then you will need a VPN for
the odbc pipe that you will instantiate from the client side.

Don't bother 'running' your app on the unix machine at all. Run it on a
Wintel Box and have the back end hit the mysql server on the 'net.

hth - mondo regards [Will]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Damon" <da****@rcn.com > wrote in message
news:2a******** *************** ***@posting.goo gle.com...

I have been searching for post that matches my question and so far I
have not found one, which leads me to believe what I want to do iasn't
possible, but here I go...

My current web host supports MySQL and I have in fact setup a small
test database. I curerntly have a fairly simple VB app (a couple of
forms, a 3rd party activeX control, limited Access DB reads and
writes). It would be very helpful if I could run this app from home
or my office. (I work in a small office, rural location, limited
internet options - using 1-way cable modem). At this point we don't
really have the time or resources to operate our own web server
(unless I can convince my boss that it is worth it). Is there a way I
can connect my VB app to the MySql database running on my host, or can
I create an activex control to run on the server?. (The host is Unix
based, if that matters). I suspect the problem will be connecting to
that MySQL database via the Internet. I have done some vb scripting,
a couple of years ago, but nothing quite like this. And given my huge
workload, I haven't found the time to find out if this is possible.
Perhaps someone here knows a solution or can point me in the right
direction. Thanks.

Damon

[Damon]

Thanks for the input. I appreciate it. I will look into these things.
"swdev1" <ws**********@a dvmed.com> wrote in message news:<0W******* ********@newssv r24.news.prodig y.com>...

Damon -
yes - its very straightforward - get the odbc drivers for mySql , check with
your ISP to ensure that your mySql data can at least be viewed with a tool
like phpmySqlAdmin [its a rights issue here, basically] and
review this one:
http://fox.wikis.com/wc.dll?Wiki~VFPmySQLLinuxP1~VFP

its centric to VFP, but its very odbc and spt based - you should get the
right ideas from there, and shift to the concept of no need for Access at
all - just handle your data with ADO.

let me know if you get stumped, or need assistance .
----
some other thoughts -
ah - you basically wanna do client server with VB and mySql. There are
loads of white papers from MicroSoft on how to do this with VB and SQL - the
techniques are exactly the same - just a different back end in this case.

IF you can get to your data via odbc from any computer on the net - then you
don't need a VPN. If you cannot get to it - then you will need a VPN for
the odbc pipe that you will instantiate from the client side.

Don't bother 'running' your app on the unix machine at all. Run it on a
Wintel Box and have the back end hit the mysql server on the 'net.

hth - mondo regards [Will]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Damon" <da****@rcn.com > wrote in message
news:2a******** *************** ***@posting.goo gle.com...

I have been searching for post that matches my question and so far I
have not found one, which leads me to believe what I want to do iasn't
possible, but here I go...

My current web host supports MySQL and I have in fact setup a small
test database. I curerntly have a fairly simple VB app (a couple of
forms, a 3rd party activeX control, limited Access DB reads and
writes). It would be very helpful if I could run this app from home
or my office. (I work in a small office, rural location, limited
internet options - using 1-way cable modem). At this point we don't
really have the time or resources to operate our own web server
(unless I can convince my boss that it is worth it). Is there a way I
can connect my VB app to the MySql database running on my host, or can
I create an activex control to run on the server?. (The host is Unix
based, if that matters). I suspect the problem will be connecting to
that MySQL database via the Internet. I have done some vb scripting,
a couple of years ago, but nothing quite like this. And given my huge
workload, I haven't found the time to find out if this is possible.
Perhaps someone here knows a solution or can point me in the right
direction. Thanks.

Damon

[Damon]

Thanks for the input. I appreciate it. I will look into these things.
"swdev1" <ws**********@a dvmed.com> wrote in message news:<0W******* ********@newssv r24.news.prodig y.com>...

Damon -
yes - its very straightforward - get the odbc drivers for mySql , check with
your ISP to ensure that your mySql data can at least be viewed with a tool
like phpmySqlAdmin [its a rights issue here, basically] and
review this one:
http://fox.wikis.com/wc.dll?Wiki~VFPmySQLLinuxP1~VFP

its centric to VFP, but its very odbc and spt based - you should get the
right ideas from there, and shift to the concept of no need for Access at
all - just handle your data with ADO.

let me know if you get stumped, or need assistance .
----
some other thoughts -
ah - you basically wanna do client server with VB and mySql. There are
loads of white papers from MicroSoft on how to do this with VB and SQL - the
techniques are exactly the same - just a different back end in this case.

IF you can get to your data via odbc from any computer on the net - then you
don't need a VPN. If you cannot get to it - then you will need a VPN for
the odbc pipe that you will instantiate from the client side.

Don't bother 'running' your app on the unix machine at all. Run it on a
Wintel Box and have the back end hit the mysql server on the 'net.

hth - mondo regards [Will]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Damon" <da****@rcn.com > wrote in message
news:2a******** *************** ***@posting.goo gle.com...

I have been searching for post that matches my question and so far I
have not found one, which leads me to believe what I want to do iasn't
possible, but here I go...

My current web host supports MySQL and I have in fact setup a small
test database. I curerntly have a fairly simple VB app (a couple of
forms, a 3rd party activeX control, limited Access DB reads and
writes). It would be very helpful if I could run this app from home
or my office. (I work in a small office, rural location, limited
internet options - using 1-way cable modem). At this point we don't
really have the time or resources to operate our own web server
(unless I can convince my boss that it is worth it). Is there a way I
can connect my VB app to the MySql database running on my host, or can
I create an activex control to run on the server?. (The host is Unix
based, if that matters). I suspect the problem will be connecting to
that MySQL database via the Internet. I have done some vb scripting,
a couple of years ago, but nothing quite like this. And given my huge
workload, I haven't found the time to find out if this is possible.
Perhaps someone here knows a solution or can point me in the right
direction. Thanks.

Damon