I have unexpectedly found that I cannot access my data tables from VS 2008. A window comes up saying "The server version is not supported. Only servers up to Microsoft SQL server 2005 are supported". Also, as a consequence I imagine, two web sites which refer to datatable have stopped working.
Has my ISP updated to an SQL version that VS 2008 can't handle ?
I have an application, that is accessing by number of users at the same time. Those users, who are accessing the application getting the same id. Here what i am doing in the code is, when they are creating new user i am getting a max id from DB and increasing the value to 1. So that they are getting same ID. so that i am facing concurrency in this situation. How to solve this problem. I need to display different numbers when the users click on NewUser. I am using SQL server 2008 and .NET 3.5 and C#.NET
View 2 RepliesI have an ASP.NET AJAX application, which is using .NET Framework 3.5. I have visual Studio 2008 installed on my developer machine. The AjaxControlToolKit dlls I have installed in my system right now come from the file "AspNetAjaxLibraryBeta0911.zip". The released date of the dlls in the file is 12/29/2009. Exploring the AjaxControlToolKit download site, I found that there is a more updated version, which release date was April 12th 2010.
I tried to update the AjaxControlKit.dll version to the newest one. I did this creating a path in my system: c:Program FilesAjaxControlToolKitWebFormsRelease then I placed there the new AjaxControlToolKit.dll and AjaxControlToolKit.pdb files. Then I right clicked on the name of the dll inside my Bin directory in my application and selected "Update Reference". After I did this I tested the application and is giving me Jscript error messages like: "htmlfile: member not found", or Microsoft Jscript Runtime error "lenth is null or not an object". I don't get these error messages if I come back to the previous version of the AjaxControlToolKit.
I usually use WebMatrix to manage my database (sdf file). I wonder if it can be possible to manage this database with SQL Management Studio 2008? When I try to open it with SQL Management Studio 2008 I get the error:
Incompatible database version. What's wrong?
BUT When I create a new sdf database with SQL Management Studio 2008, I have no problem for open it again with SQL Management Studio 2008 but if I try to open it with WebMatrix it doesn't work...(server not found?)
As I'm learning the ins and outs of ASP.NET user management, I've learned that the default in VS is for it to use a SQL Server Express .mdf file for the data it needs to save. This won't help me for when I deploy my site, as I'm running SQL Server 2008 R2 on my IIS 7.5 server. I know that I can run a command line tool to automatically create the db tables necessary for user management, and will do that on my development machine, but how do I tell my existing, in development code in VS to ignore the existing Express .mdf file and look at the newly created db tables?
View 1 RepliesWe have an ASP.NET web application and it's hosted using IIS 6.0, in the app we have these several javascript and css files located in a folder, and for performance sake (according to YSlow) we set the folder content expiration header to 1 year. Everything worked just fine until recently when we deployed the latest build to the server, in which we had made some changes to those javascript and css files. For some reason after the deployment some of our end users don't see the latest changes when they connected to the app, even after they cleared the cache in IE. We have also restarted the IIS on the server and the problem still remained. When I went into the IE Temporary Internet Files folder on one of these machines I saw the files were still the older version and not the latest one, I had to manually delete the files from the Temporary Internet Files folder then they were able to see the latest changes. I'm baffled by this, how come only some users who couldn't see the changes but some others do (without having to do anything by the way), and how do I make sure that for future releases we won't have to do anything like what did (manually deleting the cached files)? For now I disabled the Content Expiration option in IIS for these files but I would like to know if there is a way that I can enable the content expiration (to help performance) but at the same time making sure when the files are updated, the latest version will be used for the end user (instead of the cached version)?
View 3 Replies Here is my code. I just wanted to update one column. Why is everything getting NULL put into it?
[Code]....
[Code]....
I have Visual Studio 2008 installed on this workstation with SQL 2000, 2005 Express, 2008 Express and I think 2008 R2 (not sure if that is a version itselve or not)
I will call that workstation HOME
I created some tables in SQLEXPRESS through VS2008.
I worked on this project on another workstation that I just installed VS2008 annd SQLEXPRESS 2008 and I know that was R2
Installed Visual Studio 2010 trial edition between the thiem I made the tables on HOME and tonight for the first time since that install
I am now getting the "cannot be opened becuase it is version Version 661. This Server supports version 655..."
What to do now?
I can opened SQLExpress 2008 management studio and it is running.
So is my SQL 2000. The problem seems to be that after the VS2010 install neither VS2008 or VS2010 can connect to the SQLExpress 2008
What do I do now?
I can't remove sql 2000 because it is tied to several 3+ gig databases that will not work in Express.
I am using a web application which is recently Converted from vs-2003 to vs-2008.Here whenever i build this application, the related dll in bin folder is not updated. what may be the reason? how can i overcome this? I need this recently modified dll to be used in main project.
View 8 RepliesA ASP website, which is created in VS2003 is opened in VS2008. The project is migrated and some changes are made. A new setup is created.
The new installation does not work because Framework 3.5 SP1 is needed.Is it possible to use Framework 2.0 instead of 3.5?I tried to go to the property page and change the target framework to .NET Framework 2.0 on the Build tab.When installing the website it stills asking for
Framework 3.5 SP1.
How do you go about changing your asp.net version from asp 2.0 to asp 3.5 ?
View 2 RepliesDo you have tutorial document for Web.config? For 2008 version!
View 5 Repliessystem requirements on installing MVC/jQuery in MS VS 2008 trail version.Do MVC/jQuery ships with VS 2008 Premium/Professional Trial Version? Or I have to download it separately.
View 2 RepliesWhich version of Visual Studio 2008 do you currently use with NHibernate? I would like to test out NHibernate at home, but I'm not sure if I want to shell out $500 plus for VS 2008 professional edition. Has anyone had any luck with NHibernate on VS 2008 standard or even one of the VS express editions?
View 4 RepliesI'm used to public facing websites that use ASP.net membership - and when the SESSION vbl's timeout we re-direct to the login page like this
Code:
If Session("Yr") Is Nothing Then
Page.Response.Redirect("~Login.aspx?reason=timeout")
End If
And on the login page we check for that reason and put up a label on the screen saying that things timed out to protect sensitive data. This works fine. Now I'm doing a web site that's in house - and when the users connect they get a BROWSER POP-UP to login with the DOMAIN UN/PW - and once they get past that my default page redirects them to a home portal page. What do I do when my session vbl's expire now? I can't redirect to a login page - there is not one. How do I cause the re-authentication to happen more naturally?
I have a class with properties for stuff like FileNumber, OpenedDate, ClosedDate etc.When I Initialise the class I set the datetime variables to Date.MinValue.Then when I populate my textboxes I check if the value of the date variables are Date.Minvalue and I set the textbox text to an empty string.
Code:
If(File.OpenedDate = Date.MinValue, String.Empty, File.OpenedDate.ToString("yyyy/MM/dd"))
However whe I try to save the data to my sql server db I get a datetime out of range error. What is the correct way to handle these null values in my date columns?
I have SQL Server 2005 in my computer.I am using SQL Server 2005 for Development.
I can connect to my local & "COMPAQSQLEXPRESS" Server.
But while connecting to Remote Server i m getting the following error
TITLE: Connect to Server
------------------------------
Cannot connect to x.x.xxx.xx.
------------------------------
ADDITIONAL INFORMATION:
This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
------------------------------
BUTTONS:OK
-----------------------------
I had web application developed in VS 2005 + Sql server 2005 + Ajax 1.0 Extension . (Developed in Windows Server 2005) Now i am migrating to VS 2008.(Windows Server 2008 + Sql server 2008)
After opening and compile my Existing application in VS 2008,i am getting error.
Errors :-
Unable to load file or assembly 'System.web.Extenstions'' version=1.0.61025. (I think it because of AJAX Extension version.So i installed AJAX Extension 1.0 but it will give me ambiguous error so i uninstalled.I am added reference for version=3.5.0 but again unsuccessful.) What i will do now? Also i used 'Microsoft.SqlServer.SmoEnum', Version=9.0.242.0 in VS 2005. (Are i have to change it to version=10.0.0.0? by adding reference to new version.) I also used crystal report.(Is there is anything to do with it?)
I tried it and it only returns the first table.
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 Replieshow can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Repliesi am creating a log table, i want to insert datestamp, userid and fieldname change in the log table whenever the user delete or edit a certain field in a table, what my problem is how to get what fieldname is updated in the table, i'm not using detailsview or formview just the connection dataadapter and commandquery
View 9 RepliesI'm trying to implement a regular ol' out of the box asp.net login system on SQL Server for the first time ever, and it's giving me way more grief than I ever imagined. Everything works great on my local asp.net testing server, but I can't get it working on the web server. I just get the generic- Server Error in '/' Application. A tech at my host mentioned that he thought that it was because I was using an ASPNETDB.MDF file created in SQL Express 2008 on a SQL Server 2005 server. I makes sense but I've seen a half dozen or more possible solutions in the many hours/days I've spent researching this but I hadn't heard of that one.
View 7 RepliesI have login control, when user completes the registration process, thn i want him to login into his profile but when he login i want to check the plan for which he registered, i have three plans basic, professional, and enterprise, according to that only he will be redirected to different plan, how can i do that, i used below code but its not working:
public void login() {
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constring"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("select Email, Password, Edition from SN005ClientTable where Email='" + txtEmail.Text + "' and Password='" + txtPwd.Text + "' ", con);
[Code] ....
Are the Crystal Reports objects within Visual Studio (I'm using 2005) the full version or is it a trial version that is missing features?
View 1 Replies