Executing Stored Procedure... Hangs...

Hi

I have a stored procedure in SQL Server 2005. It make a backup of a database and restores it to a different name.
I use ASP.NET and Framework 1.1.
It works really fine when I use SQL Server 2000.

But!
When trying to do the same thing on SQL Server 2005, the database seems to be created "half way" I can see that the database is created, but after the name is the text Restoring....
It never finish restoring.... and nothing shows in the server logs.

Any ideas?
Differences between SQL Server 2000 and SQL Server 2005 that I must be aware of?
Priviliges?
ConnectionString parameters?
Drivers?

I'm using .NET Framework 1.1
ODBC (SQL Native Client)

Here is the Store procedure code:set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 ALTER PROCEDURE [dbo].[CreateProjectDataBase]

@AFModelDatabaseProject varchar(200),

@TemplateDbBackupFileAndName varchar(200),

@DatabaseName varchar(200),

@DataFilePathAndName varchar(200),

@LogFilePathAndName varchar(200)

AS

 

BACKUP DATABASE @AFModelDatabaseProject TO DISK = @TemplateDbBackupFileAndName

WITH INIT

RESTORE DATABASE @DatabaseName FROM DISK = @TemplateDbBackupFileAndName

WITH MOVE 'AdressTNG_Project_Data' TO @DataFilePathAndName,

MOVE 'AdressTNG_Project_Log' TO @LogFilePathAndName

 

and here is how it is called from within .NET:this.odbcCreateDataBaseCommand.CommandType = System.Data.CommandType.StoredProcedure;

this.odbcCreateDataBaseCommand.Parameters["@AFModelDatabaseProject"].Value = afModelDataBaseName;this.odbcCreateDataBaseCommand.Parameters["@TemplateDbBackupFileAndName"].Value = TemplateDbBackupFileAndName;

this.odbcCreateDataBaseCommand.Parameters["@DatabaseName"].Value = dbName;this.odbcCreateDataBaseCommand.Parameters["@DataFilePathAndName"].Value = DataFilePathAndName;

this.odbcCreateDataBaseCommand.Parameters["@LogFilePathAndName"].Value = LogFilePathAndName;this.odbcCreateDataBaseCommand.CommandText = "{ CALL CreateProjectDataBase(?,?,?,?,?) }";

this.odbcCreateDataBaseCommand.ExecuteNonQuery();

Regards
Tomas