Wednesday, March 01, 2006

Re: st: Re: Troubles with iODBC on Linux

Thank you Kevin for your answer I was out so I could not give a feedback. I am updating iODBC to 3.52.4 release. I will be testing then I will say something

Cheers Caveman

I was out I will do as you se On Fri, 2006-02-24 at 11:05 -0600, Kevin Turner wrote: > Orvalho Joaquim Augusto (orvalho@health.uem.mz) 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 > kturner@stata.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/


Tag:


Links to this post:

Create a Link



<< Home

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