Wednesday, February 22, 2006
st: Troubles with odbc on Linux
I am using Stata 9 (updated 20 Jan) on Ubuntu (linux) and Fedora Core 4. 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/
Links to this post: