MyODBC, MacOSX 10.3.9

Hi all,

I have downloaded and installed the myodbc3 driver for MacOSX onto my
Panther machine (10.3.9). First surprise, the MySQL graphical installer
doesn't seem to appear in the Applications folder, has it been dropped ?

Secondly, although I have manage to configure ODBCAdministrator, the
datasource is declared, and visible to the user, it is however
inaccessible, and I get an error message when trying to connect. I have
noticed that the readme says that an executable file should be installed
in /usr/bin/ as myodbc3i, when I start this command as sudo from a
terminal, I get the following error message :

/usr/lib/libltdl.3.dylib (No such file or directory)

and indeed the libtool library isn't installed.

The README provided with the MyODBC dmg package states that you don't
actually need anything else to get MyODBC working, not even the MySQL
client libraries, so what gives with the libtool dependencies ?

After trawling with Google, I found on a mysql list a suggestion that
one should install the XCode development package provided by Apple,
since that package provides the library in question. Here's the crunch,
my disks with the Mac machines are tiny, thw whole point is to access
data remotely and not have to store stuff locally, and that also means
not having space to install a development environment on every machine.
So what am I to do ? Is this problem not going to be fixed ? Is there no
solution other than that (some solution !!)

Thirdly, I notice that the installation hasn't provided a file called
libmyodbc3S.dylib, which is traditionally the shared library to which
function calls are made for setup of the connection to the mysql server.
Has this been dropped too, or is the MacOSX package deficient ?

The worst bit about all of this is that a binary package was previously
available (3.51.9 or 10 I think), that had all of these things in it,
but I don't seem to be able to find it anymore on the servers.

Any help most gratefully taken.


Alex


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC, MacOSX 10.3.9

At 2006-06-12 16:21 +0200 Thurgood Alex wrote:

>Any help most gratefully taken.

Alex - a while back, I made the following post here:

At 2006-05-04 20:56 +0100 Rowland Carson wrote:

>I downloaded and installed the Mac ODBC drivers for MySQL, and
>wondered why I couldn't get them to work. I realised later when
>re-visting the download page that I hadn't spotted they were for Mac
>OS X 10.4 - I'm running 10.3.9 and don't really want to switch OS at
>this time.
>
>I looked around the other downloads for MySQL ODBC, and the only
>possibility seems to be to download the source of the older version
>and compile it myself. Not sure I feel up to that!
>
>Am I correct? Are there no "ready-made" MySQL ODBC drivers for Mac
>for OS X 10.3.9?

I didn't get any replies germane to my situation, and so concluded
that my assumption was correct. My impression is that us Mac folk are
pretty thin on the ground in MySQL-land. I had been hoping to get
some sort of interaction going between FileMaker Pro and MySQL using
ODBC, but am now looking at different approaches.

regards

Rowland
--
| Wilma & Rowland Carson http://home.clara.net/rowil/
| ... that's Rowland with a 'w' ...

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC, MacOSX 10.3.9

>> I downloaded and installed the Mac ODBC drivers for MySQL, and
>> wondered why I couldn't get them to work. I realised later when re-
>> visting the download page that I hadn't spotted they were for Mac
>> OS X 10.4 - I'm running 10.3.9 and don't really want to switch OS
>> at this time.
>>
>> I looked around the other downloads for MySQL ODBC, and the only
>> possibility seems to be to download the source of the older
>> version and compile it myself. Not sure I feel up to that!
>>
>> Am I correct? Are there no "ready-made" MySQL ODBC drivers for Mac
>> for OS X 10.3.9?

Back in April, I tried for over two weeks to get MySQL ODBC working
on a Mac. No luck. I ended up isolating the MySQL specific code in a
PHP class with a myodbc-like front end and use that instead. That
way, if I need to switch DBMSs at some later date, it's just a matter
of changing a PHP script or two.

This approach has the added advantage that client apps don't need to
contain any special ODBC libraries (which will become obsolete
eventually) Just upgrade PHP on the server and all your client apps
still work.

I don't know if you're a programmer or not, but if you are and need
to make Cocoa applications talk to PHP, it's pretty easy and there is
a recent thread on the Apple Cocoa mailing list that shows how to do it.

HTH

Ken Tozier

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC, MacOSX 10.3.9

At 2006-06-14 01:36 -0400 Ken Tozier wrote:

>I don't know if you're a programmer or not, but if you are and need
>to make Cocoa applications talk to PHP, it's pretty easy and there
>is a recent thread on the Apple Cocoa mailing list that shows how to
>do it.

Ken - thanks for your response. I wouldn't claim to be a "current"
programmer - I did a lot of work in C around 20 years ago (in OS/9,
not to be confused with Mac OS 9), and about the most I've done in
Cocoa is to make a proper (ie RPN) 4-function calculator. But that
thread sounds interesting - I'll look it up.

(And why does this list reply-to-poster, not reply-to-list?)

regards

Rowland
--
| Wilma & Rowland Carson http://home.clara.net/rowil/
| ... that's Rowland with a 'w' ...

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC, MacOSX 10.3.9

On 13/6/06 10:44, Rowland Carson wrote:

> I didn't get any replies germane to my situation, and so concluded
> that my assumption was correct. My impression is that us Mac folk are
> pretty thin on the ground in MySQL-land. I had been hoping to get

I think that's partly because just getting MyODBC to work has been pretty
painful, and almost impossible for some users. (I'm including building from
source here.)

Things are also harder than they should be because older CFM apps (eg Excel)
need a shim from a third party in order to use any of Apple's ODBC stuff.

Argh.

> some sort of interaction going between FileMaker Pro and MySQL using
> ODBC, but am now looking at different approaches.

What's Postgres's ODBC support like on OS X?

Cheers,

Chris



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org