[microsoft:sql-server] Forum Topics

Dear all, I have something very weird, never experienced it before with c# express edition - i have a piece of selection query that selects all the records within a specific month. - this query works very fine in msaccess, but doesnt work in the run time in c#. so …

Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14) in \usr\local\htdocs\connect.php on line 5 [B] We are using the following code for connectivity[/B] mssql_connect('servername,port', 'username', 'password'); mssql_select_db("dbname");

[CODE]BACKUP DATABASE [DATABASE NAME] TO DISK=’\\SERVERNAME\PATH.BAK’ RESTORE DATABASE database_name FROM backup_device WITH RECOVERY[/CODE] i dont know wheather i should create a query file for the code

Hai, [B]Problem we are Facing Currently[/B]: Records getting inserted as only one during the process of updating the server. Previously, all the given records get inserted into the database table during the updation process. "updateprice" is the .mdb exists locally in the same folder where the calling file for updating …

i am using MS-visual studio 2005 and VB.NET language in that. my ques is tht i am unable to load a crystalreport. all fields are shown from database (SQl SERVER 2005) but data is not shown so can anyone plz help??????????itz urgent

I am running SQL 2005 Standard Server. I am using Visual Studio 2010 for development. Let me just say that what I have below works, I would just like to have some constructive critisism. Is this the best way? Is there a better way? Are there any things I need …

.NET4.0 / VS 2010 The treeView never populates past Jobs. I have a SQL table with the following: Node NodeName ParentNode 0 Jobs 0 1 Child1 0 2 Child2 1 3 Child3 1 4 Child4 3 5 Child5 4 6 Child6 4 private void FillTree() { con = new System.Data.SqlClient.SqlConnection(); …

I tried setting the value type as DATE but it's not being recognize.. I'm using SQL Server 2005.. I though date is a value type but it's not working..

I have a few tables on my dev computer that I would like to roll out into productions. Is there an easy way to convert the table to sql syntax? Ideally, I would like to end up with a file with all the commands to create the table and the …

This is my current code [CODE] SqlConnection con = new SqlConnection("Data Source = .\\SQLEXPRESS; Initial Catalog = Library; Integrated Security = True"); string query = "select author_name from author"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = query; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt …

Hallo dont now if its right forum and excusse for bad english. I hawe a site on one.com and tried to restore my sql data base. i hade a backup, before i restored it i dropped all the thables to read in the new wone. buth it dosent work it …

I have two tables tbl_1_id_pk tbl_1_diska_fk (relationship) ---> tbl_2_id_pk tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk and tbl_2_id_pk tbl_2_name When I create views/queries for the name for each disk, it returns nothing. Why?

Im brand new to programming, ive only been doing it for couple weeks. Im having trouble learning functions(or methods) and classes. I really need some problems i can work towards myself to learn this stuff, but there is nothing like that anywhere. Its all just the same tutorials and them …

hello people, when i run this below written query then i get error as "ORDER BY clause is invalid in views,inline functions,derived tables, subqueries and common table expression unless TOP or for Xml is also specified". i want to have the top 5 result based on the Gross_written_premium . can …

I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …

hello! i need your experience in this: i want to build a web page that i had categories and in each category i have a small pictures and a link named next so when o click "next" i want the 5 small pictures to be replaced with new 5 pictures …

hi, i am doing a project in attendance system in vb.net, i don't know how to maintain back end process ,i am using sql 2005 ie database and tables for different department... pls help me

How to put parameters within dataadapter? Here's an example of non-parameter query.. [CODE]SqlDataAdapter da = new SqlDataAdapter ("SELECT * FROM Table WHERE column='"+textBox1.Text+"'",con);[/CODE]

Hi guys, can anyone tell me how can i store pdf files and images in sql databse. Thanks

Hi all, I am having a bit of a problem with implementing a nested statement that will update based on conditions. I know the logic behind it, but do not know how to implement it with nested queries. Please see below the pseudo code I've written along with an example …

I'm using the HR@orcl learning account from oracle. ----------------------------------------------------- and I have the following question : Create a an SQL query to display the department, the number of employees for that department based on their salary, and the total number of employees for that department, giving each column an appropriate …

Hello every one ; I am glad to join you and thanks for your help; Please I want to kow how can I add and display number of visitor to my web site if I use VWD2008 (ASP.net) and SQL Express2005 and how can I save this number in the …

How to add a image or a picture from c#.net to sqlserver database . so that we can able to see the picture or image in the database when we open

If I want to select the max value of 1 record, but there are two columns that having the same max values? How can I select both of them?

hi all i have developed a small website in ASP.net(Visual studio 2005) and SQL server 2005. IIS 5.1 is installed in my machine. How do i deploy it in IIS. i tried to copy the website to default website and set the default document as one in my website. My …

HI, I have a requirement where I need to compare the data in different database(tables having same structure/schema). I know manually I can execute the queries in each database, compare the results and it is done. As this execution is repetitive in nature, how I can automate this. Thanks In …

wat is the problem here [CODE]cmd1 = New OleDbCommand("Update tblParking SET status = 'Available' Where exp_date <='" & Date.Today & "'", cn)[/CODE] i want update the field status to "Available" when exp_date is less then todays date.. wat do i need to do.

i have consistently asked for help but none so far. Kindly assist me to get the data grid view items saved into a database.below is code for what av done so far Regards. [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace …

good morning guys I have a question that am hoping someone can answer for me I am using vs 2008, and have put the sql database into a program that is being built. the database fields all work fine...I am able to make entries, save it, close it out and …

Hi there, I have a project created in C# visual studio 2008 standard edition and I am using a Microsoft SQl database file. I took my solution project in a filer and tried to run the application, going to the project folder and to the bin folder -> Debug folder …

Hello everybody, I have developed my software using NetBeans IDE 6.9: very simple, a db on a remote server, a JDBC:ODBC bridge connection in order to access it and everything was working fine, until I was ready to deploy it, and I fell in this problem of 32-64 bits conflict. …

I'm using VS2005 & SQL Server 2005 which is installed with VS2005. Platform is XP SP2. I've an app that connects to the DB & get some data from it . The app & DB are on the same machine . Suddenly When I run the app. , I've that …

Hey using the following sql [code] SELECT DB_SALGSPRIS from pris_interval WHERE DB_INTERVAL_START < '11.78' AND DB_INTERVAL_END >= '11.78' SELECT DB_CUSTOMER from pris_interval WHERE AND DB_INTERVAL_START < '7.19'AND DB_INTERVAL_END >= '7.19' [/code] I get multiple results, 3 from first, and 2 from the second to be precise, what I am wondering …

[CODE]Select CONVERT(VARCHAR,[Last_Edited1],106) As [Date], count([Lead_id]) as [Total Lead] from Avalan_cus Group By CONVERT(VARCHAR,[Last_Edited1],106) - (Select Count([Lead_Id]) from avalan_cus where [Lead_Id] in(Select Leadid from avalan_extract)Group By CONVERT(VARCHAR,[Last_Edited1],106))[/CODE] how can i do like this....i hv to substract

how do i update, delete, add an sql database with c#

I have the strangest problem. First let me state that I am by no means an expert on either Web Applications or SQL. I have however, been delegated this project and have made some progress. First, all the servers for a small office I work in were upgraded to 64 …

Is it possible to get the max values from the columns in 1 table and copy them into another or would this not be recommended. The more I think about it the more I begin to think it isn't such a good idea. Here's an example what I'm looking for: …

[code=php]<?php $host = "Localhost"; $user = "User"; $pass = "Pass"; $db = "DB"; echo "<b>This will test your SQL Server connectivity...</b>"; /********** testing connectivity ***************/ echo"<font color = 'green'><br>connecting to Server....<P>"; $link = mssql_connect( $host, $user, $pass); if( !$link ) { die("<font color = 'red'><p>Failed to connect to server: database …

I want to compare a DateTime date & time in a GridView to a smallDateTime date & time in a database table. I'm not sure what goes wrong, but I get the error message "incorrect syntax near 'whatever time'" every time. An example: A DateTime datumStartTid could be '2010-07-25 19:00' …

hi all, this is first time connect php with mssql 2005 code : [CODE]<?php $myServer = "srv\ins"; $myUser = ""; $myPass = ""; $myDB = "db1"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected …

Please help me to develop this simple windows login form problem is i am unable to validate my user name and password... [CODE] namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { login(txt_username.Text, txt_password.Text); } public Boolean …

H! There! I have a problem in c# that require sorting of names of students in a sql database and i want it to be specific, i used data grid view to view the data of the students as shown below: Students First Name: Ann Antoinette Bernadette Brenda Jeannette Judith …

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class userreg : System.Web.UI.Page { SqlConnection con; protected void Page_Load(object sender, EventArgs e) { } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { …

I know, is a very basic question, but I am in the process of re-learning sql stored procedures, and this is what happended: I was practicing with some simple delete / insert routines, when encountered with this: if I ONLY insert records: 1. dog 2. cat 3. t-rex 4. llama …

Hi, select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_expenditureinvoice c where a.client_id=b.client_code and a.client_name=b.client_name and a.location=b.client_location and a.receiptno=35 and b.fully_recived not in ('Y') and b.amt_balance>0 and (c.fyear_code=b.fyear_code and b.inv_no=c.inv_no) union select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_invoice c where …

This is a User Defined Function to perform simple encryption on an input string. This is performed by transposing the ASCII value of each character in the string by the increment value (@increment in the parameter list) Pass the function the string you wish encrypted and the increment value, which …

I have created an ASP.NET website using MS Visual Studio. It has a data source which is a database created using SQL Server.I have to generate high end(quality)reports using the data in this website. However i can only generate low quality reports using the built-in crystal reports template. So i …

hi i am nandhini i hv a mini proj based on any lang like vb or sql with a database.... i am new 2 dis type of proj so plz help me out plz....................

when i try to add a new data source halfway through the add new data source wizzard it gives me this error ------------------------------------------------------------------------------------- un expected error has occurred error message: Could not load type Microsoft.visualStudio.DataDesign.SyncDesigner.SyncFacede.SyncManager,from Assembly Microseoft.VisualStudio.DataDesign.SyncDesigner.DslPackage Version=9.0.0.0 culture=neutral,PublicKeyToken=b03f5f7ff11d50a3a'. ------------------------------------------------------------------------------------- is there any way pass this because it will not …

Hey all, I'm what you could call a beginner database coder, so this may seem like a simple issue to some :D I am using Visual Basic 2010 Express and a SQL Database. I have a series of TextBoxes, ComboBoxes, and CheckBoxes that I would like to save to different …