I get two info boxes.
The first says "ODBC-call failed"
The second says "[TCX][MyODBC]Access denied for
user: '@dhcp85.lannet.com.au' to database 'Treasury' (#1044)"
In the TDX mysql Driver default configuration dialog box from Control
Panel->ODBC Data Source (32bit) the user name is set as LANNet, and that
user name is valid for connection to that database from a remote host as I
have tested it with the mysql command line.
I do not use a password.
I don't follow what you mean by "...so, when I connect from within the
database, I supply a username and password." How?
--
Howard. LANNet Computing Associates <http://lannetlinux.com>
_____________________________________________________________
"We needn't, as socialists, get too concerned about privacy;
it's a bourgeois right, closely allied to the right to private property".
- Former Federal Health Minister Neal Blewett,
addressing the Fabian Society in 1988 in relation to the Australia Card issue.
On Wed, 20 Jun 2001, Joshua J. Kugler wrote:
> You say it's not sending the user name. What connect string are you using?
> Does it include the user name? Can you post the exact connect string you are
> using when you connect to the database?
>
> As I have it set up on my windows side of things: the DSN in the ODBC setup
> has no username or password, so, when I connect from within the database, I
> supply a username and password. How is your configuration set up?
>
> j----- k-----
>
> On Wednesday 20 June 2001 00:01, Howard Lowndes wrote:
> > I have a situation where the error I am getting in MS Access indicates
> > that the user name that I have set up in the OBC driver is not being sent
> > to MySQL.
> >
> > The irony is that when I set the ODBC driver up initially, it worked, but
> > then after closing MSA and restarting it the damned thing failed to work.
> >
> > I have tried reinstalling the ODBC driver, but without success.
> >
> > I have an option in MySQL to allow access frpm any host without a user
> > name so I am thoroughly confused.
> >
> > The version of MyODBC is the latest.
> >
> > Any ideas?
>
>
---------------------------------------------------------------------
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
