[sql-server] Forum Topics

In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out …

These are my prerequisites software: * Crystal Reports * SQL Server 2008 Express * Windows Installer 4.5 * .net Framework 4 full The problem is Crystal Reports installation is first and it needs Windows Installer 4.5 and the .net 4 Framework. So the order of prerequisites must be like this: …

I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access …

Good morning everyone! I haven't been here in a while, but I have a question that I thought someone here might be able to help with. When it comes to accessing data from a SQL server, I know the logistics of getting that data through code, no issues there, but …

I have created a table in sql server, an insert stored procedure, a aspnet webform with 5 text boxes to edit the parameter values, a label to display the output identity value from scope identity and another label to display the inserted or not inserted report from the execution of …

Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" …

Guys, I am trying to learn asp, but I am stuck on this error forever... I managed to display and create new, but I can't delete and update. I was told I had to remove the ' around cid, but it still gave me another erro. can someone please provide …

Hello I have started my first ever VS Web page today and have two pages open in the software: Register1.aspx and Web.config. I am hoping to devise a simple 'new user registration form' with three fields: username, password, and email. When the 'submit' button is clicked, those three fields should …

I am trying to establish a connection with sql server but i am not able to do so. Can some one help me out?

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Hello, I am trying to create a table in MySQL with the following data: $sql = "CREATE TABLE $uID ( Col0 int(10) NOT NULL auto_increment, Col1 varchar(255) NOT NULL, Col2 varchar(255) NOT NULL, Col3 varchar(255) NOT NULL, PRIMARY KEY(Col0) )"; However, I keep getting a syntax error. Can someone pls. …

Hi I have the following code that uploads images and other files to an SQL Server DB on GoDaddy via a FileUpload Control on an aspx page. Public Function InsertData(ByVal cmd As SqlCommand) As Boolean Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim con As New SqlConnection(strConnString) cmd.CommandType = CommandType.Text cmd.Connection …

I am currently confused and not sure why. I believe I have stared at this for to long. I am currently just trying to populate a ComboBox with the data that is read in from a SQL DB through a SQL query. Currently I have the below code. I am …

Not sure where else to put this, I apologise in advance if its in the wrong place. I'm trying to migrate a program from one server to the next without having to completely re-edit every configuration file. To do this, I need to enable the sql SA account, which I …

I just have one month for preparation. 1-What to prepare most part in asp.net and php to cover in one month.I have basic knowledge of asp php and c#.sql server 2005/08.Quick way to prepare 2.What type of demo project should i make to show them. 3-How to show my 2 …

I'm testing out wdcalendar, a jquery based calendar for a wesbite. Some info on it: [url]http://www.webappers.com/2010/06/08/wdcalendar-jquery-based-google-calendar-clone/[/url] The installation instructions are simple, but not detailed so maybe im screwing up somewhere. They go as follows: Copy the unzipped directory into the apache www directory/sub-directory. For a database: Create a database, execute …

I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have …

<html> <head> </head> <body> <script type="text/javascript"> function ajaxFunction(choice) { var httpxml; try { // Firefox, Opera 8.0+, Safari httpxml=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { httpxml=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { httpxml=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { alert("Your browser does not support AJAX!"); return …

hi i created login page using php and mssql but i got an error **"Fatal error: Call to undefined function mssql_query() "** **heres my log in code** <form name="log" action="log_action.php" method="post"> Username: <input class="form" type="text" name="name"><br /> Password: <input class="form" type="password" name="ssn"><br /> <input name="submit" type="submit" value="Submit"> </form> **log_in form** …

Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and …

hello world, myself kishan kumar, iam new to web developing...my task is interrelated to edit,save & cancel....which is similar to edit button in shine.com...Iam doing in php language.the work is when user clicks on edit button he must be able to edit and after on editing he can save it …

Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance.

Please help me to connect my forms I created in Visual Studio 2010 to Sql server 2012.

Having problems with a malware I had to reinstall Win7 OS with recovery mgr.After I had to reinstall all my web development tools such as Visual Basic Express 2008, Visual Web Developer Express 2010, SQL server express 2008, MySql, Workbench.I cannot reinstall PHP and PhpMyAdmin no matter what I try. …

Hello, I am new to C# and i am stuck when i try to fetch the data from SQL Server to Visual studio. I am writing the code as a n-tier application - Data Access, Business logic and the front end. I am fetching data in a disconnected env. I …

I'm wanting to create an sql table, when a user registers at my site. This table will eventually be used to log messages. The code follows: <?php require('../connect/kidsblogsconnect.php'); $name=trim(mysql_real_escape_string($_POST['name'])); mysql_query("CREATE TABLE '$name'('sender' VARCHAR(30), 'message' VARCHAR(300), 'dateposted' DATE)") or DIE(mysql_error()); ?> When I run it, I get: You have an error …

Ok, I ve been struggling for the last two weeks to get my webservice working on somee.com. I managed that. Then my database corrupted but managed to get it migrated it to mysql before that and everything' s fine. Now the final problem that I have and just can't solve …

I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE …

Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for …

Hey guys, I'm not very familiar with asp.net (Doing this in c#) or session cookies for that matter, just the basics. Trying to store a list of items in a session cookie, then when needed, pull those items back out as a list to then use them in a MS …