General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
Thanks Brandon. This is good to know. I'm not using varchar or varchar(max) in the app that has this issue, so this should work.
I was just experimenting with the native client 10 the other day... comparing performance with the regular ODBC client.... didn't find any differences.
>>I read that the date data type was added to sql server in server 2008. For the following statement:
>>
>>lnr=sqlexec(lnh,"select cast(dt_date as date) as date_ from activity","curactivity")
>>
>>dt_date is a datetime data type. In the cursor curactivity, date_ become character (10), not vfp's data type date.
>>Is there anyway to directly convert this this vfp's date datatype?
>
>For ms-sql 2008 date types to work with VFP via SPT you must use SQL Server Native Client 10.0 ODBC. The downside is that varchar(max) is not supported, you have to use TEXT fields.
Previous
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