Cannot Install DB

Hi,
I have installed the latest MSDE and am entering the following text in the
query analyzer:
EXEC sp_attach_db @.dbname = 'SRPA',
@.filename1 = '{c:\SRPA\SRPA.MDF}',
@.filename2 = '{c:\SPRA\SRPA.LDF}';
but i'm getting the following error:
Error: Device activation error. The physical file name 'c:\SRPA\SRPA.MDF'
may be incorrect.
I have checked and double checked the name/location etc and it all matches..
any help would be greatly appreciated, Thanks
Matt
You dont need these curly brackets. Just type in (as filename is expecting
a nvarchar)
EXEC sp_attach_db @.dbname = 'SRPA',
@.filename1 = N'c:\SRPA\SRPA.MDF',
@.filename2 = N'c:\SPRA\SRPA.LDF'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:C7340567-DD95-4534-A75E-0583F630E6E0@.microsoft.com...
> Hi,
> I have installed the latest MSDE and am entering the following text in the
> query analyzer:
> EXEC sp_attach_db @.dbname = 'SRPA',
> @.filename1 = '{c:\SRPA\SRPA.MDF}',
> @.filename2 = '{c:\SPRA\SRPA.LDF}';
> but i'm getting the following error:
> Error: Device activation error. The physical file name 'c:\SRPA\SRPA.MDF'
> may be incorrect.
> I have checked and double checked the name/location etc and it all
> matches..
> any help would be greatly appreciated, Thanks
> Matt
>
|||Thanks, Tried it but still the same error.
"Jens Sü?meyer" wrote:

> You don′t need these curly brackets. Just type in (as filename is expecting
> a nvarchar)
> EXEC sp_attach_db @.dbname = 'SRPA',
> @.filename1 = N'c:\SRPA\SRPA.MDF',
> @.filename2 = N'c:\SPRA\SRPA.LDF'
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:C7340567-DD95-4534-A75E-0583F630E6E0@.microsoft.com...
>
>
|||Just a moment, i saw that you are using the QA ?!
So perhaps you are not connected to the MSDE rathjer than to a SQL Server.
If you issue the command
sp_Attach_db the SQL Server / MSDE will always look on Local drives to get
control over the datafile. So if you are connected to a remote server rather
than to the MSDE it will tell you that the files are not present.
If you really want to make sure that you are working on the MSDE, just do
this on the command line:
OSQL -E (if you are using Integrated Security, if not
use -UUsername -PPassword)
Then type in the Command i gave you in the last post, that should really
help, if not there MUST be a difference in the location you specified.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0206A4CE-541A-4CA8-B5A6-5213E982D1EC@.microsoft.com...[vbcol=seagreen]
> Thanks, Tried it but still the same error.
>
> "Jens Smeyer" wrote:
|||Thats got it..with the OSQL -E it worked fine thru cmd.. Thanks for your help
"Jens Sü?meyer" wrote:

> Just a moment, i saw that you are using the QA ?!
> So perhaps you are not connected to the MSDE rathjer than to a SQL Server.
> If you issue the command
> sp_Attach_db the SQL Server / MSDE will always look on Local drives to get
> control over the datafile. So if you are connected to a remote server rather
> than to the MSDE it will tell you that the files are not present.
> If you really want to make sure that you are working on the MSDE, just do
> this on the command line:
> OSQL -E (if you are using Integrated Security, if not
> use -UUsername -PPassword)
> Then type in the Command i gave you in the last post, that should really
> help, if not there MUST be a difference in the location you specified.
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0206A4CE-541A-4CA8-B5A6-5213E982D1EC@.microsoft.com...
>
>

Cannot find module in web data administrator

I just downloaded the web data administrator from MSDN and after entering my credential, I get this error:

Specified module cannot be found
at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

The only page I can see is the Import page, the database and the export get the same error.
It's a fresh install, anyone know something I need to do to get a correct install ?Since I had not yet downloaded and installed the Web Data Administrator, I went just now and installed it from Microsoftlink

I just clicked on Download, chose "Open" and just left whatever defaults there might have been. I went into SQL Server and changed the authentication mode to mixed. Then I went to http://localhost/sqlwebadmin/default.aspx and logged in with my sa login and password. It all worked like a charm.

Not sure what help any of that is...

Terri|||I tried doing another clean install, but I get the same problem.

I can login just fine, but after leaving default.aspx, I get the error in the 2 other pages.

Without better error description I fear I won't be able to find the bug in all this code, more so if it work on other machines.

Here is the code of the Connect Method from where the error seem to be coming:

 dmoServer = (NativeMethods.ISqlServer)new NativeMethods.SqlServer();
 dmoServer.Connect(Name, Username, Password);

I have no idea what's this NativeMethods thing is coming from. I'm using MSDE, could that be the problem ?