Re: SQLOLEDB
- From: sgoeldner@xxxxxxxx (Steffen Goeldner)
- Date: Tue, 28 Nov 2006 09:37:52 +0100
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
.
- References:
- SQLOLEDB
- From: Rossi EpvTech
- SQLOLEDB
- Prev by Date: RE: DBD Oracle: multiple statements in a single execute?
- Previous by thread: SQLOLEDB
- Next by thread: DBD Oracle: multiple statements in a single execute?
- Index(es):
Relevant Pages
|
