RE: Upsizing a VFP 8.0 database
From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: Mon, 09 Aug 2004 21:54:08 GMT
Do you know what record in the table causes the problem? If you upsize the
tables in either the VFP8\samples or VFP8\Data folders, do you get a
What version of SQL Server are you using? What compatibility level is SQL
Server running when you run the Upsizing wizard?
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft FoxPro Technical Support
*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
Purchase VFP8 here:
Keep an eye on the product lifecycle for Visual FoxPro here:
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>I get an error after I upsized an VFP database, then try to append
>from a VFP table to the SQL Server. Its an SQL error which states as
>Connectivity error: conversion of char data type to datetime data type
>resulted in an out-of-range datetime value.
>Now there is only one field that is a datetime in the SQL table and
>only one field in the VFP table which is a date field. I have tried
>changing that field in the VFP table to a datetime data type but still
>get that error.
>The results from aerror() are as follows.
>? aerror(1) = 1526
>aerror(4) = 22008
>aerror(5) = 242
>aerror(6) = 1
>anyone have any clue where the problem is? or what else would you need
>to see to help me with this problem