Re: ODBC Driver failing?

On 26/06/2013 18:42, Dan Bent wrote:
> I agree, and I've been trying to identify what changed yesterday morning.
> The database, Perl,and the program all reside on the same machine, so I
> think we can rule out network issues.
>
> As far as I know, the DBMS, Perl and ODBC infrastructure have been
> stable for quite a while, and I haven't tinkered with any of that in
> recent memory. However, there is another administrator who might have
> unknowingly deleted files, and there are many users with access to this
> host (though most can only run one application, and shouldn't be able to
> get to the ODBC config stuff). I am really the only user who uses Perl
> and ODBC in the Unix environment.
>
> I suppose I could compare the backup tape with what is currently on the
> system to see if there are files obviously missing, but I'm not exactly
> sure what I would be looking for, and there could be thousands of files
> to compare.
>
> Am I thinking clearly on this?

The files you want to look for are:

odbc.ini
odbcinst.ini
any shared object referenced in any odbcinst.ini file
any file DBD::ODBC's ODBC.sl depends on (e.g., libodbc.sl or the driver 
shared object)

If you are not using unixODBC driver manager and you are using iODBC 
driver manager it is libiodbc.sl.

Then you might have had something in your environment e.g., most ODBC 
driver managers will follow ODBCINI env var or ODBCINSTINI etc. Some 
ODBC drivers need env vars setting in the environment e.g., DB2 often 
needs DB2INSTANCE. SO also check any profile files for the user doing ODBC.

But if you answer the other questions in my other reply I might be able 
to help more.

Martin

>
>
> On Wed, Jun 26, 2013 at 11:46 AM, Jonathan Leffler
> <[email protected] <mailto:[email protected]>> wrote:
>
>
>
>
>     On Wed, Jun 26, 2013 at 9:28 AM, Dan Bent <[email protected]
>     <mailto:[email protected]>> wrote:
>
>         I suddenly lost the ability to connect to my ODBC database
>         yesterday, after years of using the same function to establish a
>         connection:
>
>
>
>     So, the question you must ask yourself is:
>
>     What changed yesterday?  Or, if not yesterday, since the previous
>     time when you successfully used the code.
>
>     Something crucial changed.  If it wasn't the Perl plus ODBC
>     infrastructure, then what changed outside that?  The DBMS?  The
>     networking?
>
>     Change analysis is likely to get you to the answer quicker than
>     anything else.
>
>     --
>     Jonathan Leffler <[email protected]
>     <mailto:[email protected]>>  #include <disclaimer.h>
>     Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org
>     "Blessed are we who can laugh at ourselves, for we shall never cease
>     to be amused."
>
>