Iam 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 RepliesI'm using MS Visual Web Developer 2010 Express to build a website that connects to a SQL server 2000 database. Is it possible to connect to SQL 2000 using providerName="System.Data.SqlClient"? I'm guessing not. Or am I limited to using providerName="System.Data.OleDb" ? And seems both connections are under this ADO.NET umbrella. confirm one way or the other ... I'm a bit confused.
From web.config:
<connectionStrings>
<add name="SubscrTypeConnectionString" connectionString="Provider=SQLOLEDB;Data Source=my-server-host;Persist Security Info=True;Password=123abcde;User ID=test;Initial Catalog=Apps"
providerName="System.Data.OleDb" />
</connectionStrings>
So I believe I need to use OleDbCommand calls. I've seen many examples to do gridview select/edit/delete using SqlClient but not OleDb calls in VB code. Links to sample code would be great.
I tried to connect to the SQL Server (2000) with the VS 2010 Express. I got error saying "This server version is not supported. You must have Microsoft SQL Server 2005 or later".
View 1 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]....
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 RepliesDoes SQL Server Express supports othere non english languages?
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.
I an trying to update DNN fron 4.7 to 5.6 and am running into unresolved issues. Here is what I am trying to do in an isolated development environment: (original instalation is runing on 2000) Restore sql 2000 backup to latest sql express. Try a fresh complete install of 5.6
I am getting an error while attempting to restore the backup made on 2000 -to- 2008: TITLE: Microsoft SQL Server Management Studio
------------------------------
Specified cast is not valid. (SqlManagerUI)
------------------------------
BUTTONS:
OK
------------------------------
I have a ASP project that I have done before and it was working fine with SQL Serve Express 2005. After formatting my PC, I installed first VS 2008 Pro and then SQL Server Developer 2008 and I'm testing on my laptop but I can't connect to database. After reading a couple of articles I knew that I can't use mdf file because I'm using SQL Developer so it needs another procedure to follow such as changing the parameters in Web.Config
Web.Config
<connectionStrings>
<add name="Connection" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Store.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
I tried a lot of soultion like start SQL browser Service to be on but still didn't work, also I tried to change the instance name in VS in options but also didn't work with me.
What are the limitations of Visual Web Developer Express 2010 when compared to the Professional and Ultimate and other non-free versions
View 3 RepliesI'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider." If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."
So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?
learn to use visual web developer but encountered a problem. I wat to be able to upgrade something and then as the lv goes up the time to do something goes down.
View 2 RepliesI created a "website" in VWD 2010 Express. The project contains no bin folder and I can't seem to compile it. I don't have a web host, so for now I'd like to run my site on "localhost" on my machine: i.e. I'd like to drop the DLL (if there is one) and my aspx files into a folder on my hard drive and run the site from there. The site runs if I open VWD and run the asp.net web server, but I would prefer to not have to open VWD each time I want to load my site.
View 5 Repliesthis is probably a very newbie question, but how can I get to site.master??
View 1 RepliesWhat is the different between the vs 2010 Web Developer Express and the full version of 2010?With the vs 2010 Web Developer Express will I be able to use all types of databases (MSSQL, MySQL, Access, ect) and enitity frame work?
View 2 RepliesI created ashx page in VB and after I saved it I can not editi it anymore does anybody knows why his happens?
View 1 RepliesIs is possible to set up a test email server within VS Web Developer 2010? After a recent computer crash I've reverted to XP Home rather than Pro so I can't do it via IIS.
View 3 RepliesI'm in the process of rebuilding a computer and have upgraded to Windows 7. I went to download VWD 2008 and find I can only get 2010. Will this be compatable with sql Server 2005 developer???
View 2 RepliesOne thing I do like about visual studio is the autoindent feature in the code behind where you can essentially close off the bracket of a loop or method or class and it'll automatically indent everything to make it consistent looking.
View 1 RepliesI am using ASP.NET MVC and want to have Unit Test functionality integrated within Visual Web Developer 2010 Express (or Visual Studio LightSwitch). Is it possible and if so, what is the recommended/best way to get it?
View 1 RepliesCan i use web developer express 2010 to deploy applications or is it still in Beta?
View 1 RepliesMy instructions for creating a new web service with VWD 2010 Express call for using the installed template, "AST.NET Web Service". But this template is not listed.
I would like to create a simple web service in visual basic, place it in IIS 7 on my desktop, and then consume it probably using a proxy class.
Is there another way to create a new web service in VWD 2010 Express?
WebPI isn't able to install VWD 2010 Express on my system. I've previously un-installed the 2010 beta. Never had this problem before when upgrading VWD Express.
View 8 RepliesI have an annoying issue with Visual Web Developer Express 2010. When I run my web app with CTRL + F5, VS launches two IE pages of my app. When I run the app using just F5, I get one page of IE.
View 1 RepliesI've just rebuilt my PC and have upgraded to visual web developer express 2010. I have imported my projects which use the charting control quite a bit. Unfortunately my projects are failing to run. In design view the control is now showing as "unknown server tag asp:chart". I can see the Chart control in the data tab in the toolbox but it is greyed out.
View 1 Replies