General information
Forum:
Microsoft SQL Server
Environment versions
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".
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only