SQLOLEDB
- From: mario.rossi@xxxxxxxxxxx (Rossi EpvTech)
- Date: Mon, 27 Nov 2006 15:35:55 +0100
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
- Follow-Ups:
- Re: SQLOLEDB
- From: Steffen Goeldner
- Re: SQLOLEDB
- Prev by Date: Re: DBD::ADO and Access IMAGE (OLE Object) fields...
- Next by Date: Re: DBD::ADO and Access IMAGE (OLE Object) fields...
- Previous by thread: Fwd: Can't connect to Sybase Rep server
- Next by thread: Re: SQLOLEDB
- Index(es):