st: Troubles with iODBC on Linux

[Orvalho Joaquim Augusto <orvalho@health.uem.mz>]

I am using Stata 9 (updated 20 Jan) on Ubuntu and Fedora Core 4 (Linux 
distributions).
I have installed iodbc version 3.52.3 on both distributions. I have
configured /etc/odbc.ini like:

; begin odbc.ini
[ODBC Data Sources]
bercario = MySQL ODBC 2.50 Driver DSN

[bercario]
Driver = /usr/local/lib/libmyodbc.so
Description = MySQL ODBC 2.50 Driver DSN
Server = localhost
PORT = 3306
SOCKET = /var/lib/mysql/mysql.sock
User = work
Password = 
Database = test
ReadOnly = no
ServerType = MySQL
FetchBufferSize = 99
ServerOptions =
ConnectOptions =
OPTION = 3
TraceFile = /var/log/mysql_test_trace.log
Trace = 0

[helico]
Driver = /usr/local/lib/libmyodbc-2.50.38.so
Description = MySQL ODBC 2.50 Driver DSN
Server = 192.168.10.70
PORT = 3306

[Default]
Driver = /usr/local/lib/libmyodbc-2.50.38.so
Description = MySQL ODBC 2.50 Driver DSN
Server = localhost
Port = 3306
UserName = work
Password = 
Socket = /mnt/fedroot/var/lib/mysql/mysql.sock
;end odbc.ini 

I have installed MyOBCS ver 2.5

1. When I use any odbc command to connect to a localhost database on
mysql
I have to pass arguments like user and password even I put them on
/etc/odbc.ini. And the database name should be equals to dsn!
How can solve that?

2. I can not connect to a remote database: it gives 
[TCX][MyODBC]Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
r(682);

It should not use a socket here. How can I solve this?

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/