in reply to Database access error.

It looks like you may have a library compatibility problem.

Did you compile the module? If the C compiler you used for this module was different from the one used to compile Perl and MySQL, then you should get the sources for both and recompile them. :(

From the DBD::mysql installation doc

A C compiler is only required, if you install from source. In most cases there are binary distributions of DBD::mysql available. However, if you need a C compiler, make sure, that it is the same C compiler that was used for compiling Perl and MySQL! Otherwise you will almost definitely encounter problems because of differences in the underlying C runtime libraries.

In the worst case, this might mean to compile Perl and MySQL yourself. But believe me, experience shows that a lot of problems are fixed this way.

Replies are listed 'Best First'.
Re: Re: Database access error.
by devslashneil (Friar) on Jun 27, 2003 at 05:32 UTC
    One again thanks a lot for posting, just compiled perl myself and DBI / DBD::mysql compiled perfectly :)

    Neil Archibald
    - /dev/IT -
Re: Re: Database access error.
by devslashneil (Friar) on Jun 27, 2003 at 03:14 UTC
    Thanks for your input,

    Argh i'm sure this would fix alot of problems but i'm really scared to do this as i'm new to the solaris environment and this is a very important box to my work.

    Breaking this box could very well cost me my job

    :-(

    The C compiler isn't even in the path so i'm not sure how i would be at compiling perl.

    Neil Archibald - /dev/IT -