What are the challenges you face when working across database platforms? Take the survey
Options

Failed to initialize local data store: Invalid class string

laurencerookslaurencerooks Posts: 28
edited June 5, 2007 9:30PM in SQL Backup Previous Versions
SQL Backup Professional v5.0 and v5.1 just won't play nice with me. Okay. I have a Windows 2003 Server with Service Pack 2 and a proper installation of the .NET 2.0 Framework. I have successfully installed SQL Backup Professional v5.1. I have successfully launched the application. I can't get a connection to the server due to the following error:

Failed to initialize local data store: Invalid class string

I've done a search for this and come back with nothing. Can someone please help?

Laurence

Comments

  • Options
    peteypetey Posts: 2,358 New member
    When you run a test backup manually e.g.

    EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [<AUTO>]"'

    does the backup complete successfully? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    I was able to successfully create a SQL Backup of the model database with the command given. Why am I not able to connect via the GUI console so I can activate the license and manage it?

    Laurence
  • Options
    peteypetey Posts: 2,358 New member
    The error message 'Failed to initialize local data store: Invalid class string' indicates that the SQL Server Compact Edition (SSCE) files have not been copied/registered on the server. However, the test backup that you created seems to indicate the opposite. If the SSCE files were not available, you would have received a warning similar to the following:

    Warning 402: Failed to open local data store: Invalid class string

    The backup would have still succeeded, but information regarding the backup would not have been stored in SQL Backups' local database.

    Could you pls confirm that the test backup succeeded without any warnings or errors? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Petey,

    We are using SQL Server 2000 Standard Edition with SP4 on Windows Server 2003 with SP2. We are not using SQL Server Compact Edition. I did not receive any warning or error message during the test backup.
  • Options
    peteypetey Posts: 2,358 New member
    What I meant to say was that SQL Backup 5 stores its own data on backups and restores that it performs. It stores this in a SQL Server Compact database. The runtime files for the Compact database is usually installed together with the server components. It is this database that is referred to as the 'local data store' in the error messages. I apologise for not making this clear.

    When you register a server in the version 5 GUI, it checks if the SQL Backup extended stored procedure are installed. If so, then then calls the sqbdata extended stored procedure to retrieve data from the 'local data store'. I am assuming that it is at this point that the error message you mentioned should have been raised, if the Compact files have not been property copied/registered.

    Perhaps I am making the wrong assumptions about your scenario. Could you provide a screenshot of the error that is happenning in the SQL Backup GUI? You can send it to me via email. Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    peteypetey Posts: 2,358 New member
    The cause of the error was because the SQL Server Compact Edition COM interface was not registered. While the files were installed on Laurences' server, they were not registered for some reason. Manually registering the interface allowed the GUI to connect to the server successfully. The file to register is named sqlceoledb30.dll.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.