vfp dbf to sql server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: vfp dbf to sql server

  1. #1
    Don Guest

    vfp dbf to sql server


    hello,

    I'm very new to this. I'm using sql server 2000, I have a
    visual fox pro dbf file. I would like to transfer it into sql
    server 2000. I tried using the import wizard in sql server,

    I've selected:

    source data: Microsoft visual fox pro driver.
    DSN: selected the visual Fox Pro Database.
    even tried creating my own DSN

    Result: DTS-Import/Export wizard error:

    - Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
    - Context: Error during initialization of the provider.

    I've tried to fix the error but I don't know where I've gone
    wrong. I was wondering if anyone could give me some tips or advice. Any ideas
    would be greatly appreciated.

    Thank you
    Don


  2. #2
    Fred Taylor Guest

    Re: vfp dbf to sql server

    Try using the upsizing wizard in VFP.

    --
    Fred


    "Don" <donnywong@sympatico.ca> wrote in message
    news:3a1bffb3$1@news.devx.com...
    >
    > hello,
    >
    > I'm very new to this. I'm using sql server 2000, I have a
    > visual fox pro dbf file. I would like to transfer it into sql
    > server 2000. I tried using the import wizard in sql server,
    >
    > I've selected:
    >
    > source data: Microsoft visual fox pro driver.
    > DSN: selected the visual Fox Pro Database.
    > even tried creating my own DSN
    >
    > Result: DTS-Import/Export wizard error:
    >
    > - Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
    > - Context: Error during initialization of the provider.
    >
    > I've tried to fix the error but I don't know where I've gone
    > wrong. I was wondering if anyone could give me some tips or advice. Any

    ideas
    > would be greatly appreciated.
    >
    > Thank you
    > Don
    >




  3. #3
    Don Guest

    Re: vfp dbf to sql server


    hello Fred,

    Thank you for your advice, I really appreciate it. I've tried
    a few of the tables already and it seems to work fine. I'm still
    looking into it.

    Thanks
    Don


    "Fred Taylor" <ftaylor@qwest.net> wrote:
    >Try using the upsizing wizard in VFP.
    >
    >--
    >Fred
    >
    >
    >"Don" <donnywong@sympatico.ca> wrote in message
    >news:3a1bffb3$1@news.devx.com...
    >>
    >> hello,
    >>
    >> I'm very new to this. I'm using sql server 2000, I have a
    >> visual fox pro dbf file. I would like to transfer it into sql
    >> server 2000. I tried using the import wizard in sql server,
    >>
    >> I've selected:
    >>
    >> source data: Microsoft visual fox pro driver.
    >> DSN: selected the visual Fox Pro Database.
    >> even tried creating my own DSN
    >>
    >> Result: DTS-Import/Export wizard error:
    >>
    >> - Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
    >> - Context: Error during initialization of the provider.
    >>
    >> I've tried to fix the error but I don't know where I've gone
    >> wrong. I was wondering if anyone could give me some tips or advice. Any

    >ideas
    >> would be greatly appreciated.
    >>
    >> Thank you
    >> Don
    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center