Buongiorno beloved Monks,
I'm connecting to M$$QL2008 server! using DBI,DBD::ODBC
I have this bit of code that searches for Constraints in a given table and then deletes them;
my $sth = $dbh->prepare("SELECT constraint_name FROM information_s
+chema.constraint_column_usage WHERE TABLE_NAME = '$tbl'");
my $temp = $sth->fetchrow_arrayref;
foreach my $rel (@$temp)
next unless ($rel =~ /ID/);
print "Relationship: $rel\n";
my $th = $dbh->prepare("ALTER TABLE Data_CentersTEST DROP CONS
All works well untill I actually try to delete the constraint! Perl throughs this error
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Conne
+ction is busy with results for another hstmt (SQL-HY000) at
U:\Doccuments\Scripts\Test\sql_do3.pl line 78.
searched google but couldn't find anything definite! Can someone shine a light on this please?
Thanks a lot!