Hello

I have answered this in VFPMySQL group. Please read your mail.

Hope this helps.

>Hi there!
>
>I'm using now old Visual FoxPro 6 with .dbc and .dbf tables. Due to the demands for huge database I choose MySQL on the Win XP Pro. Problem is that I'm able to connect to the database on local computer with this programs section:
>lcServer="localhost" &&if here is IP address of localhost e.g.192.168.0.88 won't work!
>lcDatabase="stores"
>lcUser = "root"
>lcPassword = "iamroot"
>lcStringConn="Driver={MySQL ODBC 3.51 Driver};Port=3306"+;
> ";Server="+lcServer+;
> ";Database="+lcDatabase+;
> ";Uid="+lcUser+;
> ";Pwd="+lcPassWord
>*** Don't prompt for login
>SQLSETPROP(0,"DispLogin",3)
>lnHandle=SQLSTRINGCONNECT(lcStringConn)
>IF lnHandle > 0
> ? SQLTABLES(lnHandle,"TABLES")
> BROWSE
> SQLDISCONNECT(lnHandle)
>ELSE
> =AERROR(laError)
> MESSAGEBOX("Error at Connecting"+CHR(13)+;
> "Description:"+laError[2])
>ENDIF
>
>Error at connecting: Description: Connectivity error: [MySQL][ODBC 3.51 Driver] Access denied for user 'root'@'MYPC' (using password: YES)
>
>but connection is unable to comply when I put IP address (like 192.168.0.88) of mentioned PC instead keyword "localhost" or "127.0.0.1"!? How to set up the connection in order to work it? How to write problematic programs section of connection on client apps in order that is able from each workstation under Win98 or XP to connect to the MySQL database? I tried many times different manners but without success. ODBC driver is last downloaded version 3.51.11-2 and MySQL database is: Version 14.7 Distrib 4.1.7 for Win 95/98 (i32). On this XP I have already user account called also "root" with same password in order to avoid this error but nothing helps!
>I have another PC under Linux, where is possible to install MySQL but I'm not familiar with such kind of connection (client application developed using VFP6 and database under Linux). Any help? I really appreciate any kind of the help about it.