SQLOLEDB

------=_NextPart_000_0001_01C71239.BACB7400
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0001_01C71239.BACB7400--

Re: SQLOLEDB

Rossi EpvTech wrote:

> 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?!??!

Not sure, but it seems that ADO (OLE) uses the regional settings
(on the client).
If I 'select CURRENT_TIMESTAMP', I get e.g. 2006-11-28 09:27:32,
which is the format I choose in the control panel.


Steffen