Welcome, Guest
Username: Password: Remember me
Ask Visual Basic.Net related questions here

TOPIC: Discuss SQL Server backup utility using VB.Net

Discuss SQL Server backup utility using VB.Net 6 years 7 months ago #17

  • shabdar
  • shabdar's Avatar
  • OFFLINE
  • Administrator
  • Posts: 79
  • Thank you received: 14
  • Karma: 7
Discuss SQL Server backup utility using VB.Net here. Click Reply button below.
The administrator has disabled public write access.

Re: Discuss SQL Server backup utility using VB.Net 6 years 6 months ago #45

  • Weding
  • Weding's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
This utility is splendid! I really liked it on my Windows XP, where it worked without any problems.
BUT: When I now have upraded my hardware, and bought a new PC, installed with 64-bits Windows 7 the program starts up, and when I click on Tools -> Database Export it stops; The problem seems to be clsScript.vb where all references to SQLDMO fails. "Cannot get COM-classfabric for component CLSID(.....), error 80040154. The Interop.SQLDMO.dll file is in my Bin-folder (as it was on my XP-computer...). How can this code run under 64-bits Win 7?
The administrator has disabled public write access.

Re: Discuss SQL Server backup utility using VB.Net 6 years 6 months ago #46

  • shabdar
  • shabdar's Avatar
  • OFFLINE
  • Administrator
  • Posts: 79
  • Thank you received: 14
  • Karma: 7
Weding wrote:
This utility is splendid! I really liked it on my Windows XP, where it worked without any problems.
BUT: When I now have upraded my hardware, and bought a new PC, installed with 64-bits Windows 7 the program starts up, and when I click on Tools -> Database Export it stops; The problem seems to be clsScript.vb where all references to SQLDMO fails. "Cannot get COM-classfabric for component CLSID(.....), error 80040154. The Interop.SQLDMO.dll file is in my Bin-folder (as it was on my XP-computer...). How can this code run under 64-bits Win 7?

Hi,
Make sure that you have installed SQL Server Client components on your laptop. i.e. SQL Server Management Studio or Enterprise Manager if you are using older version of SQL Server. SQL-DMO library is part of client components. If they are not installed, you may get this error. For more information see below article,

http://msdn.microsoft.com/en-us/library/aa274817%28v=sql.80%29.aspx

Once you install client components, add reference to Sqldmo.dll again.
Last Edit: 6 years 6 months ago by shabdar.
The administrator has disabled public write access.

SQL Server backup utility using VB.Net 6 years 5 months ago #78

  • petebob796
  • petebob796's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 1
  • Karma: 0
This tool looks great but I seem to have a problem with it.

One of our tables has spaces in the column names if I export this table and then import later the table is created correctly but when attempting to import the data it crashes out with an import error. I guess because the column names somewhere have not been surrounded with [] brackets. Hopefully this is an easy fix.
The administrator has disabled public write access.
The following user(s) said Thank You: shabdar

Re: SQL Server backup utility using VB.Net 6 years 4 months ago #89

  • shabdar
  • shabdar's Avatar
  • OFFLINE
  • Administrator
  • Posts: 79
  • Thank you received: 14
  • Karma: 7
Hi

Thanks for reporting this issue. I have fixed it in new version, you can download it.
The administrator has disabled public write access.

Re: Discuss SQL Server backup utility using VB.Net 6 years 4 months ago #111

  • JK123
  • JK123's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi, Please help me out, Is there any option to joining mltiple tables in the same database ? I would be very happy if you reply me asap.
The administrator has disabled public write access.

Re: Discuss SQL Server backup utility using VB.Net 6 years 4 months ago #113

can i use this application for sql server 2008 backup and restore ?
and i have a trouble when try to run this application.

my computer spesification
- Win 7 x86
- Sql server 2008 R2

please give me the best solution, thank you :)
Attachments:
The administrator has disabled public write access.

Re: Discuss SQL Server backup utility using VB.Net 5 years 10 months ago #184

  • vishnu101
  • vishnu101's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
hello sir , i just download backup utility , but while running the project it asking Present , user name , password , and database name ?

please guide me how to take backup and restore the database and where the concept multithreading have been used ?
The administrator has disabled public write access.
Time to create page: 0.105 seconds