>>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
Why do programs stop working correctly as soon as you leave the Fox?