Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2008
>>I've been asking this question for awhile now and have yet to receive any good answers.
>>
>>So, now I've finally installed SQL2008 on my machine and I built a table and used the new DATE datatype.
>>
>>In VFP I ODBC'd the table down and GUESS WHAT?
>>
>>Right! Exactly!
>>
>>The DATE datatype gets brought down to VFP as, wait for drum roll... A FREAKING VARCHAR.
>>
>>A VARCHAR!
>>
>>It's a GD VARCHAR.
>>
>>Boyz, we are screwed now. I'm running VFP 9 SP2, so there's nowhere to go to get this one fixed.
>
>Jeff,
>I have missed your question particularly but I have posted various times to various forums that it is the fault of VFP not to interpret return values right. Use SQLNCLI10 and you should be good to go. If you use ODBC driver (SQL Native Client 10.0) then you get the date right but fail on some other new types like xml, varchar(max). Best driver is SQLNCLI10 IMHO. If you use it along with a cursoradapter you wouldn't have problems.
>Cetin
Cetin,
Can you post the exact connection string that you use? I can't make it work with "SQLNCLI10".
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement