[sql-server] Forum Topics

hi i picked this script up from a site and im trying to install it in my system and i came across the error below You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …

Hi, I'm using PHP, I am trying to develop: 1. a login page in HTML, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and address), all these …

hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim …

The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which …

I’ve been looking and researching ASP.NET hosting provider for the past few weeks. Please kindly help me to choose the best hosting provider for me. I will be more details about my requirement below. I’m leaning towards Microsoft Azure Web but a bit concerned about the price. I will talk …

I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con …

i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make …

Hello everyone. I am modeling a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not sure it is correct: My presentatioon layer is a simple GUI where users insert their queries. They have a form for entering new words and their definitiom …

I have 1 gridview with big table...colums:k,mi,ib and 3 textbox...texbox1 is first column,textbox2 is second and textbox3 is third! I want when i type some number in textbox1(That number is K),i want to textbox2 and textbox3 give me value of mi and ib in same row as k...but i got …

Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and …

hi everyone. I have this code to retrieve image from sql server using asp.net with vb, the problem is the image cannot display in the web page and I don't know what is the problem can you please help me.` Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits …

I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …

Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are …

Hi , i need some help in completing a small task . " How to insert,update,delete record in data grid view using inline i.e (suppose if we update a record in the data grid then after click on the next row the data which is updated should be save directly …

Hi! I'm using Microsoft Visual Studio 2008, Microsoft SQL Server Management Studio. I need help. I cant figure out this if else statement for this condition: ///to check condition either the way ID exist in database ///if not exist then way ID can be delete ///if exist, message box appear …

Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, …

hi everyone. I want to retrieve image from sql server database using asp.net with vb, but the image is not display and I don't know what is wrong with my code. please help me. Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits System.Web.UI.Page Public sqlcon As SqlConnection = …

hello everybody...nice to back again i m working on project to calculate measures and numbers and insert data inside datagridview(dgv) from number.text and measure.text but if value of measure.text present in dgv son update number cell with new value + present value problem is how to do so.... i tried …

Can SQL 2005 Run on Windows Server 2012?

Hello ALl, I have found this project online which I would like to do. The link for the project is http://1000projects.org/network-intrusion-detection-system.html#comment-249119. If I am correct, this application if built properly is meant to look at all the packets and store them into SQL server?. I have got many problems before …

hello i'm beginner at programming and i want to connec to my database with PHP PDO with SQL SERVER 2008 R2 the problem at the begining it appears to me an error with this message "could not find driver" after a little searching about this i found how to download …

Hi, I have been working on a application that used sqlserver 2008 R2. we had used filestream that was there in 2008 r2. there was a decision to move from 2008 R2 to 2012 express. Now i understand that file table is a new addition to 2012 and will do …

Someone can help me to find my error: $query=mysqli_query($con," SELECT * FROM item WHERE ITEM = $ITEM ") or die ( mysqli_error($con)); i reciveing this error,i dont know wherer is syntax error. *You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

How to edit and save image to sql server and retrieve back in html.

# Performing Selective Includes in Entity Framework with the Fluent API # When we are using Entity Framework as our data access choice to work with SQL Server then there are some potential pitfalls. One of these pitfalls is doing selective includes. What do I mean by selective includes? To …

I'm trying to query from two tables but whenever i run my php script i get this error, any help would be highly appreciated Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to …

Can any one help me to load SQL server dlls in PHP.ini

Hello, I am trying to learn c# and sql server and I am not sure how should I proceed in the following situation: I have a database with 2 tables: Clients and OrdersFromClients I am trying to make a form with a listbox in which I will display all the …

hi. few days ago I open a microsoft azure account and create a virtual machine. download SQL server managment and do everything ready. open TCP port 1433 and my DSN name is btca.cloudapp.net now I cant connect with the database inside it... what to do. Im looking everything but nothing …

hi. few days ago I create a Azure account and create a Virtual machine. download and install SQL server managment, open TCP port 1433. but cant connect to my app.. my DNS is btca.cloudapp.net but cant connect. tried to connect with DSN & IP but nothing happening. any suggestion?