|
Home > Archive > dBASE Web Applications > June 2005 > dBASE PLUS/ mySQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Frank J. Polan 2005-06-11, 8:23 pm |
| I have access to a mySQL server running on my virtual hosted site by
using PHP
I can access a mySQL server on my lan with dBASE by creating an
alias/system dsn, using the host PC's IP address
Is it possible to access the hosted mySQL server the same way?
Thanks
Frank Polan
| |
| David Ball 2005-06-12, 9:23 am |
| Hello Frank
> Is it possible to access the hosted mySQL server the same way?
Yes, as long as your host hasn't put up any roadblocks. (I don't see why
they would, but you never know.) In the ODBC Administrator/System DSN, (I'm
using the mySQL 3.51 Driver) enter the hosted server IP address or host
name, name, password, etc, If you are talking to the server with php, you
should have all the connection data already. There's a "Test Data Source"
button at the bottom to see if it works.
Thank you
David Ball
www.ChelseaData.ca
| |
| Frank J. Polan 2005-06-12, 11:23 am |
| David,
I'm using the mySQL 3.51 Driver too. I tried those settings but I'm
getting as error messages.
The ISP I use for web access (Northwestel) isn't the one that's
hosting my web site & mySQL server (magma). Could that be the problem?
The error messages seem to indicate it's looking for the mySQL server
on the Northwsestel site
Thanks
Frank Polan
On Sun, 12 Jun 2005 09:25:40 -0400, "David Ball"
<Thanks.But@NoSpam.4.me> wrote:
>
>Hello Frank
>
>
>Yes, as long as your host hasn't put up any roadblocks. (I don't see why
>they would, but you never know.) In the ODBC Administrator/System DSN, (I'm
>using the mySQL 3.51 Driver) enter the hosted server IP address or host
>name, name, password, etc, If you are talking to the server with php, you
>should have all the connection data already. There's a "Test Data Source"
>button at the bottom to see if it works.
>
>Thank you
>David Ball
>www.ChelseaData.ca
>
>
| |
| David Ball 2005-06-12, 11:23 am |
| Hi Frank
Under mySQL Connection Parameters, what are you using for the host/server
name(or IP)?
If it's an IP address, check that it resolves to a magma name
(mysql.magma.ca or something similar) or just enter the name instead. Magma,
bless their hearts, have pretty good phone support so you could always give
them a call (or email). From their website, I found this in the FAQ
regarding mySQL setup:
Step 1: Contact Magma
Before you can use the mysql server, we need to configure it so that it can
access your database. Please send email to vwssupport@magma.ca asking us to
configure the mysql server for your Virtual Web Server.
Note that you do not have access to create your own database. (you can
create as many tables as you want within the database though)
Thanks
David
"Frank J. Polan" <fpolan@pcassist.on.ca> wrote in message
news:biooa1tgjom39up
d37q4qbr7ecu0stvg4o@
4ax.com...
> David,
>
> I'm using the mySQL 3.51 Driver too. I tried those settings but I'm
> getting as error messages.
>
> The ISP I use for web access (Northwestel) isn't the one that's
> hosting my web site & mySQL server (magma). Could that be the problem?
> The error messages seem to indicate it's looking for the mySQL server
> on the Northwsestel site
>
> Thanks
>
> Frank Polan
>
> On Sun, 12 Jun 2005 09:25:40 -0400, "David Ball"
> <Thanks.But@NoSpam.4.me> wrote:
>
(I'm[color=darkred]
>
>
| |
| Frank J. Polan 2005-06-12, 1:23 pm |
| David,
Yes, I have done that and can connect, and access my database no
problem using a web page/PHP
It's only trying to connect from the BDE/ODBC that I'm having
problems.
You're right, their tech support has been pretty good. I'll guess
I'll phone them now. They shouldn't be too busy on a Sunday<g>
Thanks
Frank Polan
On Sun, 12 Jun 2005 12:50:32 -0400, "David Ball"
<Thanks.But@NoSpam.4.me> wrote:
>
>Hi Frank
>
>Under mySQL Connection Parameters, what are you using for the host/server
>name(or IP)?
>
>If it's an IP address, check that it resolves to a magma name
>(mysql.magma.ca or something similar) or just enter the name instead. Magma,
>bless their hearts, have pretty good phone support so you could always give
>them a call (or email). From their website, I found this in the FAQ
>regarding mySQL setup:
>
>Step 1: Contact Magma
>Before you can use the mysql server, we need to configure it so that it can
>access your database. Please send email to vwssupport@magma.ca asking us to
>configure the mysql server for your Virtual Web Server.
>
>Note that you do not have access to create your own database. (you can
>create as many tables as you want within the database though)
>
>Thanks
>David
>
>"Frank J. Polan" <fpolan@pcassist.on.ca> wrote in message
> news:biooa1tgjom39up
d37q4qbr7ecu0stvg4o@
4ax.com...
>(I'm
>
>
| |
| David Ball 2005-06-12, 1:23 pm |
| Hi Frank
> It's only trying to connect from the BDE/ODBC that I'm having
> problems.
I created a new BDE alias just to try to jog my memory for any "gotcha"s,
but it worked fine with only the ODBC alias and database name. Then I saved
it (right click, apply) and then pressed the + button and got the
name/password box. Pressed okay and got the green square of relief.<g>
> You're right, their tech support has been pretty good. I'll guess
> I'll phone them now. They shouldn't be too busy on a Sunday<g>
That's prime time for all their residential customers!
Good luck
David Ball
www.adojji.org
| |
| Frank J. Polan 2005-06-14, 9:23 am |
| David,
I got a reply from magma tech support. Apparently the server I'm on
(it's from one of the companies they bought) doesn't support external
access through ODBC
Frank Polan
On Sun, 12 Jun 2005 13:29:08 -0400, "David Ball"
<Thanks.But@NoSpam.4.me> wrote:
>
>Hi Frank
>
>
>I created a new BDE alias just to try to jog my memory for any "gotcha"s,
>but it worked fine with only the ODBC alias and database name. Then I saved
>it (right click, apply) and then pressed the + button and got the
>name/password box. Pressed okay and got the green square of relief.<g>
>
>
>That's prime time for all their residential customers!
>
>Good luck
>David Ball
>www.adojji.org
>
>
| |
| David Ball 2005-06-14, 8:23 pm |
| Hi Frank
Do their "native" mySQL servers allow external mySQL ODBC?
If so, I would raise a stink about it and/or get them to move you to a
server that does have external ODBC connectivity. It's not your fault which
server you're on, unless you were originally with the company that got
bought. Even then, you should have some leverage as a "new" Magma client.
Lots of other companies out there with external mySQL ODBC.
<shameless plug>
including ChelseaData.ca
</shameless plug>
Good luck
David Ball
www.ChelseaData.ca
"Frank J. Polan" <fpolan@pcassist.on.ca> wrote in message
news:0kpta1hhb2ha7qq
fqfd7kfa7r2q5t4okq3@
4ax.com...
> David,
>
> I got a reply from magma tech support. Apparently the server I'm on
> (it's from one of the companies they bought) doesn't support external
> access through ODBC
>
> Frank Polan
>
> On Sun, 12 Jun 2005 13:29:08 -0400, "David Ball"
> <Thanks.But@NoSpam.4.me> wrote:
>
saved[color=darkred]
>
>
| |
| Frank J. Polan 2005-06-14, 8:23 pm |
| David,
I'll have to check about their native server access. Unfortunately the
original ISP I was with was bought, then they were bought by magma.
There have been a few problems along the way
I'll think I'll take a look at the </shameless plug> site<g>
Thanks
Frank Polan
On Tue, 14 Jun 2005 17:59:01 -0400, "David Ball"
<Thanks.But@NoSpam.4.me> wrote:
>
>Hi Frank
>
>Do their "native" mySQL servers allow external mySQL ODBC?
>
>If so, I would raise a stink about it and/or get them to move you to a
>server that does have external ODBC connectivity. It's not your fault which
>server you're on, unless you were originally with the company that got
>bought. Even then, you should have some leverage as a "new" Magma client.
>
>Lots of other companies out there with external mySQL ODBC.
><shameless plug>
>including ChelseaData.ca
>
>
>Good luck
>David Ball
>www.ChelseaData.ca
>
>
>
>"Frank J. Polan" <fpolan@pcassist.on.ca> wrote in message
> news:0kpta1hhb2ha7qq
fqfd7kfa7r2q5t4okq3@
4ax.com...
>saved
>
>
| |
| David Ball 2005-06-14, 8:23 pm |
| > I'll think I'll take a look at the </shameless plug> site<g>
Thanks.
There's not much mySQL information on the site; let me know if you have any
specific questions.
Thank you
David Ball
www.ChelseaData.ca
|
|
|
|
|