how to direct access internet's mysql from vfp9 ?

[darren5559 via DBMonster.com]

hi,

i have a ONLINE website contains 2 databases in the mysql. one database
called 'information_schema' which was created by mysql, and another database
called 'infodata' which created by me.

i use visual foxpro to write a program to access the ONLINE database, the
database show ok when i use SQLSTRINGCONNECT command to access the
'information_schema' database, but the database show error when i use
SQLSTRINGCONNECT to access 'infodata' database, may i know what is wrong with
database ? how to ratify this problem ?

pls help me. thanks !!!

--
Message posted via http://www.dbmonster.com

[Bernhard Sander]

Hi darren5559,

> i have a ONLINE website contains 2 databases in the mysql. one database
> called 'information_schema' which was created by mysql, and another database
> called 'infodata' which created by me.
>
> i use visual foxpro to write a program to access the ONLINE database, the
> database show ok when i use SQLSTRINGCONNECT command to access the
> 'information_schema' database, but the database show error when i use
> SQLSTRINGCONNECT to access 'infodata' database, may i know what is wrong with
> database ? how to ratify this problem ?

You may check access rights in mySQL of your databases and tables.
You also may check aError() after your SQLStringConnect fails.

Regards
Bernhard Sander

[swdev2]

yup - i do it all the time with shared services linux servers.
vfp->odbc across the internet->mysql instance

the odbc portion for vfp is straightforward.

what's NOT straightforward is 'client access ' parameters at the host, or
hosting company.
you'll need to allow access (by and to your desktop machine) at some control
panel
on the linux host, PER DATABASE INSTANCE.. IE - do it twice for
'information_schema' and 'infodata' , both.

allowing for :
1. ip address or qualified machine name
2. a user name
3. a password.

Once you get it properly configured, you still might have access problems if
your ip address or qualified machine name CHANGES, as then you'll have to
reconfigure at the linux host.

Good Luck !
--

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"darren5559 via DBMonster.com" <u38358@uwe> wrote in message
news:93c9e24c92647@uwe...