)-----Original Message-----
)From: Roland Thompson [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 3:38 AM
)To: [EMAIL PROTECTED]
)Subject: Can't connect to source
)
)
)Hi,
)
)I’ve just started playing about with MySQL. I created a database called
)‘haworth’, no problem there, then created a table called ‘list’.
)I put 3 entries in it, and checked it using
)
)SELECT * FROM list;
)
)It showed all the records fine. The MySQL server is running on NT,
)and I can
)connect remotely by using the following statement.
)
)Mysql –h x –u root –p
)
)X being the IP address of my server. This works fine on any
)computer I tried
)it on.
)I then installed MyODBC on a Win2000 computer. All went well, then I setup
)the link to the database.
)
)But when I tried to access it, I got the following message.
)
)UNABLE TO CONNECT TO SOURCE “MYTEST” – “S1000” –“[TCX][MyODBC]
)Access Denied
)for user: ‘@MAILSERVER’ To database ‘roland’” – 00000414
)
)I then reset the link to the test database, and tried again, this worked
)fine.
)Do I need to setup something else on the server so I can access the
)database?
)
)Some help would be appreciated, as I’m about to throw the computer out of
)the window!!!
Check the following link for the work-around:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:84548:200109:dgfijpnafhemmgcge
cnk
Regards, venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Woodside, California USA
<___
---------------------------------------------------------------------
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