User Profile

Collapse

Profile Sidebar

Collapse
smoi
smoi
Last Activity: May 18 '07, 12:22 AM
Joined: Feb 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • smoi
    replied to SQL Server 2000 Backup and Restore, Need help!
    in SQL Server
    Now I got a new error message saying "Server: Msg 2774, Level 16, State 1, Line 2 Collation ID 49 is not valid."

    Can anyone please let me know how to proceed the restoration without having problem for collation ID and media type or media set???...
    See more | Go to post

      Leave a comment:

    • smoi
      replied to SQL Server 2000 Backup and Restore, Need help!
      in SQL Server
      If it doesn't matter where the backup is taken from but now it still doesn't work... I still don't understand what happen???
      See more | Go to post

        Leave a comment:

      • smoi
        replied to SQL Server 2000 Backup and Restore, Need help!
        in SQL Server
        Hi Steve,

        I'm using MS SQL Server 2000, when I backup, I choose to backup in a file as BAK file, not onto the tape. Same like when I do restore, I select From Device and choose the filename.

        I think I got some idea about the media set error message... Please correct me if I'm wrong... Does that mean during the time when I do backup, the backup BAK file take note of the harddisk as well??? Since I restore by copying the...
        See more | Go to post

          Leave a comment:

        • smoi
          started a topic SQL Server 2000 Backup and Restore, Need help!
          in SQL Server

          SQL Server 2000 Backup and Restore, Need help!

          Hi all,

          My manager ask me to do backup for 3 database and restore them in a new server.

          I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the following:

          1. Microsoft SQL-DMO (ODBC SQLState: 4200) The media family...
          See more | Go to post
          • smoi
            started a topic Compile Error: Procedure declaration does not match description of event...
            in Visual Basic

            Compile Error: Procedure declaration does not match description of event...

            I have two listbox in my Form, one call lstFolders, the other one call lstFiles.

            I have the functions below:

            Code:
            Private Sub lstFolders_DblClick()
     'Call FunctionToListFilesInThisFolder
End Sub


Private Sub lstFiles_DblClick()
    'Append the filename selected into a textbox
End Sub

            When I run my program, it says:

            Compile Error:...
            See more | Go to post
            Last edited by willakawill; Feb 8 '07, 08:41 AM. Reason: please use code tags when posting code
            • smoi
              started a topic Error Opening a Table in MS SQL Server
              in Visual Basic

              Error Opening a Table in MS SQL Server

              Hello... I need help with the error I encounter when I tried to open a Table in MS SQL Server. I have the following code in VB6.


              Code:
              Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
rs.open "TableName", adoConn, adOpenKeyset, adLockOptimistic

              where adoConn is my Connection to the Ms SQL Server Database.


              The error is:
              -2147217900 The request...
              See more | Go to post
              Last edited by willakawill; Feb 7 '07, 01:01 AM. Reason: please use code tags when posting code
              No activity results to display
              Show More
              Working...