 |
|
|
 |
|
|
 |
|
|
 |
|
 |
Simple and straightforward. I'll be using this all the time.
I have only used/tested the basic backup/restore functionality but I've had no problems so far.
Installation might be improved a bit but that's an observation, not a bug.
For your own feedback: - XP Pro - SQL Server 2005 Express
Thanks again for your efforts and sharing.
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
 |
This message appear in the status colunm in the grid: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_Staff_UserType". The conflict occurred in database "Database", table "dbo.Staff", column 'UserTypeId'. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
How can i resolve this Problem please. and thanks
|
| Sign In·View Thread·PermaLink | 1.00/5 |
|
|
|
 |
|
|
 |
|
|
 |
|
 |
hello. when i want to backup a database by this project(Database Backup) it gives some Errors. when it perform this line: db.Tables.Item(sTablesName).ExportData() it give exeption Error :"[Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supported by SQL Server [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations" please tell me what is it and what am i resolve this problem.
|
| Sign In·View Thread·PermaLink | 1.50/5 |
|
|
|
 |
|
|
 |
|
 |
Doesn\'t work with vista. It gives error saying it has stopped working as soon as I hit backup.
It connects fine to the server and displays tables and other objects but cant backup. thanks for any input.
|
| Sign In·View Thread·PermaLink | 5.00/5 |
|
|
|
 |
|
|
 |
|
|
 |
|
 |
You need to select tables that you want to backup. When you restore, same rule applies.
There is a little bug in this program. Sometimes it can not create new database. What you should do is create database manualy in Enterprise manager. And restore database without Create New Database option.
Shabdar
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
 |
I've checked everything, on backup and on restore, the database gets created, so that's working OK.
The program even says that all the tables are created, but the tables were the data has to be restored, give an error (that the table isn't there).
Will try and test it like you described.
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
 |
I want to backup and restore all tables content only. Is it possible to do it without sqldmo library. I don't want to use sqldmo.
|
| Sign In·View Thread·PermaLink | 2.00/5 |
|
|
|
 |
|
 |
hi frndz i m using dataset to insert row in ms access table... it is working fine but when m redebugging the program and inserting the new row old row get deleted and new entery remains..... alse if i m filling the dataadapter with data set old row get deleted... but when i m making setup of my application and rumming it after installation this problem is not there and everything working fine.... i m using vb.net 2005 does any one has solution 4 this.. well thanx in advance
gaurav kumar jaiswal
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
 |
hi i tink your problem is this: for example
objcommand.CommandText = "UPDATE UNIT SET [unitName] =@UnitName WHERE unitID=@unitID"
[ ] is very important in sql string when use access database
bye
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
 |
how to make my login form like windows login form ? in vb ,every form has the title in top of the form (the blue on top of each form) i mean how to remove it ,create a form without it
freedom!
|
| Sign In·View Thread·PermaLink | 1.50/5 |
|
|
|
 |
|
|
 |
|
 |
hello. when i want to backup a database by this project(Database Backup) it gives some Errors. when it perform this line: db.Tables.Item(sTablesName).ExportData() it give exeption Error :"[Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supported by SQL Server [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations" please tell me what is it and what am i resolve this problem.
|
| Sign In·View Thread·PermaLink | 3.50/5 |
|
|
|
 |
|
 |
hi anahita_m, Now i am facing same problem which you posted. Have you got any solution for this? Please reply me.
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |
|
|
 |
|
 |
How can I handle the table creation order because it doesn't creates the table if there is an error of this kind, do you have a solution for this??
Foreign key 'FK__tests__3E49B918' references invalid table 'grades'. Could not create constraint. See previous errors.
Thank you for your help!
|
| Sign In·View Thread·PermaLink | 2.00/5 |
|
|
|
 |
|
|
 |
|
 |
main database is giving error doesnt work would you please tell me the cause of this error?
"exception of type system.outofmemoryexception was thrown"
|
| Sign In·View Thread·PermaLink | |
|
|
|
 |