I have used DBI::Oracle in the past, but now I need to use DBI::SQLite and it seems the connection structure is different.
I changed the password to all #'s.
The error I am getting is that it cannot find the table EMPLOYEE. The table EMPLOYEE is under DEV. I don't see where to put that.
In Oracle I used dev.EMPLOYEE, I tried that in SQLite and it can not find the table.
There are no errors on the connection, just the prepare.
Does anybody see what I am doing wrong?
Perl:
#### program variables
$dbsys = "spwdclwsntdb1";
$user = "lawsonpf";
$pass = "##########";
$dsn = "DBI:SQLite:dbname=$dbsys";
use DBI;
$dbh=DBI->connect($dsn, $user, $pass) or die;
$sth = $dbh->prepare("SELECT * FROM EMPLOYEE")
or die "Couldn't prepare statement: " . $dbh->errstr;
I changed the password to all #'s.
The error I am getting is that it cannot find the table EMPLOYEE. The table EMPLOYEE is under DEV. I don't see where to put that.
In Oracle I used dev.EMPLOYEE, I tried that in SQLite and it can not find the table.
There are no errors on the connection, just the prepare.
Does anybody see what I am doing wrong?