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

Using perl to manipulate Database

P: 5
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 ?
Nov 10 '08 #1
Share this Question
Share on Google+
7 Replies


KevinADC
Expert 2.5K+
P: 4,059
As we ask everyone that only posts a set of requirements sans code:

What have you tried so far?
Nov 11 '08 #2

P: 5
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 ?
Nov 11 '08 #3

KevinADC
Expert 2.5K+
P: 4,059
You need to install DBI and I think DBD::ODBC for Access.
Nov 11 '08 #4

P: 5
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?
Nov 11 '08 #5

KevinADC
Expert 2.5K+
P: 4,059
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.
Nov 11 '08 #6

bytesonfire
P: 7
There is a similar post for using MS Access

Using MS Access Database in Perl

Thanks
Nov 12 '08 #7

P: 5
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 .
Nov 12 '08 #8

Post your reply

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