RE: SQL "Linked Server" to FoxPro problem

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 04:57:06 -0800

Hi

Check that the records after the first 1000 have a valid date that is
convertable to the SQL Server date data type.

Regards
Mike

"James Thompson" wrote:

> If I select more than 1000 record from my FoxPro 5.0 database using
> Query Analyzer or Enterprise Manager I get the following message: "Error
> converting data type DBTYPE_DBDATE to datetime"
>
> This is configured as a "Linked Server"
>
> Please Help
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

Relevant Pages

  • Re: Multiple-step operation generated error
    ... I tried assigning the value directly with the data type it expects, ... One interesting fact is that the same code is working for Oracle, but for SQL Server it is giving this problem. ... Thanks & Regards, ...
    (microsoft.public.data.ado)
  • Re: Access 97 to SQL
    ... The timestamp is a data type, ... the timestamp field does not need to be part of the SELECT ... > converted the Access tables to a SQL Server 2000 database and linked the ... > the way I set up Autonumbering in SQL? ...
    (microsoft.public.access.externaldata)
  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: Update string too long?
    ... search through the newsgroups, as wells as google.com for the web. ... Pro SQL Server 2000 Database Design - ... Beginner posts are the most helpful and it is ... what is the data type and length for the ...
    (microsoft.public.sqlserver.programming)
  • Re: How Can I Write a SQL Server Function that Returns a Memo Data Type in Access?
    ... When I use the function in a view and link to the view through ODBC, ... Text data type. ... LONGTEXT, LONGCHAR, MEMO, and NOTE aren't recognized by SQL Server. ...
    (comp.databases.ms-access)