472,952 Members | 2,143 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,952 software developers and data experts.

Data Import and Export Wizard Error.

I use SQLNameSapce to load SqlServer2000's Data Import and Export Wizard in VB.NET. The Wizard is running normally,but when I click the next button,Nothing Happened.
The CODE
......
Dim lvODatabase As SQLNS.SQLNamespaceObject = Me.mvSQLNs.GetSQLNamespaceObject(lvHDatabase
If lvODatabase Is Nothing Then Exit Su

lvODatabase.ExecuteCommandByID(SQLNS.SQLNSCommandI D.SQLNS_CmdID_DTS_EXPORT, Me.Handle.ToInt32, SQLNS.SQLNSModality.SQLNamespace_PreferModal
......

If I us
"lvODatabase.ExecuteCommandByID(SQLNS.SQLNSCommand ID.SQLNS_CmdID_DATABASE_BACKUP, Me.Handle.ToInt32, SQLNS.SQLNSModality.SQLNamespace_PreferModal)
instead o
"lvODatabase.ExecuteCommandByID(SQLNS.SQLNSCommand ID.SQLNS_CmdID_DTS_EXPORT, Me.Handle.ToInt32, SQLNS.SQLNSModality.SQLNamespace_PreferModal)

Database Backup Wizard run normally
Why? anyone can help me

Nov 20 '05 #1
0 1001

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Benny | last post by:
Dear All, I am performing a data import on the SQL server. Due to fact that I use the excel file as a source. Some of cells in excel are actually empty, they become NULL fields after importing...
1
by: Ilya Bari | last post by:
Howdy! Does any of you good folk know how to change window size of the DTS Import/Export Wizard window? Darn thing is very small and inconvinient to work with, no apparent way to change it's...
4
by: rajaaryan44 | last post by:
i m using access2003 database for my Project. now i have to import data from another access database with the same table name. can any one please tell me how to import data from another access...
0
by: nofear | last post by:
I'm Importing data (Flat File) to a table using the DTS Import/Export Wizard on regular basis The Wizard does not let me save the fixed width data definition so I have to manually separate the...
2
by: Piero 'Giops' Giorgi | last post by:
Hi, all! The Criminal DB is going strong (as of today: 50 Tables, on 3077 Filegroups) Right now I stuffed in it about 2 million records (About 7% of total), but I'm constantly having an issue...
12
by: joaotsetsemoita | last post by:
Hello everyone, im completly new to vb.net and I was assigned to do a simple piece of software that just had to select from um db in a MS access data base and insert into a SQL server Database....
3
by: t8ntboy | last post by:
I am migrating data from one database to another. The process requires that I significantly modify the table and data structure. Therefore, I am exporting the data to a csv, making the adjustments...
1
by: DaveL | last post by:
Hello, I was using the Import / Export Wizard from Managment Studio 2005 -tasks -Import when towards the end you can save the package to file system or to Server, I selected To Server but dont...
0
by: Limno | last post by:
I am having data in sql server 2005, and i need to convert these data into excel sheet for verification. How can i convert this, Explan me in steps. I tried to convert that using Import and Export...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.