Paul Grenyer | 1 Jan 13:33 2004
Picon

Re: - Connecting to MySQL via MyODBC on Linux [Long]

On Wed, 2003-12-31 at 21:41, Nick Gorham wrote:

Hi

> Well a short term fix would be to change the lib search path so
> /usr/local/lib is found first, try
> 
> export LD_LIBRARY_PATH=/usr/local/lib

Ok, then so what actually is my problem? I have two ODBC manangers
installed? The original Red Hat one and the unixODBC one? The above fix
masks the problem by making sure the unixODBC one is found first? Is all
of that correct?

What is the proper solution? Remove one of the managers and correctly
configure the remaining one?

--

-- 
Regards
Paul

Paul Grenyer
Email: paul <at> paulgrenyer.co.uk
Web: http://www.paulgrenyer.co.uk

Have you met Aeryn: http://www.paulgrenyer.co.uk/aeryn/?

Nick Gorham | 1 Jan 14:38 2004

Re: - Connecting to MySQL via MyODBC on Linux [Long]


----- Original Message ----- 
From: "Paul Grenyer" <paul <at> paulgrenyer.co.uk>
To: <unixodbc-dev <at> unixodbc.org>
Sent: Thursday, January 01, 2004 12:33 PM
Subject: Re: [unixODBC-DEV] - Connecting to MySQL via MyODBC on Linux [Long]

> On Wed, 2003-12-31 at 21:41, Nick Gorham wrote:
>
> Hi
>
> > Well a short term fix would be to change the lib search path so
> > /usr/local/lib is found first, try
> >
> > export LD_LIBRARY_PATH=/usr/local/lib
>
> Ok, then so what actually is my problem? I have two ODBC manangers
> installed? The original Red Hat one and the unixODBC one? The above fix
> masks the problem by making sure the unixODBC one is found first? Is all
> of that correct?
>
> What is the proper solution? Remove one of the managers and correctly
> configure the remaining one?

Well thats one way. However the red hat one is unixODBC, just built by
RedHat, so the question is why the RedHat one is failing to work with your
app. The simple answer is I don't know. If you could get tracing to start it
may help to show just what the problem is. I am not sure what version of
unixODBC you have in RedHat at the moment.

(Continue reading)

Paul Grenyer | 1 Jan 18:03 2004
Picon

Re: - Connecting to MySQL via MyODBC on Linux [Long]

Hi

Problem solved, I think!

It turns out /usr/local/lib wasn't in my  /etc/ld.so.conf, so I added it
and my test program still works, even after a reboot.

Thanks, all!
--

-- 
Regards
Paul

Paul Grenyer
Email: paul <at> paulgrenyer.co.uk
Web: http://www.paulgrenyer.co.uk

Have you met Aeryn: http://www.paulgrenyer.co.uk/aeryn/?

Aurelien Marchand | 6 Jan 21:07 2004

- UnixODBC, Wine, Crystal Report -- would appreciate insight

Hi,

I am a bit confused as to who I should send this email. Please let me 
know if this is the wrong place.

I am really, really close to making the whole thing work (I'll show in a 
minute why I think that) but I'm stomped and need some help.

I've dumped my WinNT workstation and replaced it with Linux. So far, I 
can do exactly everything I was able to do (except updating my calendar 
on the Exchange server used where I work), minus using Crystal Report.
I have installed it using CodeWeavers' CrossOver Office and it installed 
without even a hiccup.
I've also installed unixODBC and tested the odbc.ini configuration using 
isql. It works great when I try to connect to the company's AS400 
database. The default library is set to my username and I can query 
other libraries using the dot (.) as a separator (e.g: SELECT * from 
OTHERLIB.OTHERTABLE).

So far so good: UnixODBC works perfectly to talk to IBM's AS400.

Now I need to tell Crystal which drivers to use. I've read on the web 
that Crystal is not a very good student and thus ignores Windows' 
ODBC.ini settings but checks what's in the registry. I've also come to 
understand I must set ODBC.dll = "builtin, native" in my Wine's config 
file so that it will try to use whatever is set for 
LIB_ODBC_DRIVER_MANAGER env variable for Windows' ODBC connections.

I've come to that point: my system.reg or my user.reg contain one ODBC 
setting (the same name found on /etc/odbc.ini and ~/.odbc.ini). My wine 
(Continue reading)

Picon

Re: - UnixODBC, Wine, Crystal Report -- would appreciate insight

how do I remove myself from the list

thanks

----- Original Message ----- 
From: "Aurelien Marchand" <aurelien.marchand <at> researchcapital.com>
To: <unixodbc-dev <at> easysoft.com>
Sent: Tuesday, January 06, 2004 3:07 PM
Subject: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would appreciate
insight

