SqlDbx Forum

Brian61

Member

datetimes not displaying (v3.48 personal edition)

Just installed v3.48 personal edition.  First time user.  When I view tables with a datetime column or just do a SELECT GETDATE(), I see no data.  It's not NULL,  it's just blank.  Using MS SQL SMS I see the datetime data just fine.  Any ideas?

Brian

sqldbxhelp

Administrator

Re: datetimes not displaying (v3.48 personal edition)

Are you connecting through ODBC or native?
What version of Sql Server?
You can try to change the order of drivers in Options->Servers->Microsoft.

Brian61

Member

Re: datetimes not displaying (v3.48 personal edition)

I would assume it's a native connection to SQL Server 2008 R2 (10.50.1600.1).  I'm not using an ODBC DSN.

sqldbxhelp

Administrator

Re: datetimes not displaying (v3.48 personal edition)

We would be interested to know what version of Sql Server drivers you have installed.
Can you go to Tools->"ODBC Administrator" and check driver versions for SQL Server and SQL Server Native Client

mcrownover

Member

Re: datetimes not displaying (v3.48 personal edition)

I am having the same problem, however I am running V3.49 personal edition

I am running on windows 7 pro 64-bit, with ms sql server 2008 r2 version 10.50.1600.1

I am running with the native SQL client

ODBC SQL Server version 6.01.7600.16385
ODBC SQL Server Native Client 10.0  Version 2009.100.1600.01

mcrownover

Member

Re: datetimes not displaying (v3.48 personal edition)

Update... I changed the order of my servers in Tools->Options->Servers->Microsoft.  I put SQL Server as the first driver and the dates are displaying now.