datetime coulumn displaty problem over MSSQL gateway

[demirlero]

Hi;
We have some problems with displaying datetime data over gateway,
if i run query like this

SELECT DatetimeColumn
FROM "dbo"."TableName"@"DatabaseName"@"Gateway"
Result like
"Color=65535Visible=1Objects=Name=ProceduresNumber=4Type=0...."

But
SELECT CAST(DatetimeColumn AS DATE)
FROM "dbo"."TableName"@"DatabaseName"@"Gateway"
displays correct results.

Is this known bug or should I change some settings in my PL/SQL developer. I am using 7.1 version and SQL+ worksheet returns correct results for both queries.
Thanks for your help
Ongun

 

[Marco Kalter]

I assume the gateway should provide result sets that are transparent to the client. I have no idea why this strange text appears.

 

[demirlero]

I add a screen shot of the problem as well, it seems like some problem on client side.

 

[pmadzik]

Hello,

I have similar problem with gateways to mssql (dg4msql, dg4odbc):

In sqlplus:
------------------------------------------------------------------
SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

Session altered.

SQL> select datetime_col from tab@dg4msql;

DATETIME_COL
-------------------
2011-01-24 09:28:54

SQL> select datetime_col from tab@dg4odbc;

DATETIME_COL
-------------------
2011-01-24 09:28:54
---------------------------------------------------------------------

In PL/SQL Developer (SQL Window) above statements cause same effect in result grid: instead of normal date output it shows strange characters similar to binary dump.

And in PL/SQL Developer (Command Window):
---------------------------------------------------------------------
SQL> select datetime_col from tab@dg4odbc;

DATETIME_COL
------------
xo
7
---------------------------------------------------------------------

Regards,
PM