Re: Upgraded to perl v5.6.1 => result: Error! No database drivers availableB

[Thomas G. <to...@ad...>]

On Tue, 30 Oct 2001, Oscar Buijten wrote:

> So the DBD directory does not exist in perl 5.6.1
> I guess I had to 'un-rpm' or something the older version of perl before=
=20
> installing the newer.
> How can I fix this? I just copy the missing directory?
> Oops! I've just tried that! That didn't help.
>=20
> Any suggestions?

Grab DBD-Pg from CPAN and unpack it into /usr/local/src.

# cd /usr/local/src/DBD*
# perl Makefile.PL
# make=20
# make install

Then run my script again.  It should work at this point.
When you've finished and got a working system we can talk about
breaking it (briefly ;-) by doing an upgrade to 7.1.3

Here is something else 7.0 can't do:

SELECT fname, lname, move_in=20
FROM tracker RIGHT JOIN client_placement=20
USING (client_id)
WHERE move_out IS NULL=20
AND dept_id =3D 1008
AND track_id =3D 1;

That's an OUTER JOIN.  Very handy.  Now if we can only get DROP COLMUN
I'll be satisified!  ;-)

Good luck with DBD.  Fire away if you get stuck.
--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------