SqlDbx
You are not logged in.
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
Offline
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.
Offline
I would assume it's a native connection to SQL Server 2008 R2 (10.50.1600.1). I'm not using an ODBC DSN.
Offline
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
Offline
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
Offline
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.
Offline