>>>>> "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
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
Peace.
