I have had to hang on to my old ActivePerl 5.6.1 binary build 638 in order to use Win32::ODBC on my laptop with Windows(tm) 7 Home Premium O/S. What I found is that the C:\Windows\System32 directory (default for ODBC Administrator Utility accessed from the Windows Help System) contains no ODBC Drivers. But the C:\Windows\SysWOW64 directory does contain ODBC Drivers. So when I run the ODBC Admin Utility from that directory(via Windows Explorer), I do get a list of the Drivers installed (MS-Access, etc.). But this is still not enough. Even though I manually place C:\Windows\SysWOW64 in my path, I still cannot get the latest ActivePerl (5.26.1) Win32::ODBC module to work. It must have been altered sometime after 5.6.1 ActivePerl was released 15 years ago. I have not upgraded my Perl since then because of this long standing bug. My guess is that someone hard coded the Win32::ODBC module to look for drivers in C:\Windows\System32 alone.
Failed: Microsoft ODBC Driver Manager Data source name not found and no default driver specified
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|