I Hope I can explain and express this well.. I'm getting tired figuring out this error. Well, Basically. I have uploaded my ASP.net website to a server (IIS installed) as well as the VB project I made.
BOTH are connecting to a DB named CLIENTS.
the website uses a datagrid to show data, while the VB Project updates the DB based on a monitored folder.
The Problem is If the website is opened first the VB project shows an error "Unable to open the physical file (MDF). Operating system error 32 (error not found)"
and Vice Versa if the VB project is first started.
It seems you connect to a SQL Server 2005 instance in SQL Server 2008 Management Studio. If you have installed SQL Server Express 2008, please make sure the SQL Server Express 2008 instance name and connect to it in SQL Server 2008 Management Studio. Try the
following steps:
1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, in the left pane, click SQL Server Services.
3. In the details pane, right-click each SQL Server, and then click Properties.
4. Go to Advanced tab, check the file version that should be 2007.100.xxxx.x.
5. Click OK to close SQL Server Configuration Manager.
6. In SQL Server 2008 Management Studio, connect to the correct server name for SQL Server 2008 instance.
Sorry for the late reply.. I've been busy for a while..
I tried executing your snippet via NEW QUERY on the management tool..
Here's what i got.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'MyDataBaseName', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
miss_just_le...
Member
42 Points
77 Posts
Unable to open the physical file. Using Asp.net Forms and VB.net Project
Oct 20, 2010 09:11 AM|LINK
Hi,
I Hope I can explain and express this well.. I'm getting tired figuring out this error. Well, Basically. I have uploaded my ASP.net website to a server (IIS installed) as well as the VB project I made.
BOTH are connecting to a DB named CLIENTS.
the website uses a datagrid to show data, while the VB Project updates the DB based on a monitored folder.
The Problem is If the website is opened first the VB project shows an error "Unable to open the physical file (MDF). Operating system error 32 (error not found)"
and Vice Versa if the VB project is first started.
Please Help.
Rajneesh Ver...
All-Star
36977 Points
6793 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Oct 20, 2010 10:11 AM|LINK
Hi,
It seems you connect to a SQL Server 2005 instance in SQL Server 2008 Management Studio. If you have installed SQL Server Express 2008, please make sure the SQL Server Express 2008 instance name and connect to it in SQL Server 2008 Management Studio. Try the following steps:
1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, in the left pane, click SQL Server Services.
3. In the details pane, right-click each SQL Server, and then click Properties.
4. Go to Advanced tab, check the file version that should be 2007.100.xxxx.x.
5. Click OK to close SQL Server Configuration Manager.
6. In SQL Server 2008 Management Studio, connect to the correct server name for SQL Server 2008 instance.
check below links:
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/5b245db8-51f6-4dba-9bec-95160df1f102
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/e8877bf9-8cde-42e3-ace1-dded04b90b56
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
miss_just_le...
Member
42 Points
77 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Oct 21, 2010 02:13 AM|LINK
Hi.. THe version is 10.50.1600.1
and the servername I have is SQLEXPRESS <- THis is all I got
FYI
miss_just_le...
Member
42 Points
77 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 05, 2010 07:04 AM|LINK
Anyone please....
I copied the connection string of my ASP Page for my VB project.. Now i get a new error.
"An attempt to attach an auto-named database for file"
I tried following this but I still get the error
However,
When I convert my VB project to an ASP.net webpage it works...
Help please.
TabAlleman
All-Star
15571 Points
2700 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 05, 2010 02:31 PM|LINK
Could be your database is in single-user mode. Try this:
ALTER DATABASE [MyDataBaseName] SET MULTI_USER
miss_just_le...
Member
42 Points
77 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 08, 2010 02:37 AM|LINK
errr.. Sorry Mr. TabAlleman, I'm new to this.. where to I check this?
I only use the SQL Server Management Studio tool.
TabAlleman
All-Star
15571 Points
2700 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 08, 2010 01:47 PM|LINK
execute it as you would a query in Management Studio.
Rajneesh Ver...
All-Star
36977 Points
6793 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 08, 2010 06:21 PM|LINK
check below link:
http://www.mssqltips.com/tip.asp?tip=1086
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
miss_just_le...
Member
42 Points
77 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 11, 2010 08:34 AM|LINK
Sorry for the late reply.. I've been busy for a while..
I tried executing your snippet via NEW QUERY on the management tool..
Here's what i got.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'MyDataBaseName', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
TabAlleman
All-Star
15571 Points
2700 Posts
Re: Unable to open the physical file. Using Asp.net Forms and VB.net Project
Nov 11, 2010 12:51 PM|LINK
Try it, replacing "MyDataBaseName" with your database name.