Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VARCHAR problem with SQL Server 2003
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
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:
01504102
Views:
62
>I understand the not being fixed part been doing VFP exclusively since 2004.
>
>I don't understand the was working now is not part and is fine in production part, as well as the command prompt part. Command prompt part =s the following steps
>
>1) Start a VFP session
>2) run the app see the problem in Debug using browse immediately after the cursor is returned.
>3) kill the debugging process (remain in same vfp session)
>4) at the command prompt run a prg that creates a SQL Server Connection exactly as the application does
>5) run the SQL Select with success.
>
>Its all happening on 2003 servers with SQL 2003 NOT 2005.
>
>Not so sure your response on this bug fits here. Thanks though good to know

There's no such thing as MS SQL Server 2003. See http://www.berezniker.com/content/pages/sql/microsoft-sql-server/retrieving-sql-server-edition-version-and-service-pack-info
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform