Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error retrieving datetime from SQL
Message
 
To
04/03/2010 11:13:34
Melvin Sequera
M&H New World, C.A.
Fuenlabrada, Spain
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01452511
Message ID:
01452626
Views:
32
Different timezones? Or are the Access and SQL databases in the same machine?

>Good afternoon, right now I'm writing an app in MS Access that connects to SQL Server through ODBC.
>
>The problem that I'm having is when I retrieve the data from a datetime field, it's always 1 hour back in Access.
>
>Honestly I've think that the problem is related to some kind of config in the odbc driver setup, but I can't find the way to solve it.
>
>Thanks in advance for yout help.
>
>Melvin
Ricardo A. Parodi
eSolar, Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform