i have designed a simple login page in VWD(login.aspx) . I have also added the connection to database option. Now i am stuck with adding connection strings in the web config file and also adding namespace.
View 2 RepliesWould something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
View 1 RepliesIs it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works, but I can't seem to get it to work with SQL Server 2008 Express locally. The database is located on the same computer as the .NET code in case that matters.
View 2 RepliesI am currently working on a project and I am hosting it on my IIS to test it every so often but now i have an issue:
When i run in debug mode with this connection string:
Data Source=.;AttachDbFilename=c:New folderdbname.mdf;Database=dbname;Trusted_Connection=Yes;
everything works fine and i can access the database but once its published onto my iis it doesnt find the database?
install Visual Studio 2010 (with ASP.net framework 4.0) and when I try to install SQL Server Express 2008 I get an error message telling me that .NET framework 3.5 SP1 is required.I know in the installation of VS 2010 SQL Server Express is installed. However I need to have the management studio install. I have tried installing both the full version of SQL Server Express 2008 and the front end management studio for SQL Server 2008nly.
View 2 RepliesEmbarrassed that I'm stuck on this I've downlaoded sqlserver express 2008 R2 and VS web developer 2010. Set up a databse wrote a mini test site and am now trying to connect to my database to fetch records back. However i'm getting the error message "Invalid object name 'customer'." (I have a feeling its running it on the master db and not my 'customerdb' but can't prove this as express doesn't have a profiler).
Here is my code;
[Code]....
I had archived all of my files prior to the change. Since I am now having a great deal of trouble working with 2010, I want to revert. My question is: If I restore all of the archived files and start 2008, will I need to make any changes to the registry or to any other files?
The problems that I am having are illusive. Some of the relative paths nolonger work. Some f the projects that had been working for 24 months no longer functions. I am having a great deal of trouble calling my older "[WebMethod]" "ASMX" services and many other issues.
We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum
View 1 RepliesI am considering an upgrade to Visual Studio 2010 Pro from my Visual Studio 2008 Standard Edition while the price is still $299. I have successfully used Visual Studio 2008 Standard Edition along with SQL Server 2008 R2 Express Edition to produce websites with database backends. I am assuming that I will still be able to do this with Visual Studio 2010 Pro without any heart-stopping transitional problems. Anyone have any experiences/advice about this? And just for the record, I cannot afford Visual Studio 2010 Premium which I believe would make this a moot point.
View 1 RepliesAfter I installed Visual Studio 2008 Standard edition, then I upgrade "SQL Server Express 2005" to "SQL Server Express 2008 SP2". Process upgrading SQL Server Express 2008 was going succesfully (none of the process was fail).
But when I create a New Website I could not add a new item "SQL Server Database" into my website file. Because Visual Studio always rejected any new "SQL Server Database" by giving message below (underline):
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
I started working on a website using 2010 Express. However, the hosting company that I am using hasn't fully implemented .NET 4.0. I'm wondering if there is a way that I can save my website for compatability with 2008 express. Then I can finish and publis using 2008 Express.
View 1 RepliesI would like to use both of the connection strings in the same web.config file how can I do this I tried this yesterday it worked I called it a night, then this morning I got this. The error being on line: 10 Parser Error Message: The entry 'ApplicationServices' has already been added.
Line 8: <add name="ApplicationServices"
Line 9: connectionString="Data Source=Mysource;Initial Catalog=travelatlantic;User ID=MyID; Password=MyPassword;" />
Line 10: <add name="ApplicationServices"
Line 11: connectionString="Data Source=MySource;Initial Catalog=travelatlantic2;User ID=Myid; Password=MyPassword;" />
Line 12: </connectionStrings>
i have installed SQL server 2005 Server & Clicent in My PC. now i want to install SQL server 2008 Express Edition.
when i try to install it it gives an Error as below.
Rule "SQL Server 2005 Express tools" failed.
The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.
Is there a spell checker add in that can be used with VS2010 express? I have downloaded a add-in for 2008 that "claims" to work with 2010 but when I installed it on my machine it does not show up in the tools menu and I cannot find the exe to add it via the external tools interface. Is there a add-in for VS2010 paid or free?
View 1 Repliescan visual studio 2010 express be installed on a pc with visual studio 2008 and visual studio 2005?
View 2 RepliesI've wrote the comprehensive post within my blog: [URL] In brief words everything is simple:
1. I've downloaded free Visual Studio C# 2010 Express and Visual Studio Web Developer 2010 Express
2. I've successfully installed these versions.
3. I've tried registration online - and got the appropriate keys which I've used for registration.
Finally all the keys I've got are not valid for the system - and after 30 days evaluation (for free version?) period all these products are not running anymore because all the keys I am providing from online registration are invalid.
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 RepliesMy set up is as follows
IIS + SQL Server Express running on the same machine.
SQL Server Express has named pipe connections.
IIS hosts an ASP.Net website(v3.5)
ASP.Net site has web config entry to database using integrated security.In regard to this, how are the connections between the ASP.Net app. and SQL Server express handled? Does each user connect using the same login to SQL Express (think its NETWORK-SERVICE)? If 2 people hit the same web page at the same time how many connections are opened to SQL Express? Is it up to the setting in connection pooling? E.g. if connection pooling is set to 10 then in this example 2 connections are opened?Or is it that only one connection is used and users must wait for the previous user's webpage to finish all database operations before their request can be processed.
How to do sum 2 differences fields as a new column in Subtotal ? I know to do in Microsoft Access and that is easier.
View 2 RepliesIam using web developer express 2010. I was wondering if the web developer 2010 express supports SQL Server 2000. I know i could connectSQL server 2005 and up but is it possible i could connect sql server 2000 to web developer 2010 express?
View 4 RepliesAfter reinstalling Visual Web Developer 2008 express a few times I still don,t have design view just source view.
View 3 RepliesI just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------
I built a website using SQL 2008 Express. I want to deploy it to a hosting company (shared server). If I change the SQL 2008 Express database on my local machine (further development of the website), how can i synchronize the local SQL database with the one on the server without loosing data?
View 3 Repliesi have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database
View 1 RepliesI am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
View 2 Replies