I'm sorry to bother everyone again about this subject, but I'm stuck...

We have a MS SQL Server 2012 and VFP9. We want to use varchars in SQL Server and have them come down to VFP9 as varchars, but the best I can do is they come down as character and not varchar.

I'm pretty sure I've done this successfully at my last job where we only had MSSQL 2008.

Here are my various connection string efforts:

?sqlstringconnect("Driver={SQL Server};Server=.;Database=jeff;Trusted_Connection=yes;")
?sqlstringconnect("Driver={SQL Server Native Client 10.0};Server=.;Database=jeff;Trusted_Connection=yes;")
?sqlstringconnect("Driver={SQL Server Native Client 11.0};Server=.;Database=jeff;Trusted_Connection=yes;")

And I select * from a table in my db that has one Id field and one varchar field. But, as I said before, they are fat padded characters in VFP9. I've also set varcharmapping on.

Help!