SQL "Linked Server" to FoxPro problem

From: James Thompson (jwegge_at_cox.net)
Date: 02/03/05 

Date: Thu, 03 Feb 2005 09:45:21 -0800

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: WinForms connect to Hosted Database?
    ... This particular host gives the IP address for the database. ... connect my Query Analyzer and Enterprise Manager to it as well via IP. ... Most virtual hosting firewalls are setup to block outside ...
    (microsoft.public.dotnet.framework.windowsforms)
  • sql server table permissions question
    ... I have a SQL Server 2000 database. ... When I create tables in query analyzer or ... another tool the new table appears in enterprise manager under the table ... When I go to the Users tab and click on a user and open up the properties ...
    (microsoft.public.sqlserver.security)
  • security table in sqlserver 2000
    ... If you take away query analyzer and Enterprise Manager, ... >I have a table in a database of sqlserver 2000. ... links to ASP & ASP.NET resources... ...
    (microsoft.public.sqlserver.security)
  • Re: How to move tables between databases
    ... Use Enterprise Manager or Query Analyzer to create a CREATE TABLE script for ... Create the table in the appropriate database. ...
    (microsoft.public.sqlserver.server)
  • Re: login security question
    ... Say the password for the Application role is found, can a user access the database through the ... Query Analyser or Enterprise Manager using the application rolde/password.>> ... The user name, however, will be the app role name. ...
    (microsoft.public.sqlserver.server)