472,347 Members | 2,321 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,347 software developers and data experts.

VStudio 2005 \ SQL Express DB

I'm working to upgrade an ASP web app with a Microsoft
Access 2003 db to ASP.NET v2 with a SQL Express db.
I don't have a lot of experience with SQL Server db's, but
would prefer the new app use that over Access for performance

I'd like to be able to import data from XML tables (or some
other data source) to the new db in the project. In the SQL
Server Management Studio, I have this option in other databases
under TASKS. I don't have this option via VStudio, however,
and I can't seem to figure out how to attach to the new SQL
db in the VStudio project (located in App_Data) using the
SQL Management Studio. (I get access denied - Probably
because of the security set on the folders under InetPub...)

I've run the Access Upsizing Wizard to create a new SQL
db with the tables I need, and have done so again to put
the tables in an existing db - But I'm still left scratching my
head as to how I'm supposed to get this same data into the
db attached to the VStudio project. I'd like to be able to
import data on an occasional basis later after the new version
of the app is up and running as well, so I'd really need to
figure this out before continuing.

I have to be missing something. Does this really require
a bunch of code to implement via Visual Studio 2005?
Thanks in advance for any input you might have.


Oct 6 '06 #1
0 1151

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

Similar topics

by: Lubomir | last post by:
Hi, I would like to ask, how different are C# 2005 Express Edition and C# within MS Visual Studio 2005. Than as well Visual Web Developer 2005...
by: Bonj | last post by:
Hi I installed .NET 2005 express edition, and am about to unnistall it again because it can't seem to be able to even insert a resource file into a...
by: Patrick Olurotimi Ige | last post by:
Hi, I have VStudio.Net 2003 installed but can i install Visual Web Developer also on the same PC. My current .Net Frameork version is 1.1. Will...
by: Peter Oliphant | last post by:
I have been using VS C++.NET 2005 Express as our company waits for the MSDN full version to arrive. It is a pretty amazing free tool! My question...
by: QLD_AU | last post by:
Has anyone see the following error ? VS 2005 Installs ok, however the SQL Mobile Edition (part of a full install) fails with the following error...
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could...
by: John Kotuby | last post by:
Hello all, I have VStudio 2005 currently installed on my workstation. However, I am collaborating on a project with an outside consultant who is...
by: JJA | last post by:
I am exploring use of the new ASP.NET 2.0 membership facilities. Using Visual Studio 2005 on WinXP, I have one little site in...
by: Kerem Gümrükcü | last post by:
Hi, for some unknow reason the UI of the VS2008 didnt respond to any kind of input even like Ctrl+F4 or Exit Command. The Save,Open,Save As,...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

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.