Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VARCHAR problem with SQL Server 2003
Message
From
13/09/2012 08:53:42
Jörg Schneider
Kandel, Germany
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: VARCHAR problem with SQL Server 2003
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01504092
Message ID:
01552837
Views:
38
Hi!

>What is your connection string? With the latest SQL Server driver you'll get this problem.
I've tested all Versions of the SQL Native Clients (2005, 2008 and 2012) an in all these Versions the varchar(max) Memos from the SQLExec Command get the lengh 0.

Only with the SQL 2000 Driver it works. Bud with the SQL2000 Driver there a some other Problems...

Any suggestions?
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform