Re: [Error]Import data from vfp to sql server !

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Agnes (agnes_at_dynamictech.com.hk)
Date: 05/12/04 

Date: Wed, 12 May 2004 22:07:35 +0800

I am using ODBC, for another small database( got 10 tables) , i am import
succesfully, now for a bigger database( 30 tables, some tables got over
10,000 records) it seems fail.
Please help.
>From Agnes

"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> ¦b¶l¥ó
news:eFqsvxAOEHA.3672@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
> Hello, Agnes!
> You wrote on Wed, 12 May 2004 18:20:39 +0800:
>
> A> i have one database which got 30 tables,
> A> I want to import these data into sql server,
> A> I found that during "import ", there are Error occured, why ?
> A> Moreover, for one specific tables, the sql server seems 'hangs", i had
> A> wait over 3 hrs.
> A> the process seems held or dead , I need to use task manager to end up
it
> A> . Does anything wrong in my tables ??
>
> How are you sending the VFP data to SQL? Are you using the SQL "DTS
> Import/Export" tool? Are you using ODBC or OLEDB?
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>

Relevant Pages

  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)