HomeForum
Welcome, Guest

DEWizardX loading data into SQL Server throug OLE
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: DEWizardX loading data into SQL Server throug OLE

DEWizardX loading data into SQL Server throug OLE 1 year, 5 months ago #1303

Hell Support,


After downloading I have some questions about the ActiveX functionality :

I'm developing a win32 application using SQL Server thru OLE DB.

1. Is DEWizardX compatible with SQL Server 2005, 2008 and 2008 R2 using OLE DB ?
2. Is DEWizardX compatible with all SQL field types like VARCHAR(MAX) or XML ?
3. What's the limit of the demo version of the DEWizardX (time, functions, ...) ?
4. How to trace the evolution of the import or export ? Is there an event handling or methods like in the wizard itself without using the GUI ?

Thanks for your future answers.

Kind Regards,
Phil

Re: DEWizardX loading data into SQL Server throug OLE 1 year, 5 months ago #1304

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Phil

1. Is DEWizardX compatible with SQL Server 2005, 2008 and 2008 R2 using OLE DB ?

It is. You can load data via OleDB, ODBC and bcp into SQL Server 2000, 2005, 2008 and 2008 R2

BTW Ole Db is not the fastest way of loading the data

2. Is DEWizardX compatible with all SQL field types like VARCHAR(MAX) or XML ?

It, is

3. What's the limit of the demo version of the DEWizardX (time, functions, ...) ?

It skips first 10 records/lines

4. How to trace the evolution of the import or export ? Is there an event handling or methods like in the wizard itself without using the GUI ?

Why would you need to trace it?
There is a progress bar which shows everything + log file

Peter

Re: DEWizardX loading data into SQL Server throug OLE 1 year, 5 months ago #1305

Hi,

Thanks fro the reply.

As I will use the DEWizardX without the GUI (Wizard windows) but only internally in my application, I need to show the progression to the user. How can I do that ?

Do you have the .Net version of DEWizardX because I will move soon my application to .Net ?

Thanks for assistance,
Phil

Re: DEWizardX loading data into SQL Server throug OLE 1 year, 5 months ago #1306

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Phil

1 As I will use the DEWizardX without the GUI (Wizard windows) but only internally in my application, I need to show the progression to the user. How can I do that ?

We will add on progress event for you it will take 1-2 weeks

2 Do you have the .Net version of DEWizardX because I will move soon my application to .Net ?

Not a the moment

Peter
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"I needed to integrate and automate disparate systems running different database platforms that speak different languages, even different flavors of SQL. Visual Importer products have become that common link for me."

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top