win32-odbc

[Jeniveve]

I keep getting the following error when I try and run an old script that was written prior to my starting here. It utilizes win32-odbc which I am not familiar with (I use dbi) the error is:

Can't load 'E:/Perl/lib/auto/Win32/ODBC/ODBC.dll' for module Win32::ODBC: load_file:The specified module could not be found at E:/Perl/lib/DynaLoader.pm line 206.

Details of the problem:

I went from NT 4.0 (IIS 5.0) service pack 6 where everything was working fine to Windows 2000 Server Service pack 3 and the scripts broke. I have followed every troubleshooting advice for this error that I can find. The drives have all stayed the same with e: being the web drive, perl was pointed there when first installed.

I have done the following things to try and get it to work:

1) Installed win32-odbc twice to ensure it worked (all the files were already there from the original installation of perl 5.6 but I replaced them anyway)

2) I have made sure that all folders and subfolders have the correct permissions

3) I have checked the database itself and its permissions as well as add it as a file dsn and a system dsn.

4) I have tried to install win32-odbc from the ppm as well but it says no ppd file can be found.

5) I have set the repository to Roth Consulting and tried to search the repository but when I do that the search comes up with nothing

I am at a loss here as to what to do… Can anyone help?

Jennifer C. Swartz
Webmaster
Westfield State College

[Mr. Muskrat]

When changing operating systems, I have found that it helps to delete the perl directory and do a clean install of Perl.

[Jeniveve]

Thank you for your speedy reply however that has been done. The box was a new server and I completely blew it out and did clean installs of everything. Then, when nothing worked I removed perl again and reinstalled it again and went through the install notes for win32-odbc again just to make sure... Nothing seems to have worked so far... Jen

[cacharbe]

try:
c:\> ppm install libwin32

C-.

---
Flex the Geek

[richardX]

When you got the error message, "Can't load 'E:/Perl/lib/auto/Win32/ODBC/ODBC.dll'", did you verify that the ODBC.dll was where Perl expects to find it (E:/Perl/lib/auto/Win32/ODBC/) and that it is the correct ODBC.dll?

Richard

There are three types of people in this world, those that can count and those that cannot. Anon

[Necos]

Dave Roth is the author of Win32::ODBC. With that said, you can install his modules (Perms, ODBC, and many others) by going to his website (http://www.roth.net) and downloading the PPM zips that he has there. I've dealt with Win32::ODBC lightly, but I never had a problem installing it. I'm pretty sure his modules are broken under 5.6.x unless they're recompiled (I'm still using 5.005_03 since I don't need the new features really).

Again... Check Dave's site for some more leads. I hope this helps some.

Theodore Charles III
Network Administrator
Los Angeles Senior High
4650 W. Olympic Blvd.
Los Angeles, CA 90019
323-937-3210 ext. 224
email->[e-mail]
perl -e "map{print++$_}split//,Mdbnr;"

[Mr. Muskrat]

You didn't mention which Perl you have installed. IIRC, Win32::ODBC only works with ActiveState Perl.

I just visited Roth Consulting and see that there is a new Win32::ODBC beta available. PPD and other formats available.

[Jeniveve]

Hello again everyone,

After being out for about 3 weeks because of a car accident here I am again still trying to get this site working... I have read all 5 comments and have done everything listed, and I am still getting this error:

Can't load 'E:/Perl/lib/auto/Win32/ODBC/ODBC.dll' for module Win32::ODBC: load_file:The specified module could not be found at E:/Perl/lib/DynaLoader.pm line 206.

The libwin32 ppm install said that module was already installed, the win32-odbc install gets an error saying it cannot locate the ppd file.

I am at the point where I am willing to hire someone by the hour to fix whatever it is that the problem is. This page was written about 5 years prior to my starting here and I am not familiar with this module and I have done all the error checking I can do.

Is there anyone out there that would be willing to help for a consulting fee? Or does anyone have any other ideas. These are the things I have done so far:

I am using ActiveState Perl

Windows2000 Server

I have uninstalled and reinstalled Perl twice and downloaded the win32-odbc module from roth.net and gone through the install directions twice but with my version all files are already included. None of the files needed to be copied and the directories roth.net tells you to created are already created.

Libwin32 module is already installed.

I have checked and re-checked the directory to make sure it is executable.

I have checked and rechecked the server odbc settings to make sure the database is listed.

Any help would be appreciated!

Thank you.

Jennifer C. Swartz
Webmaster
Westfield State College