By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,568 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

Dbi Odbc

P: 1
Useing Activer Perl 5.8.8 with DBI ODBC. Installed DBI 1.601

getting error

install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: C:/
Perhaps the DBD::ODBC perl module hasn't been fully installed,
or perhaps the capitalisation of 'ODBC' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
at C:\InCharge6\SAM\smarts\local\actions\msdbi.pl line 63

line 63 is

$db_handle = DBI->connect("DBI:ODBC:$dsn1,$user, $pw") or die "Couldn't connect to database: $DBI::errstr\n";


re-installed DBI and same error
Feb 4 '08 #1
Share this Question
Share on Google+
1 Reply


numberwhun
Expert Mod 2.5K+
P: 3,503
Useing Activer Perl 5.8.8 with DBI ODBC. Installed DBI 1.601

getting error

install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: C:/
Perhaps the DBD::ODBC perl module hasn't been fully installed,
or perhaps the capitalisation of 'ODBC' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
at C:\InCharge6\SAM\smarts\local\actions\msdbi.pl line 63

line 63 is

$db_handle = DBI->connect("DBI:ODBC:$dsn1,$user, $pw") or die "Couldn't connect to database: $DBI::errstr\n";


re-installed DBI and same error
That's just it, you need to read the error to understand what it is complaining about. It is not complaining about DBI, it is complaining about the DBD::ODBC module. You are going to have to install that before you continue.

Basically, DBI provides you an interface or way to talk to the Database of your choice and you need the DBD module for that particular database, to go along with it, kind of like a translator.

Install the DBD::ODBC module and then re-run your script.

Regards,

Jeff
Feb 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.