Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Sever varchar and SPT
Message
From
29/12/2008 11:51:29
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01369877
Message ID:
01369951
Views:
13
Sergey--

>
>What is the version of SQL Server ODBC Driver you're using? Make sure that you're using SQL Server Native Client.


We are using the SQL Server Native Client. I am fairly certain I downloaded it from Microsoft in November

Varchar (max) is the problem. There is a varchar (75) field in another table and it comes down from SQL Server using SPT just fine. In the SQL Server SELECT I did a CAST of the varchar (max) field to a char (8000) and it came down through SPT as a memo field. We can probably live with that as a work-around. It would be nice not to have a work-around.

Any more thoughts?


Tim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform