Hello,
>>> I installed and configured MySQL on my server and also installed the MySQL ODBC driver (version 5.1). What the problem is now that I couldn't establish a connection, despite that I supplied all the parameters corectly. All I kept getting is "unable to establish a connection: access denied to user".
You should post the original code completely where you try to connect to database via odbc datasource.
>>> I couldn't locate the table I created in the oracle database, when I wanted to link tables in the MS Access.
Did you ever connect to ODBC-database from within MS Access? What version of Access are you using?
General: Maybe you haven't enough rights to connect to these databases, possibly owner of database tables is not the user who wants to use them and that user hasn't been granted to allow accessing those tables.
krs,
tesu
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.