Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error retrieving datetime from SQL
Message
 
À
04/03/2010 11:13:34
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Application:
Desktop
Divers
Thread ID:
01452511
Message ID:
01452626
Vues:
33
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform