Hello,
I'm using SQLOLEDB to connect to a MSSQL database where I've inserted
some data using the "BULK INSERT" with the option "SET DATEFORMAT DMY".
The SO language installed on the computer where the Sql Server and my
programs runs is English with "Italian" as regional option.
My connection string is :
 
$dbh=DBI->connect("DBI:ADO: PROVIDER=SQLOLEDB.1;server=DTS03;
DATABASE=work;Current Language=Italian",
                      "$user","$pwd",{'RaiseError' => 1});
 
well, every time I fetch a table the "date" information is returned
in a US format instead of a Italian. it seems that the "Current
Language" option
doesn't work !!!!!
How can I solve the problem?!??!
 
 
Thanks 
Mario Rossi

Reply via email to