Martin,
Thursday, February 14, 2002, 7:42:43 AM, you wrote:
MJ> You need to set access privileges for SQL server. try with this :
MJ> GRANT ALL PRIVILEGES ON database.tables TO [EMAIL PROTECTED] \g
MJ> flush privileges \g
Martin, you are right, but i want to add that there is no need to run
"mysqladmin reload" or "FLUSH PRIVILEGES" if you use GRANT.
MJ> mySQL prompt.
MJ> Try also to delete password from DNS on client machine.
MJ> (I'm maybe make a syntax error, look in mySQL manual for details).
You can see info about GRANT in the manual:
http://www.mysql.com/doc/G/R/GRANT.html
MJ> -----Original Message-----
MJ> From: Otto Saayman [mailto:[EMAIL PROTECTED]]
MJ> Sent: Wednesday, February 13, 2002 9:32 PM
MJ> To: [EMAIL PROTECTED]
MJ> Subject: W2K Network
MJ> Hi there
MJ> I have an Internal Network running MySQL with all machines running W2K. One
MJ> of them has a VB Application which uses MyODBC to connect to another server
MJ> running MySQL. The VB produces this error:
MJ> Access Denied for username@vbappmachinename ... Using Password YES ...
MJ> ODBC is set up with IP Address, port, username, password and as a System
MJ> Data Source.
MJ> No Machine Name.
MJ> The VB App uses the System DS Name.
MJ> This setup works fine if the VB App and MySQL server reside on the same
MJ> machine. How do I get the other machine to work in the same way?
MJ> Thank you
MJ> Otto
MJ> [EMAIL PROTECTED]
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
