Re: Witango-Talk: ODBC Linux Help

[Rick Sanders]

Hey Robert,   Thanks for the help!   I've tried using a different user by specifying the user in the ODBC.ini but it keeps defaulting to the root user!   Here's my odbc.ini which is in the /usr/local/tango/etc   [ODBC Datasources] bloks=MySQL Database   [bloks] Description = bloks database Driver = /usr/local/lib/libmyodbc-2.5-2.50.38.so DSN = bloks ServerName = bloks (Also tried localhost) Trace = No user = root (Also tried other users) password = bloks port = 3306 host = bloks (Also tried localhost) database bloks   Thanks in advance!   Rick   Actually it looks like you're making a connection ot the DB just fine, but the problem is that you're trying to access the DB as root and the root user of MySQL has a password set, and that's why you're getting rejected. 2 things: 1- use the root password 2- use a different user with the proper password (DO THIS NOT THE OTHER IF YOU CAN) R On Saturday, August 17, 2002, at 01:54 PM, Rick Sanders wrote: Hey List,   I've installed WiTango successfully on Linux. Tafs run fine. However, when I try to run a taf connecting to a MYSQL DSN, I get:   [TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: NO) S1000   If anyone could help me with proper ODBC.ini and permission settings, I would greatly appreciate it!   Thanks in advance.   Rick Sanders President, Web Energy Tel: (514) 620-3006 Fax: (514) 620-3017 Web: www.webenergy-sw.com