>>>>Hi
>>>>When i connect to a SQL Server DB, either with the Database Explorer or through sqlstringconnect, all the DATE fields figure in VFP as numbers.
>>>>For instance, March 18, 2005 comes as 9051840
>>>>What did i do wrong?
>>>>
>>>>Thanks
>>>>Jaime
>>>
>>>What driver you're using to get them from SQL Server (e.g. show your connection string).
>>>
>>>I believe some drivers do not recognize new DATE fields at all.
>>>
>>>Would you be able to use datetime column instead or you must use DATE?
>>>
>>>Can you search VFP forum for that problem (it was discussed in the past but I don't recall exact solution)?
>>
>>Hey Naomi :-)
>>Thanks for your fast reply.
>>Using the following connection string:
>>Handle = SQLStringConnect ( "driver={SQL Server};server=myServer;database=myDB;pwd=myPass;uid=myUser;")
>>I also am thinking it's a driver issue, hence my coming here, to see if i can tweak the current one or use a different one.
>>I cannot modify the SQL DB it's an external application...
>>
>>Jaime
>
>Try with the newer driver. If I remember correctly, the newest driver works with DATE type, but has problems with varchar(max). The oldest driver works with varchar(max) but doesn't work with DATE type.
Where can i find that driver?
Why do programs stop working correctly as soon as you leave the Fox?