General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP6 and MySQL connection problems
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only