HI I am using - ASP.Net - C# - SQL Server Express 2008 R2 I have a table called customers which contains all customer details and a stored procedure which gets: - Total No Of Customers - Total No Of Customers in Region1 - Total No Of Customers in Region2 etc etc... I would like to then populate these results into a "statistics" page on my site/app using the label control (or any other method if easier). So far I have the Stored Procedure: [CODE] CREATE PROCEDURE [usp_getStats] AS -- Count Region1 Accounts SELECT COUNT(custID) FROM custDetail WHERE region = …

Member Avatar
Member Avatar
+0 forum 10

Log In Failed for User '' The user is not associated with a trusted SQL Server connection Well, that's the full title of my problem. I'm working on a C# program that supposedly could access a database run by SQL Server Express. I know the program works, because it works on the PC where I installed the SQL server. If I run the program from another PC on the network, though, the error happens. Here's my connection string: \SQLEXPRESS;Database=GGDBase;Integrated Security=SSPI;Trusted_Connection=true;Persist Security Info=False; Variations include removing the Trusted_Connection, setting Trusted_Connection to 'false', and removing Persist Security Info. I also set the …

Member Avatar
Member Avatar
+0 forum 4

Hi all, I'd appreciate some advice concerning the following issue. I have a situation with two very different ways to implement. Both are easy, but Im not sure of the pros and cons of each. Basically I am allowing users to message each other on a website, and so I have the following table in my database: Message Table: MessageUID (PK), SenderUID, ReceiverUID, MesasgeText, DateMessageSent I also have another table thats stores images on the message. I allow users to paste pictures into the message and to position them. In this table I basically just store the picture name, the …

Member Avatar
Member Avatar
+0 forum 2

So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they have to have SQL or SQL Express installed? I ask because I'd rather go with a SQL simply because the potential for exceeding the 4GB limitation of Access is a remote possibility. However, I know if I require my mates to install SQL or SQL Express ... many will pass …

Member Avatar
Member Avatar
+0 forum 2

Hi everyone, Wondering if anyone can assist me with this; I've done some googling but haven't come across anything. We have a dedicated server running SQL Server 2005, express edition. I recently set up the server to allow remote connections to the DB engine and everything is working just fine. However, I would really like to limit remote connections to just one user; IE if someone other than user XYZ connects remotely, they are denied. Any ideas? Thanks in advance

Member Avatar
+0 forum 0

The End.