I am using SQL Server 2008 express and in company enterprise al with sp1 and i want to import .mdf and i get this error: .mdf version is 661, your db supports the version 655.Which version is 661 and how to import it in sql Server 2008.
View 3 Replies
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 would like to know the version of ASP.NET supports using Windows AppFabric caching for session management or is it just about using the AppFabric session provider
View 1 RepliesAfter I successfully installed Database Publishing Wizard [URL], I use it to connect to my local database server using SSMS 10.0 to generate a .sql file but I'm getting this error "This SQL Server version (10.0) is not supported."
Is there any updated version of DPW 1.1 that supports SQL Server 2008?
How to find which version of the Sql Server install into your system,I am running Windows Vista Home Premium(32 bit operating system) , when I try to install Sql Server 2005 Stand edition on my laptop ,it's shows some compatibility issue.
View 6 Repliesi have a breand new laptop with only the OS installed. I have installed VS2008 and its updates I also installed VS2010 and its updates. I started to recieve the above error when I try to access SQLExpress through the VS interface.
I deleted both version and all the SQL referances in the Install/Uninstall listing.
I have reinstalled VS2008 and its updates and I still get this message...
I find lots or solutions for this error when moving DB's from one machine to another.
What am I supposed to do?
Do I delete EVERYTHING (includein the OS) and start from scratch again!
I have a website in which code on the production server runs no problem. The same code on my local machine or test server produces the mess seen at the end. The exact same code. Additionally, upon trying to preview any of the table adapters in the dataset I get "DataSet1.thename could not be previewed. The provider is not compatible with the version of Oracle client"
The app is SQL Server. It always has been. It has never used Oracle. Does anyone have any insight on how to fix this? As it is now I can't do anything with my dataset. I can't edit anything in there because of this complaint about Oracle.
[Code]....
Which 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 am having trouble installing SQL Server on my system ... it appears to install ok but when I try to connect it using Visual Web Developer Express 2008 it will not connect and mentions something about versions. I downloaded the Northwind database to carry on with the tutorials .. this also asked me to download the MS SQL 2000 version which I tried and this also did not work, other versions include 2005 and 2008. When I tried to open the program through the programs file from "Start Menu" only the configuration manager folder is there.
I have also tried to install the trial version from the website but to no avail. Each time I have restored to factory settings on my laptop and it still fails to connect. I notice that when I restore to factory settings there are loads of icons where the uninstall window lists all of the programs and there is still SQL Server 2008, lots of Icons. I think that version 2008 came with the laptop as it is a business sony vaio sr vgn-sr46gd model with vista business.
I have never created my own solution before now. I have always modified existing solutions and know how to do it. For some reason, this new solution isn't connecting to my SQL server correctly.
I am using VWD 2008 Express Edition.
I have MSSQL 2008 Developer Edition.
I have used aspnet_regsql.exe to create the tables in my SQL DB.
I have added the following to my webconfig:
[Code]....
But for some reason, when I try to use the Web Site Administration Tool it thinks it is not setup.
What am I missing?
I'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'm trying to implement an ASP.NET DataBoundControl that supports two-way databinding. Unfortunatelly I can't find any documentation on how to do this on the web and even Dino Esposito in his ASP.NET 2.0 Advanced Topics only handles one-way databinding (also the contact form on his blog isn't working). Can anyone provide me with documentation or samples on how to do this?
View 2 RepliesI want to create a ListBox control that supports display of items in two columns. It also needs to support selecting multiple items.
and the ListBox items should be CheckBox. What I need to do?
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
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 RepliesWe have an application that is already deployed in the production environment. And currently it is using Dundas evaluation version. We tried updating it to the licensed version by simply pasting the dll file. but we got the error message as "The file has not been pre-compiled and cannot be requested".
View 1 RepliesCreating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesi would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
View 1 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have an ASP.NET project. Naturally, through different releases and development branches, the db schema changes.
What are some ways to cleanly handle the schema changes in a friendly way so that I can easily switch between development branches?
I use SQL Server 2005, but general techniques probably work.
I have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI'm try to get my site to detect what browser someone is using to ensure they're using one that is compliant with our site. Everything works, except Firefox seems to post the wrong version in the Request.Browser variables.I'm on Firefox 3.6.10, but Request.Browser shows Mozilla 1.9.2.10. It's correct in the HTTP_USER_AGENT string:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.10) Gecko/20100914 YFF35 Firefox/3.6.10 ( .NET CLR 3.5.30729)
Is there a way to detect it better without having to parse through the HTTP_USER_AGENT string?
Is there any limit on the size/numbers in the version number of the FormsAuthenticationTicket.
I tried to create an ASP.NET cookie using forms authentication, with a large version number(ex: 1234567 need this number for identification purposes). But when I decrypt the cookie I get 135 as the version number.
Initially the old forms authentication cookie was removed, in order to add new information.
Response.Cookies.Remove(FormsAuthentication.FormsCookieName);
Following is the code I used to create the FormsAuthentication cookie.
FormsAuthenticationTicket newAuthTicket = new FormsAuthenticationTicket(1234567, un, DateTime.Now, DateTime.Now.AddHours(5F), false, user_data);
HttpCookie newauthCookie = new HttpCookie(FormsAuthentication.FormsCookieName, FormsAuthentication.Encrypt(newAuthTicket));
Response.Cookies.Add(newauthCookie);
After retrieving the cookie, the version number I got was 135. This number varies with different version numbers.
string cookieName = FormsAuthentication.FormsCookieName;
HttpCookie authCookie = Context.Request.Cookies[cookieName];
if (authCookie == null)
{
return;
}
FormsAuthenticationTicket authTkt = null;
authTkt = FormsAuthentication.Decrypt(authCookie.Value);
if (authTkt == null)
{
return;
}
int versionID = authTkt.Version;
Can someone let me know if it's a bad idea to use such big version numbers, or am I missing something in this.
