473,657 Members | 2,572 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

creating .mdf in ASP

cj
I've been writing Windows apps for years now but to become familiar with
web apps I'm working my way through some instructions to build a web
site using a SQL database. The instructions assume I'm using VB Express
but I'm using VB 2005 pro. I ran into a problem when the instructions
said to right click on App_Data in the Solution Explorer and add a new
SQL database item. I got the following error:

Connections to SQL Server files(*.mdf) require SQL Server Express 2005
to function properly.

I do have SQL Server Express 2005 on my pc, it is running and I can use
SQL Server Management Studio Express to connect to it.

I think the problem comes from the fact many of my windows apps use our
production SQL Server 2000 database in the computer room. I expect that
the production system is being seen as the default SQL Server by my pc
and consequently the web app is trying to connect to it to create the
database. I think I should be able to choose which server the database
is created in somehow. Do you have any idea how I can force the web app
to look at my pc's SQL Server Express?
Apr 12 '07 #1
5 1387
Which is the technology you would prefer to use... SQL Server or MDF?

Use the App_Data folder you can create a connection (and database)
using Access as your backend (.mdf)

If you open server explorer and right click on data connections you
can create a new SQL database. The two things are entirely seperate
from one another.

Apr 12 '07 #2
Charlie Brown,

SQL Server 2005 uses .mdf files to hold databases. Access uses .mdb files
for the same purpose.

Kerry Moorman
"Charlie Brown" wrote:
Which is the technology you would prefer to use... SQL Server or MDF?

Use the App_Data folder you can create a connection (and database)
using Access as your backend (.mdf)

If you open server explorer and right click on data connections you
can create a new SQL database. The two things are entirely seperate
from one another.

Apr 12 '07 #3
I stand corrected, Thank you.

To the OP: Try using the Data Sources tab to create a new data source
if you haven't already. That should allow you to choose the server to
which you want to connnect.

Apr 12 '07 #4
cj
This problem seems to be that although SQL Server Management Studio
Express can connect and create a DB in SQL Server Express 2005 nothing
else can connect to it--including VB. I've been Googling and searching
but can't figure out how to get it to work.

Charlie Brown wrote:
I stand corrected, Thank you.

To the OP: Try using the Data Sources tab to create a new data source
if you haven't already. That should allow you to choose the server to
which you want to connnect.
Apr 12 '07 #5
cj
It's working now. Don't know what fixed it but at least it's working.

cj wrote:
This problem seems to be that although SQL Server Management Studio
Express can connect and create a DB in SQL Server Express 2005 nothing
else can connect to it--including VB. I've been Googling and searching
but can't figure out how to get it to work.

Charlie Brown wrote:
>I stand corrected, Thank you.

To the OP: Try using the Data Sources tab to create a new data source
if you haven't already. That should allow you to choose the server to
which you want to connnect.
Apr 12 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2715
by: rdsteph | last post by:
Python411 is a series of podcasts about Python, aimed at hobbyists and others who are learning Python. Each episode focuses on one aspect of learning Python, or one kind of Python programming, and points to online tools and tutorials. Python related news and events will also be reported upon. This podcast series will probably not be of much interest to expert or professional programmers. I am a hobbyist and am not qualified nor capable...
6
6111
by: owen | last post by:
Generally speaking, what does it mean when I see a "button" with red text showing this message instead of the control I've dragged onto the web form in Design View.? (But the page works fine at runtime). Does it indicate a problem with References for example? Thanks Owen PS. replies cc'd by email appreciated. owen.southwood@mantix.com
2
2150
by: Pawan | last post by:
Hi Guys, I have this current assignment where I have to develop online forms for local municipal authorities. I have to use adobe acrobat to create online forms from PDFs (which I have never done before and have no idea how to do it). Now these online forms will be shared by 1200 users. VB and ASP will be used as glueware for the writing/coding. For eg, we will be creating navigation pages in ASP & linking into adobe. Any resource on this...
15
6742
by: Carlos Lozano | last post by:
Hi, What is the right way to create an OCX COM component. The component is already registerred, but can't create an instance. I am using the reference to the interop module created. If I use javascript or vbscript it works. I will appreciate any help. I do the following (C#):
2
3775
by: LIN | last post by:
Hello, Greetings. I am creating a web site which will contain lot of articles. I had been planning to create simple HTML page on the server everytime i posted a article (eg. article12.html ). Now, i want to show an advertisement on top of each of this html page. the ad banner has to be dynamically updated depending on date (period) the advertiser has planned to advertise for. So I thought of creating ASPx pages instead. Is it a good...
2
4560
by: Patrick | last post by:
I want to define a set of web-form templates in XML and render the equivalent web-form with ASP.NET, then process any input server controls on the form. Reading the XML file from Page_load is easy, but 1) How do I set about dynamically creating user controls (like TextBox, TextArea) --- simply Declare and initialised (new) the user controls?? How do I "place" it graphically on the form. Ideally, I want them to lay out in a table, one...
0
2130
by: Ravi Ambros Wallau | last post by:
Hi: I've created a custom control - a grid that uses Infragistics to display some filters, the grid itself, and some buttons. Well, when using this control directly on WebForm, everything works really fine. No problems at all. But, when this control is placed inside a template of an Infragistics UltraWebTab control, somethings stranges happens: 1. When the WebForm is opened, an "Error Creating Control" message is displayed (for container...
12
3153
by: Mats Lycken | last post by:
Hi, I'm creating a CMS that I would like to be plug-in based with different plugins handling different kinds of content. What I really want is to be able to load/unload plugins on the fly without restarting the application. What I did was to create an AppDomain that loaded the plugins and everything was great, until I tried to pass something else that strings between the domains...
15
2820
by: David Thielen | last post by:
Hi; My ASP.NET app (C# calling J# under .net 2.0) creates a png file in a subdirectory to display as part of the created page. However, the bitmap will not display due to a security violation. Everything is the default settings I believe. IIS is running under Local System. In IIS the DefaultAppPool is running under Network Service. Annonymous access uses the account IUSR_JASMINE (machine name is Jasmine).
9
2975
by: =?Utf-8?B?YmJn?= | last post by:
Hi all, I read somewhere "using kernel stuff in thread is not good.." if ManualResetEvent object is created in thread but not actually used, will it affect performance? Bob
0
8425
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8326
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8743
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8522
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7355
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5647
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4333
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2745
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1973
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.