Hi,
i am a newbie in linux.
do anyone know how to set MySQL or server comp so I can connect into the database in my server from another comp by using ADO ?
Hope you understand what i mean :|
thx

Don't know what ADO is. I use MySQL with PHP. If you just need to insert and view data then this is a good way to go.

ADO is Microsofts Db connectioni libraries, right? Well then, what language are you using VB, C#, C/C++, etc...

-Leif

sorry,
i store my database in MySQL using in my redhat 8 computer, and i want to access it through another computer which using winxp. I tried to read my database using ms access, and i already install MyODBC 2.50 in winxp computer, but i still cannot connect to my database in MySQL, it said :

ODBC --call failed.
[TCX][MyODBC]Lost connection to MySQL server during query (#2013)

i also confused what do i need to fill in for windows DSN name.

addition:
is there anything that i need to setup in my redhat computer as well?

Download the windows mysqlgui from mysql.com

You'll be up and running in minutes.

For the DSN you should probably consult the MySQL docs. I am sure that the proper parameters are there. It appears you are not using ADO at all, more likely MDAC which is the microsoft data access libraries for clients, these are installed by default plus there are updates available from MS. ADO is a programming library for activeX data objects.

Try
http://www.mysql.com/documentation/mysql/bychapter/

using chapter 8.3

You should not have to do anything to the db server assuming it was set up properly and is up and running, and there is no networking problems hardwar and software oriented between your computers...

-Leif

leifton:
i think i miss something in setting up for my redhat computer. If it possible, can you tell me what do i need to setup in my redhat?
i can ping from my xp computer to my redhat computer, and connect via ssh (telnet and ftp cannot). and I already start mysqld service, and also do this:
mysql>grant all privileges on *.* to user@'%';

post the contents of your ODBC.INI on your XP box. Make sure the ip address or DNS (NOT DSN) match your linux box, make sure the user exists in MySQL and also post the actual commands and output from your atttempt(s) to connect.

here is the content of odbc.ini in my xp box:
[ODBC 32 bit Data Sources]
ECDCMusic=Microsoft Access Driver (*.mdb) (32 bit)
MS Access Database=Microsoft Access Driver (*.mdb) (32 bit)
Excel Files=Microsoft Excel Driver (*.xls) (32 bit)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 bit)
Visual FoxPro Tables=Microsoft Visual FoxPro Driver (32 bit)
Visual FoxPro Database=Microsoft Visual FoxPro Driver (32 bit)
sample-MySQL=MySQL (32 bit)
test=MySQL (32 bit)
[ECDCMusic]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[MS Access Database]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[Excel Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[dBASE Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[Visual FoxPro Tables]
Driver32=C:\WINDOWS\System32\vfpodbc.dll
[Visual FoxPro Database]
Driver32=C:\WINDOWS\System32\vfpodbc.dll
[sample-MySQL]
Driver32=C:\WINDOWS\System32\myodbc.dll
[test]
Driver32=C:\WINDOWS\System32\myodbc.dll

the ip address for my xp box is 192.168.0.34/255.255.255.224
the gateway and DNS server address is : 192.168.0.33
the ip address for my redhatbox is 192.168.0.33/255.255.255.224
with no gateway and no DNS server address.

mysql>grant all privileges on *.* to user@'%';

mysql> select * from mysql.user where User = 'user';
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
----------------------------------------------------------------------------------
| % | user | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y |

from ODBC User Data Source:
windows DSN name : test
MySQL host (name or ip) : 192.168.0.33
MySQL database name : user
the rest is empty.

Try deleting your 'sample-MySQL' and 'test' entries. Next, create a new 'system' dsn and make sure to fill in server, user, passwd and port fields.

Try that out before pursuing another approach.

(If you do not feel I am understanding your problem, or if you have found any other pertinent information, let me know)

Right now, I just think that your dsn is not set up correctly. The MyODBC docs say to leave some information out. I am not sure that is the best thing for now. Try to leave all information in the dsn profile.

By 'system' I did not mean that to be the name of the profile, but the type of dsn, sorry for the confusion...

leifton,
I remove all data source which are sample-MySQL and test.
After that I create data source in System DSN and the entries:
windows DSN name : test
MySQL host (name or ip) : 192.168.0.33
MySQL database name : test
user: user
Password:
Port : 3306
SQL command on connect:

test database already available from the first time, and my user login "user" is created with no password like i said i create it with grant all privilages with no identified.
but still there is no sign of connection because when i import external data in msaccess, it said Lost connection to MySQL server during query.
i really have no idea what wrong.
i also enable the telnet and ftp in my redhat box, and i can access it from my xp box.
hope you can help me.

Dudes,
now i get the answer of my probz. I think it is better if i post the answer, and if somebody found same problem with mine, you can resolve it.
Red Hat Linux 8.0 provide MySQL in its installation. And the problem is, the MySQL itself is not compatible with glibc that provided in the OS, i dont know latest gilbc can solve it, but by installing the latest MySQL server RPM in www.mysql.com can overcome the problem. If the the software can't installed in Red Hat, then try type this:
Shell>rpm -i MySQL.rpm --force --nodeps
after that, try to stop and start again mysqld by do this :
Shell>/etc/rc.d/init.d/mysqld stop
Shell>/etc/rc.d/init.d/mysqld start

there is another way to solve it (i guess), but i use this way and i can overcome the problem.

Thanks leifton for your help to me ^_^

Wow, glad to hear you solved your problem. Good thing we did not pursue that avenue any further...

Leifton