http://www.perlmonks.org?node_id=1082661


in reply to Strawberry Perl 64bit on Win7 crashes on DBI-function

Unfortunatly i don't know why this doesn't work.

But why don't you forget about it and use the "build in" error handling? From the manual:

Typically RaiseError is used in conjunction with eval { ... } to catch
+ the exception that's been thrown and followed by an if ($@) { ... } 
+block to handle the caught exception...

[download]

Regards, Karl

«The Crux of the Biscuit is the Apostrophe»

Replies are listed 'Best First'.
Re^2: Strawberry Perl 64bit on Win7 crashes on DBI-function
by theman824 (Novice) on Apr 22, 2014 at 11:47 UTC

    In the end the Script is supposed to be run by users, who want so submit a SQL-Query to a DB2-Database. These users don't know any perl. So i want to give a detailed error massage, if the desired DSN is actually not configured (not existing) on the given machine. Which is why i want to determine the known ODBC-datasources at some point. And it was working nicely on perl 5.8.

[reply]

      Do DBI and DBD::ODBC work otherwise?

      If DBI and/or DBD::ODBC also fail with other function calls, my guess is that you somehow mixed 32-bit and 64-bit DLLs from the old and the new installation.

      Personally, I would look at avoiding ODBC datasources and instead use the appropriate connection string. Many of these connection strings can be found via http://connectionstrings.com.

[reply]
        This bit my @driver_names = DBI->available_drivers; works for example.

        And the actual DB-connection and basically what the whole script is supposed to do works. Just this one function call from DBI-package crashes. And in such a strange way. Same thing happens on two different machines, although running basically the same software-setup.

        I'll have a look into that link.

[reply]
[d/l]

In Section Seekers of Perl Wisdom