Webmaster Forum / Perl / DBI Library / December 2005

Check to see if you can connect to sqlplus in the command prompt.
You should also check the tnsnames.ora entry.
-----Original Message-----
From: Mitchell, Louise M [mailto:Louise.Mitchell@pnl.gov]

I am very sorry to bother but I am stumped. I am running mysql server
and client 3.23.58 and am trying to get postfix admin up and running but
I keep getting a error when trying to access the site ...." Connect:
Client does not support authentication protocol requested by server;

Does anybody know what could cause this (beside ORACLE_HOME and NLS settings)  ?
DBI->connect() failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc.
Thank you,
Igor

Hi Tim,
I replyed before to the forum about this and I did what you are saying.
I was able to do the make, make test and make install.
Reading your email I assume that it is going to work even if I remove

I am trying to install BDI in a solaris 8 server.
** The perl Makefile.PL ends fine..
Checking if your kit is complete...
Looks good

I am a novice user to PERL. Plz help me regarding
following information
Suppose there is a MySQL DB say X, with Server Y, User
XY, Password XYZ and Table ABC.

These errors are to be expected. Your binaries should be fine.
Michael
Extranet
rfrink@theoccamgroup.com - 27/12/2005 21:36

I am working on a script that inserts records into a Progress database.
The script connects via DBI and odbc.
As I loop through each potential record to import, I query the database
for some info.  Occasionally I get errors like this:

Hi Tim--
I'm having problems building DBD::Oracle with the new Oracle Express
product (see
http://www.oracle.com/technology/products/database/xe/index.html).

I am trying to use freetds (0.63) as the library for DBD::Sybase (1.07) to
communicate with MS SQL 2000 servers.  After the build, it does not appear
that DBD::Sybase reconizes the freetds config file
(/usr/local/freetds/freetds.conf), in particular for defining which

I believe a describe statement is Oracle DDL, but I still failed for
both of the ways that I know of to execute sql.  There must be something
that I am not considering.
#!/usr/local/bin/perl

If the query has where clause
where division_id = :1 and division_order_id = :2
execution tooks way too long taking into account that division_id (VARCHAR2) + division_order_id (VARCHAR2) is the primary key in this table.
A simple addition forcing division_order_id to be VARCHAR, ...

I'm going quickly insane trying to debug this...
Long story short:
DBI 1.50
DBD::Pg 1.43

I have one server, where electric power goes down time to time.
I have many databases in mysql, and some tables are corrupted.
Do you think it is good idea to write script and put it to cron, and
it should check if some table has error (MYSQL show status command?),

List,
I have an $application that uses Oracle on Windows 2000, and I speak to
the database with ActiveState Perl 5.6, since 5.6 is the last version
for which Oracle allows AS to package DBD::Oracle. This reason, as much