Hi Friends,
I am in bit of the proble. I am using DBI for the first time and have made a simple
program. But am not able to run on mine PC.I am using windows . Please tell me what
wrong I am doing in the following program.
I have made a DSN with name abhijain
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("dbi:ExampleP:abhijain","sa","");
my $sth = $dbh->do("create table student(rollno int,name varchar(20))");
$dbh->disconnect();
I am getting the following error DBD::ExampleP::db do failed: Syntax
error in select statement ("create table student(rollno int,name varchar(20))") at
noname.pl line 4.
Also I want insert statement in the program please tell me what code i must write.I
have tried many tutorials but nothing solved mine problem.
Please help me I shall be very very grateful
Thanks,
Abhishek jain
***********************************************
GOD BLESS MISSION 2020
***********************************************
