[no subject]

All of the documentation I have on ODBC and MySQL uses that port. And 
specifying a database doesn't make any difference. It still says that 
root at localhost has not supplied a password.

>
> On Sat, 2004-10-02 at 13:39, Jim Philips wrote:
> > I am trying to get ODBC connections to MySQL working. I borrowed the
> > following odbc.ini from a tutorial on the Web:
> >
> > [ODBC Data Sources]
> >
> > myodbc3 = MySQL ODBC 3.51 Driver DSN
> >
> > [myodbc3]
> > Driver = /usr/local/lib/libmyodbc3.so
> > Setup = /usr/local/lib/libodbcmyS.so
> > Description = MySQL ODBC 3.51 Driver DSN
> > SERVER = localhost
> > PORT = 3306
> > USER = root
> > Password = my_password_here
> > Database =
> > OPTION = 3
> > SOCKET = /var/run/mysql/mysql.sock
> >
> > But when I run:
> >
> > isql -v myodbc3
> >
> > I get:
> >
> > [S1000][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user:
> > 'root at localhost' (Using password: NO)
> > [ISQL]ERROR: Could not SQLConnect
> >
> > Now I use the same password in some PHP pages and I can log in to MySQL
> > from the command line using the same password with no trouble. So, I can
> > only conclude the password isn't getting through to the login sequence.
> > Anybody have an idea why?
> >
> > _______________________________________________
> > Ale mailing list
> > Ale at ale.org
&gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt;
&gt; &gt; !DSPAM:415ee7dd309471619419946!


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00036" href="msg00036.html">[ale] odbc.ini trouble</a></strong>
<ul><li><em>From:</em> jimmyc at speedfactory.net (Jim Philips)</li></ul></li>
<li><strong><a name="00038" href="msg00038.html">[ale] odbc.ini trouble</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00038.html">[ale] odbc.ini trouble</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00040.html">[ale] Keyboard lockups</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00038.html">[ale] odbc.ini trouble</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00037.html">[ale] Untar a bunch of .tar.gz and .tgz files</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00039"><strong>Date</strong></a></li>
<li><a href="threads.html#00039"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>