Can't call method "prepare" on an undefined value!

[gmccammon]

I am getting an error that says that I can't call method "prepare" on an undefined value!

Here is what I have as code.... I don't understand what is not defined.

# opens connection to Access database titled KTC.mdb
# no passwords on our database
$dbh = DBI->connect('dbi:ODBC:KTC');
$connect = DBI->connect('dbi:ODBC:KTC');
 
# sets variable $productID to a value of 1
$productID=1;
 
# prepares query1
# selects elements from Products table where productID is equal to 1
$query1 = "SELECT ProductName, ProductDescription, UnitsInStock, UnitPrice FROM Products WHERE ProductID = $productID";
$query_handle = $connect->prepare($query1);
 
# Executes the SQL statement defined in query1
$query_handle->execute();
 
 

[miller]

Add some error trapping to your code. Most likely your database handle isn't really being created. You'll have to do some more reading up on DBI to determine what the proper connect string is.

http://search.cpan.org/search?query=DB I

One thing I do notice though is that you are not specificing a username or password. I do not know if this is strictly necessary for your database, but I expect that it probably is.

Either way, add the or die statements that you can at least discover where and when you're having a problem, instead of relying and perl failing because of false assumptions like "is this $dbh created?".

# opens connection to Access database titled KTC.mdb
# no passwords on our database
$dbh = DBI->connect('dbi:ODBC:KTC') or die "Database connection failed.";
 
# sets variable $productID to a value of 1
$productID=1;
 
# prepares query1
# selects elements from Products table where productID is equal to 1
$query1 = "SELECT ProductName, ProductDescription, UnitsInStock, UnitPrice FROM Products WHERE ProductID = $productID";
$query_handle = $dbh->prepare($query1);
 
# Executes the SQL statement defined in query1
$query_handle->execute() or die $dbh->errstr;
 

[gmccammon]

Thanks, it definitely was not connecting. Although, I tried the same code on another machine and it works. Go figure. Thanks again.