I have a table software (id_software, software_name, category) What SQL query to show only 2 software for each category ? For example I want to get : |id_software | software_name | category| -+------------+---------------+---------+- | 1 | Photoshop | 5 |…
my target was to moved all the mssql databases from sql server management studio express 2005 server to sql server management studio express 2008 server. For this i first created the databases and the users in the new server via…
I'm trying to connect to a remote ms sql db (not a localhost), but everytime it timeouts before it sucseeds... I'm pretty sure that the problem is the $serverName variable, is there anyway to check via Plesk Parallels what is…
I am trying to create a windows application using vs 2010 in c# which will sync two database where one database is on local machine and another on server. Here is my sample code. using System; using System.Collections.Generic; using System.Linq;…
I am using the Plesk hosting for my asp.net mvc 4 website with Sql Server 2012. My Connection string is the following: metadata=res://*/Models.FolioData.csdl|res://*/Models.FolioData.ssdl|res://*/Models.FolioData.msl;provider=System.Data.SqlClient;provider connection string="Data Source=184.168.47.13;Initial Catalog=MyDataBase;Integrated Security=True;User ID=*****;Password=*******;MultipleActiveResultSets=True;Application Name=EntityFramework" But i keep getting the error: Error. An error occurred…
I am using Entity Framework to access the data from my database. It's an MVC application and works fine locally. When I deploy the application on hosting (Parallels Plesk Panel, MS hosting) I get problems with accessing the SQL server…
In my local or on a dedicated server, when i create a table i see the table name as follows: dbo.Foo As i was given a database account from some plesk environment, the tables which were created get the name…
I have SQL Server 2008 and VS2008 installed on my computer and I am trying to run a web application I've created on a computer which has SQL Server 2008 and VS2008 and VS2010 beta 2 with its SQL Server…
I was wondering if there is a way to see if a server blocks outgoing connections. I am trying to connect to an external database from a client's server. This is the error I get: A network-related or instance-specific error…