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.
Cheers
Caveman
On Fri, 2006-02-24 at 11:05 -0600, Kevin Turner wrote:
> Orvalho Joaquim Augusto ([email protected]) 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 protected]
>
>
>
> 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/
