Bruce W. Hoylman [[EMAIL PROTECTED]] wrote:
> >>>>> "Kirk" == Kirk Tarou <Tarou> writes:
>
> Kirk> When trying to connect to a remote Oracle server, I get the
> Kirk> following error:
> DBI-> connect(T:xxx.xxx.xxx.xxx:psysrp1) failed: Error while trying
> DBI-> to
> Kirk> retrieve text for error ORA-06401 (DBD ERROR: OCIServerAttach)
> Kirk> at test.pl line 10
I'm actually interested in this "Error while trying to retrieve text
for error" message - I'm getting the same message for any Oracle error
on an Oracle client machine. What more do I need, or what did I do
wrong on the Oracle client install?
>
> 06401, 00000, "NETCMN: invalid driver designator"
> // *Cause: The login (connect) string contains an invalid driver designator.
> // *Action: Correct the string and re-submit.
>
>
> Kirk> my line ten looks like this:
>
> Kirk> $dbh = DBI->connect('dbi:oracle:T:xxx.xxx.xxx.xxx:psysrp1',
> Kirk> $username, $password, { RaiseError=> 1, AutoCommit});
>
> The DBI documentation (an invaluable resource) states:
>
> Examples of "$data_source" values are:
>
> dbi:DriverName:database_name
> dbi:DriverName:database_name@hostname:port
> dbi:DriverName:database=database_name;host=hostname;port=port
>
Also, take a look at the DBD::Oracle perldoc documentation by doing
"perldoc DBD::Oracle" - there is some great info about using the
TWO_TASK environment variable to specify 'T:Machine:SID' and similar
things.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
