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]