PMFJI, but download one of the latest MDAC (2.5/2.6) and it should be in there. Note - MDAC will update all of your ODBC drivers. However, starting in version 2.6, the VFP ODBC driver is no longer included. You have to download MDAC 2.5 to get that.

HTH.

>>>>>>>Hello everybody,
>>>>>>> I am trying to create a view from a SQL Table, I am using the view designer in 6.0 and some specific fields are truncated to a lenght shorter than the lenght specified in SQL, it is always the next field to the first numeric field in the
>>>>>>>SQL table, and is only that table, any thoughs on that ?
>>>>>>> We tried deleting the table and creating it from scratch in SQL. But the problem persists.
>>>>>>>
>>>>>>>=THIS.Thanks("in advance")
>>>>>>
>>>>>>Luis,
>>>>>>
>>>>>>Are the lengths of the fields in the backend table greater than a specific length? Or is this appearring with some fields and not others of the same length?
>>>>>
>>>>>Yes, in the back end I have Char 25 and in FoxPro it comes with Char 20.
>>>>
>>>>I just checked this out with SQL Server 7.0 (Local). I added a column named: THISISVERYLONGCOLUMNNAMETOTESTFOR (33 characters), using the view designer that comes with VFP 6.0 (SP4) I was able to create a remote view to the table. The value I posted above was obtained by issuing AFIELDS() against the cursor returned then copying the field name into the _CLIPTEXT system variable. As you can see, all 33 characters came through just fine.
>>>>
>>>>The next place to look at, I'd guess, would be the ODBC driver and version. AFAIK, 25 characters shouldn't be a problem.
>>>
>>>I am using version SQL 3.70.06.23 11/06/1998 from microsoft, what version did you used ?
>>
>>I'm using 3.70.08.20 dated 6/26/2000 from MS.
>
>I went to microsoft site and could not find anythinig newer than April 99,
>I am using Wiidows NT 4.0, could you please e-mail me the driver as your ealiest
>convenience at LGUZMAN@PDMIAMI.COM
>Thanks a lot.