Using perl to manipulate Database

Naren2585

Hi everyone
I am new to Perl. My database is in MS.ACCESS. Now i need to write a program in Perl to do any future manipulations to the database.Can any one help me ?

KevinADC

As we ask everyone that only posts a set of requirements sans code:

What have you tried so far?

Naren2585

Hi
Thanks for the reply..

I am completely new to Perl. I don't even know the packages which i need to install for accessing a MS.ACCESS database.

Can u gimme a brief list of packages ?

KevinADC

You need to install DBI and I think DBD::ODBC for Access.

Naren2585

Thank you .
I went through a program in the following link which can is similar to the one i have been searching for .

http://bytes.com/serversidescripting/perl/tutorials/asimpledatabaseprogram/database.txt

But this program has limitations.The constraint is the type of the field being limited to text.My database is bio-related . It contains sequences of proteins and DNA . Can u suggest some changes so that the limitations can be overcome?

KevinADC

Quote:

Originally Posted by Naren2585

Thank you .
I went through a program in the following link which can is similar to the one i have been searching for .

http://bytes.com/serversidescripting/perl/tutorials/asimpledatabaseprogram/database.txt

But this program has limitations.The constraint is the type of the field being limited to text.My database is bio-related . It contains sequences of proteins and DNA . Can u suggest some changes so that the limitations can be overcome?

Sorry, there is no way I am going to look through all that code and try and suggest changes. Maybe you want to look into BioPerl or search CPAN for Bio modules.

bytesonfire

There is a similar post for using MS Access

Using MS Access Database in Perl

Thanks

Naren2585

Quote:

Originally Posted by KevinADC

Sorry, there is no way I am going to look through all that code and try and suggest changes. Maybe you want to look into BioPerl or search CPAN for Bio modules.

Hi .. i guess my wish was too much . any ways thank you .

Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

re: Using perl to manipulate Database

Similar Perl bytes

/bytes/development

/bytes/it

/bytes/about