instead of ToString("MM/dd/yyyy")

you can add the hours, minutes ...

ToString("MM/dd/yyyy hh:mi:ss")

*Have yet to lookup the correct formatting string

Haven't worked with TLS 1.2 yet but there is an update to 2012 SP3 to handle TLS 1.2 support

Planning to update 2012 is to service pack 3 Cumulative update 2...

The most exciting part for us is the revamped reporting services and Query Store

wow, nice

Use the proper datetype date to compare dates.

SELECT TO_DATE('07-Feb-2015','DD-MON-RRRR'),sysdate

from dual

where TO_DATE('07-Feb-2015','DD-MON-RRRR')<sysdate;

OR

SELECT TO_DATE('07-Feb-2015','DD-MON-RRRR'),sysdate

from dual

where MYDATE<TRUNC(TO_DATE('07-Feb-2015 15:00:00','DD-MON-RRRR HH24:MI:SS'));

*if you use date(time)parameters the TO_DATE isn't necessary

To get 7 februari

SELECT ...

FROM ...

WHERE...

Thanks for the e-book

Not sure.

I usually go with the TNS-alias of the oracle server, with the servername and port in tnsnames.ora.

Does the proxy user has access to the tnsnames/oracle client?

RIP Dwain

did you reboot the server after installing the drivers?

Have you tried the odbc driver?[/url]

When there was sql server 2005

I meant, perhaps the windows logs (eventvwr) mentions why it couldn't write to the error logs.

SQL_Latin1_General_CP1_CI_AS isn't really an unicode character set. So it is possible that it displays Korean differently when connecting with another client.

Perhaps a difference on the client side

Unicode compatiblity

A note on...

Windows logs?

Statistics out of date?