Linux/Windows MySQL connection

[geckopsx]

I've been browsing almost all of the questions but none can answer mine. I can say that I'm new to the MySQL "world". I'm trying to make windows to connect to MySQL (Linux). So far I've seen that the only solution would be to use a ODBC driver. I was expecting something more "direct" like a MySQL client, or TCP/IP connection.
I'm a developer that uses Delphi mainly, and MS Access. I would really appreciate ii someone can help me to find a way to connect to MySQL(Linux) from Windows.

Thanks a bunch!

 

[sleipnir214]

ODBC (or ADO) is the only way I know of to connect Mi¢ro$oft's applications to MySQL. I don't see why you would expect otherwise -- even if you are connecting to SQL Server from a Win32 box, you're going to use ODBC.

If you are looking for a tool to manage MySQL from a Win32 box, I can recomment MySQLFront, available at

http://mysqlfront.sstienemann.de/

______________________________________________________________________
TANSTAAFL!

 

[geckopsx]

Thank's for your reply sleipnir214! Basically I'm trying to do both, manage and use MySQL from Win32. I already downloaded MyODBC v2.5, but it couldn't install on my win98 machine, I got and error when the setup program tryied to copy the ctl3d32.dll file.
Also, I downloaded MySQL-Front, but I keep getting the '1130-host 'xxxx' is not allowed to connect to this MySQL server'. How can I fix that?
By the way, do you know how can I use BDE (Borland Database Engine) to make a connection to the database on Linux so I can use the it on my Delphi program?
Thank you again.
GeckoPSX

 

[sleipnir214]

Sorry, I've never used Delphi with MySQL.

The error you're getting ('...not allowed to connect...') may be due to userid limitations. Does your userid have permission to login from your Win98 machine's IP address?

MySQL users are not only given permission to access a database or table or table column. They are given permission to access any of these from a particular IP address or set of IP addresses. ______________________________________________________________________
TANSTAAFL!

 

[geckopsx]

Thank you, I fixed it and works fine now.