MySQL on Win 98

From: Seldom Scene (balderdash_at_spongemop.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 03:52:41 GMT

Hi folks.

I'm just getting into MySQL and I'm trying to learn about it at home.
Because I'm at home I've only got a Win 98 SE machine and VFP 7 SP 1at
my disposal.

I've downloaded and successfully installed MySQL 4.1.9 on this
machine. I can run the command line client and work through the
tutorial steps with no problem.

I've also successfully installed the MySQL ODBC driver version 3.51
and created a DSN connection for it. The connection looks like this:

Data Source Name: TestMySQL
Description:
Server: localhost
User: root
Password:
Database: test
 
All of the other options are at their default values.

I can start the mysqld.exe program and test this connection in the
ODBC Data Source Administrator and get a "success" result.

However, I cannot get VFP 7 SP 1 to connect to MySQL using the ODBC
drivers no matter what I do.

With mysqld.exe running, I've tried using the following connection
string that I modified from the one posted on the Wiki:

lcServer="localhost"
lcDatabase="test"
lcUser = "root"
lcPassword = "root"

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 last nocaptions
   SQLDISCONNECT(lnHandle)
ELSE
   =AERROR(laError)
   MESSAGEBOX("Error at Connecting"+CHR(13)+;
              "Description:"+laError[2])
ENDIF

As written, this string returns lnHandle = -1 with an error message
saying that access was denied for "user 'root'@'localhost' (using
password: YES)". This is expected because on Win 98 MySQL is installed
by default with no password for root.

However, if I modify the string to reflect what I expect to work; that
is, if I set lcPassword = "" (or lcPassword = " "), I get a C5 crash
on the SQLSTRINGCONNECT(...) line. I've also tried creating a
connection in the Connection Designer. All I did was bring up the
Connection Designer, select my DSN from the dropdown (TestMySQL), and
click "Verify Connection". This also creates a C5 crash.

I've tried other things:

Using lcStringConn = "DSN={TestMySql}" produced the error: "Data
source name not found and no default driver specified."

Using lcStringConn = "DSN=TestMySql" produces a C5 crash.

Using lcStringConn = "DSN=TestMySql;Uid=root;Pwd=" produces a C5
crash.

I've tried leaving the Database parameter blank. This has no effect,
and I've verified that the test Database does exist.

I've tried following the instructions to change the password for root.
This did not appear to work at all. That is, I couldn't get into the
command line client with my new password; the only way it would let me
in was to use a blank password. And supplying my new root password in
the connection string produced an "access denied" error indicating the
password was wrong.

So it seems to me that the problem boils down to one of two things:
either I need to run some kind of mysqladmin configuration commands to
make the mysqld.exe process responsive to ODBC connections (perhaps
something that would change "YES" to "NO" in the "using password"
phrase?), or the combination of MySQL, its 3.51 ODBC driver, Win 98
SE, and VFP 7 SP 1 simply will not work together. I don't think the
first possibility can be correct because the DSN connection does
indeed test as working in the ODBC Administrator. I fear the second
hypothesis is the correct one.

But I thought I'd ask whether anyone has had a similar experience or
has a definitive answer.

TIA.

Ken Dibble

Relevant Pages

  • Re: Local Access database to shared PHP/MySql hosting export
    ... The client has an ADSL connection. ... Long ago I was shown how Excel could query data from a mysql ... database _on Linux_ using ODBC. ... access the linux mysql server, and then use that connection to allow MS ...
    (comp.lang.php)
  • Re: Local Access database to shared PHP/MySql hosting export
    ... ODBC connection. ... ODBC to the MySQL Server. ...
    (comp.lang.php)
  • Re: VFP8 and MySQL
    ... I have partly solved the connection problem by doing the following:- ... error but got the ball rolling (and a hint that I needed a user named ODBC) ... Setting up a MySQL user called ODBC with no password ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VB und MySQL - rs.Update geht nicht
    ... Mein Programm nutzt eine MySql ... > Datenbank im Hintergrund. ... Ado Connection ... > läuft über die ODBC System DSN. ...
    (microsoft.public.de.vb.datenbank)
  • Re: MySQL on Win 98
    ... Open the DSN and check the connectionstring ... > I'm just getting into MySQL and I'm trying to learn about it at home. ... > and created a DSN connection for it. ... > by default with no password for root. ...
    (microsoft.public.fox.programmer.exchange)