MySQLTalk.org Forum Index MySQLTalk.org
MYSQL discussions groups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Re: [iHTML] Problem using unixODBC and MyODBC

 
Post new topic   Reply to topic    MySQLTalk.org Forum Index -> MySQL ODBC
View previous topic :: View next topic  
Author Message
Guest






PostPosted: Mon Jul 12, 1999 2:28 pm    Post subject: Re: [iHTML] Problem using unixODBC and MyODBC Reply with quote



Here's a copy of a post from the iHTML list. It may provide a clue for you:

~FINALLY! It works!
~
~Here's the short form: The binary copy of libmyodbc_mysql.so Jon sent me
~was corrupted during the transfer. However, I had no way to verify its
~operation.
~
~The longer form for those who are still having trouble:
~
~First Apache wouldn't work with iHTML. So I recompiled according to
~Inline's instructions, and used iHTML 2.18b3. That solved that. But now
~it wouldn't talk to MySQL. Since iODBC returns no helpful error
~information, I couldn't be sure where the problem was. iHTML worked, but
~wouldn't talk to MySQL. Possible suspects were Linux and MySQL access
~permissions, the configuration of my iodbc.ini file, and
~libmyodbc_mysql.so.
~
~I initially tried playing with all the other suspects. I exhausted
~everything including my patience, and turned to libmyodbc_mysql.so. I
~grabbed the source from tcx.se, and tried to compile it. I came to find
~that this isn't for the faint of heart -- unless you're familiar with
~MySQL's source installer configuration, it's really tough. I'm not.
~
~So I asked Jon about it, and he kindly sent me his binary of
~libmyodbc_mysql.so. However, it wasn't tar'd or zipped. This didn't occur
~to me as a potential problem until later.
~
~So I installed it, the MySQL connection still didn't work, and I just
~kept plugging away like a prison laborer. I revisited all the options,
~checked all the logs, and nothing worked. So I went back to
~libmyodbc_mysql.so as my suspect.
~
~I downloaded the source again, and waded through all the configs to make
~it compile. It could never seem to find a particular header library, I
~emailed the author, he didn't reply, and I was generally hopeless. I
~enlisted the help of a Unix expert friend, and was waiting for him to
~come by when...
~
~I was browsing Dejanews and found a thread in German on
~libmyodbc_mysql.so -- lucky I spent a couple of years there. This guy
~also had a problem compiling it, but listed a link to a good i386 binary:
~
~http://www.uni-koblenz.de/~horn/export/iodbc.tgz
~
~I downloaded it, found the shared object amongst the other stuff in the
~archive, popped it in, and VICTORY!
~
~So now I'm one of, what, two people using this combo? Smile I feel so
~privileged.
~
~Steve Freitas
~Newport Beach, California
_________________________________________________________
At 10:09 AM 7/12/99 -0500, you wrote:
Quote:


Thanks - that will come handy when I get that far. I have yet
to get the DSN working - I can't connect to the database using
isql or Datamanager yet.

Gary

[email]dougb (AT) inline (DOT) net[/email] wrote:

You'll need to symlink /usr/lib/libodbc.so to /usr/lib/libiodbc.so.
iHTML expects the driver manager to be named libiodbc.

run ldconfig after you create this symlink.

Doug

On Mon, 12 Jul 1999, you wrote:
Hi!

I hope to use MySQL with iHTML - I am almost there!
I am having problems using unixODBC with MyODBC to connect to a
MySQL database. I am running MySQL 3.22.24 and MyODBC 2.50.24 on
Linux 2.0.36.

- I configured myodbc with:
../configure --with-mysql-sources=/home/mysrces/mysql/mysql-3.22.24
---with-unixODBC=/usr --with-unixODBC-libs=/usr/lib
--with-unixODBC-includes=/usr/include

- the make and make install ran ok, and installed the driver
in /usr/local/lib
- I used ODBCConfig to add the driver using:
Driver Lib: /usr/local/lib/libmyodbc.so
Setup Lib: /usr/lib/libodbcmyS.so.1.0.0 [this is from unixODBC]
- I used ODBCCOnfig to create a system DSN for the test database:
Name: MySQLTest
Host: localhost
Port: 3306
Socket: /tmp/mysql.sock
Database: test
- I ran DataManager and tried to connect but I got:
Login Failed
This may be for one of these reasons:
1. Invalid ID and Password
2. Invalid Data Source Config
3. Improper installation

- I ran "isql MySQLTest" and got:
[ISQL]ERROR: Could not SQLConnect

- I did a DSN trace and found this:
[ODBC][28619][SQLConnect.c][170]Error: IM003
[ODBC][28619][SQLConnect.c][892]
Entry:
Connection = 0x8084390
Server Name = [MySQLTest][length = 9 (SQL_NTS)]
User Name = [testuser][length = 8 (SQL_NTS)]
Authentication = [mypasswd][length = 8
(SQL_NTS)]
[ODBC][28619][SQLConnect.c][170]Error: IM003

- I don't think that it is a permissions problem because I am able
to connect to the database using mysql monitor and the same
user/password combo. In addition, I was able to use the Windows
ODBC driver to connect to the test database using that
username/password
combo.

Any ideas? Thanks in advance!

Gary Wong
[email]gary.wong (AT) spingroup (DOT) com[/email]



To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.
--
----------------------------------
Doug Bell
Software Developer
Inline Internet Systems Inc.
----------------------------------

To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.



To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.





-------------------
Hood Gardner - Webmaster/Network Admin for Osment Models, Inc.
[email]webmaster (AT) woodlandscenics (DOT) com[/email]
http://www.woodlandscenics.com/
http://www.dpmkits.com
http://www.pinecar.com/


Back to top
Display posts from previous:   
Post new topic   Reply to topic    MySQLTalk.org Forum Index -> MySQL ODBC All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.