> Hi,
>
> I am a bit confused as to who I should send this email. Please let me
> know if this is the wrong place.
>
> I am really, really close to making the whole thing work (I'll show in a
> minute why I think that) but I'm stomped and need some help.
>
> I've dumped my WinNT workstation and replaced it with Linux. So far, I
> can do exactly everything I was able to do (except updating my calendar
> on the Exchange server used where I work), minus using Crystal Report.
> I have installed it using CodeWeavers' CrossOver Office and it installed
> without even a hiccup.
> I've also installed unixODBC and tested the odbc.ini configuration using
> isql. It works great when I try to connect to the company's AS400
> database. The default library is set to my username and I can query
> other libraries using the dot (.) as a separator (e.g: SELECT * from
> OTHERLIB.OTHERTABLE).
>
(Continue reading)

Aurelien Marchand | 6 Jan 22:07 2004

Re: - UnixODBC, Wine, Crystal Report -- would appreciate insight

from the registration email:
--

Welcome to the unixodbc-dev mailing list!

Please save this message for future reference.  Thank you.

If you ever want to remove yourself from this mailing list,
you can send mail to <majordomo <at> easysoft.com> with the following
command in the body of your email message:

    unsubscribe unixodbc-dev

Aurelien

Phillip Blancher - Ontario Web wrote:

>how do I remove myself from the list
>
>thanks
>
>
>----- Original Message ----- 
>From: "Aurelien Marchand" <aurelien.marchand <at> researchcapital.com>
>To: <unixodbc-dev <at> easysoft.com>
>Sent: Tuesday, January 06, 2004 3:07 PM
>Subject: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would appreciate
>insight
>
>
(Continue reading)

Bill Medland | 7 Jan 16:11 2004

Re: [Fwd: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would appreciate insight]

On January 6, 2004 07:35 pm, Dan Kegel wrote:
> Can somebody have a look at this?
> Thanks,
> Dan

I'll do what I can; everyone else feel free to jump in.

>
> -------- Original Message --------
> Subject: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would
> appreciate insight Date: Tue, 06 Jan 2004 15:07:11 -0500
> From: Aurelien Marchand <aurelien.marchand <at> researchcapital.com>
> Reply-To: unixodbc-dev <at> unixodbc.org
> To: unixodbc-dev <at> easysoft.com
>
> Hi,
>
> I am a bit confused as to who I should send this email. Please let me
> know if this is the wrong place.
>
> I am really, really close to making the whole thing work (I'll show in a
> minute why I think that) but I'm stomped and need some help.
>
> I've dumped my WinNT workstation and replaced it with Linux. So far, I
> can do exactly everything I was able to do (except updating my calendar
> on the Exchange server used where I work), minus using Crystal Report.
> I have installed it using CodeWeavers' CrossOver Office and it installed
> without even a hiccup.
> I've also installed unixODBC and tested the odbc.ini configuration using
> isql. It works great when I try to connect to the company's AS400
(Continue reading)

Aurelien Marchand | 8 Jan 20:33 2004

Re: Fwd: Re: [Fwd: - UnixODBC, Wine, Crystal Report -- would appreciate insight]]


Bill Medland wrote:

>Just in case you didn't get this; I didn't see you in the CC
>  
>
>>>------- Original Message --------
>>>Subject: [unixODBC-DEV] - UnixODBC, Wine, Crystal Report -- would
>>>appreciate insight Date: Tue, 06 Jan 2004 15:07:11 -0500
>>>From: Aurelien Marchand <aurelien.marchand <at> researchcapital.com>
>>>Reply-To: unixodbc-dev <at> unixodbc.org
>>>To: unixodbc-dev <at> easysoft.com
>>>
>>>Hi,
>>>
>>>I am a bit confused as to who I should send this email. Please let me
>>>know if this is the wrong place.
>>>
>>>I am really, really close to making the whole thing work (I'll show in a
>>>minute why I think that) but I'm stomped and need some help.
>>>
>>>I've dumped my WinNT workstation and replaced it with Linux. So far, I
>>>can do exactly everything I was able to do (except updating my calendar
>>>on the Exchange server used where I work), minus using Crystal Report.
>>>I have installed it using CodeWeavers' CrossOver Office and it installed
>>>without even a hiccup.
>>>I've also installed unixODBC and tested the odbc.ini configuration using
>>>isql. It works great when I try to connect to the company's AS400
>>>database. The default library is set to my username and I can query
>>>other libraries using the dot (.) as a separator (e.g: SELECT * from
(Continue reading)

Troester, Tim | 9 Jan 00:25 2004

- Porting unixodbc 2.2.7 to HPUX

All,

Does anyone know if unixodbc 2.2.7 has been ported onto HPUX using the aCC
compiler? 

Tim

Nick Gorham | 9 Jan 08:39 2004

Re: - Porting unixodbc 2.2.7 to HPUX

Troester, Tim wrote:

>All,
>
>Does anyone know if unixodbc 2.2.7 has been ported onto HPUX using the aCC
>compiler? 
>
>Tim
>  
>
Doesn't it work ?

We build on HPUX using the normal HP compiler.

--

-- 
Nick


Gmane