Hi, I have not been able to find this on the DBI book or anywhere else
I have a script that uses DBI to connect from a linux client to a mysql
server on another linux machine via
a connect(
my $dbh=DBI->connect('DBI:mysql:database_name;host=172.16.160.8',....)
statement
This runs fine.
Now this has to be run from a colleague who runs this on a Windows
machine connecting to a
 remote Oracle RDBMS
In his case he gets an error message:

DBI->connect(databasename;host=1.0.26.231) failed: Can't connect using
this
   syntax wit
   hout specifying a HOST and a SID at driver.pl line 334
   ----

Why is this and what do I need to change?


On a second question, suppose I need to execute
$sth->execute(@tmp);
where sth is a statement handle for an INSERT. Some of the @tmp entries
are '', i.e. the empty string. How do I specify them to be NULL?

Thanks
S.Alexiou
[EMAIL PROTECTED]

Reply via email to