[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: re[2]: MyODBC and MSAccess (user name-only 16 characters long?)
From:       "Clay Daniels" <clay_1 () airmail ! net>
Date:       2001-02-23 5:12:24
[Download RAW message or body]

The user and password for odbc drivers are in c:\windows\ user.dat &
system.dat, i.e. the windows 'Registry'

HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\"your system dsn"

Start|Run|regedit and do a 'find'

You might set up a dummy user with less than 16 characters, then use regedit
to change it to the user name you need. I don't recommend regedit for casual
windows computer users. If you are uncomfortable editing the registry, DON'T
!!!

good luck
----- Original Message -----
From: "Frank Calabretta" <Frankc@netkinetic.com>
To: <paul@gi.alaska.edu>
Cc: <myodbc@lists.mysql.com>
Sent: Thursday, February 22, 2001 4:37 PM
Subject: re[2]: MyODBC and MSAccess (user name-only 16 characters long?)


Hey Paul...

I can't create another user to access the mysql database...the database is
hosted by a third party and they are only allowing us access through a 17
character user name. I am using the windows odbc manager to configure the
odbc driver.

The ODBC configuration screen has a field that gives you the option to
"enter a SQL command on connect"
Could that help?

Any other ideas?

Thanks,
Frank


> Can you create a new MySQL user to allow access to the database?

grant all on mydb.* to shortname@'%.company.com' identified by 'x';

with appropriate substitutions. The mysql username isn't (normally)
dependent on /etc/passwd or Windows usernames.

Paul

On 22 Feb 2001, at 10:06, Frank Calabretta wrote:

>
> Hello...I hoping someone could help me.
>
> I am trying to connect to a MYSQL database through MSAccess using Myodbc.
>
> Problem:
> When I try to configure the ODBC driver through the TDX
> configuration screen (Windows ODBC Manager).....It won't allow me
> to enter a user name that is more than 16 characters long.
>
> Unfortunately, I can't shorten the user name....is their anyway
> around the 16 character limitation ? I am using the latest Myodc
> driver 2.50.36




<

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread2868@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.



---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread2869@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]