Wednesday, March 01, 2006
Re: st: Re: Troubles with iODBC on Linux
It works for remote connection now! I just update to new iODBC (3.52.4). Keep MyODBC 2.5. And remove the line socket on a remote connection.
On Fri, 2006-02-24 at 11:05 -0600, Kevin Turner wrote: > Orvalho Joaquim Augusto (firstname.lastname@example.org) writes: > > >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); > ' > I hesitate to weigh in on this because both of these issues are iODBC/MySQL > configuration issues, not Stata issues. > > With regards to issue 1, the use of automatic passwords via an iODBC odbc.ini > file on Linux is known to work. Admittedly, this has been tested using a > Postgres database, but the database-independent nature of ODBC suggests this is > a configuration issue between iODBC and the MySQL ODBC driver parameters. Your > parameter keywords in the odbc.ini look valid, but I would double check them to > make sure they are not case sensitive, etc. I believe that iODBC simply > assembles the keyword/value pairs in the odbc.ini file and passes them to the > driver. If the driver doesn't like them, it has the option of ignoring them. > > Concerning issue 2, I have even less to offer. It is possible to connect to > remote servers via iODBC in Stata, so there is hope. I've never seen your > particular error before you posted it, but a quick Google of the error message > returned plenty of hits from the MySQL message boards. Try to follow up on it > there. See: http://groups.google.com/ > > --Kevin > email@example.com > > > > Sincerely, > > Kevin Turner > * > * 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/
* * 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: