Friday, February 24, 2006

st: Troubles with iODBC on Linux

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/


Tag:


Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?