[microsoft:sql-server] Forum Topics

I am installing SharpForge on my computer. I am getting error when i went through the intallation wizard. Error exception details System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the …

Noob question - I have MSSQL 7 running on my machine, although I'm not sure how it got there. I have one DB program using it along with the UPS Worldship program. The latest version of Worldship (9)will not install unless it sees SQL 2000 or better. My DB people …

Has anyone attempted virtualizing Microsoft SQL Server 2000/2005 using VMWare or MS Virtual Server? I've heard from others in the field that they wouldn't virtualize a database server relating to high availablity restrictions. We know for sure that we will virtualize our web servers, mail, and possibly domain controllers. Just …

Hi we have our final year degree projects starting studying computer applications, im competent in languages vb6, asp, sql, html, CSS, java sript. for my project im thinking of doing an e commerce website, for a paper merchants company, they sell and deliver paper to schools nation wide, the website …

hi, i am new to .net development, i want a simple login webform code behind page using a simple sql table only featuirng user id, name and password with validation. can any one help me out. please..............

Hi 2 all, im a newbe in alot of things, 1st I just registered @ this cool site, 2nd I am learning to wright and develop programes, I just started in MS Access, cause it`s easy to create tables, forms and so forth, my boss use`s .NET (way to hard …

I am using rowcnt column in sysindexes to report some database statistics. I used the "max" to get a valid row count (as I found multiple records for many tables) for each table, and added status<>0 in the conditions to get valid results. All went OK except for some rare …

Hi, My experience in Regex coding is very less. I have been assigned to clean up some data to make it meaningful. I got this data from SQL server: 10/8/2007 5:03:06 PM thakurab *************RECIVED MAIL PQR Start Time: 10/08/07 16:29:09 New PQR State: Assigned Respond Due Date: 10/09/07 00:29:09 The …

Can someone tell me why this SQL Command at the end is not working? I am a noob, but I have tried everything I can think of and I am getting nowhere. There is no literature on how to do something like this... It would have to be my first …

any idea how to get around this condition? using sql database explorer ... trying to gather a mere 17000+ records ... i'm getting a table is full error (i've been able to gather beyond 239,000 records at times) this same error appears in my delphi application using the same sql …

I am trying to alter some SQL to use parameters. I bypassed this earlier as it was just not working but am now heading back to tidy up. For some reason I cannot get this to work, keep in mind I am using Odbc: [code]SQLString = "SELECT * FROM Stories …

I have a VB program that needs to count number of events between two datetime values. Something like this: SELECT COUNT(*) FROM Report WHERE WeigthTime BETWEEN "Time1" AND "Time2" Time1 is now. I get it with "SELECT GETDATE()" I need to calculate Time2 by decrementing it for X hours. X …

Hi! I wish to specify more than one databases in my connection string in a vb.net project, in order to retrieve records from both of them. For example, I have 2 databases , database A and database B I wish to retrieve the city field from the emp tables of …

It's me again...the newbie. I have a web application that I am developing for a school project. Quick overview; the user submits one of multiple different types of "requests" and then a technican begins work on the project. Anyway; with the help of others I have gotten the EXTREMELY long …

[COLOR=midnightblue] HI all, I am very new to SQL server and have been working my way through a book to learn ASP.Net v2 and SQL by building a e-commerce site. There are 3 stored procedures which are used to implement paging from retrieving products from the catalog, which are either …

Hi Guys, I've created a recordset which is saved in a txt file using following code [code] Private Sub Command0_Click() Dim Conn As ADODB.Connection Dim Rs As ADODB.Recordset Set Conn = New ADODB.Connection Conn.Open "DSN=movex" Set Rs = New ADODB.Recordset Rs.CursorLocation = adUseClient Rs.Open "Select * from PESALES", _ Conn, …

I could use some help with a [B]SQL SELECT LIKE[/B] command. I have two TextBox'es that I am using as input for two different searches through a SQL database with the result placed in a GridView. It is important to note that the search can be performed from either TextBox, …

I am trying to connect to database using app.config instead of putting the connection settings in each form. Below are the coding that i used. It works in Microsoft Visual Studio 2003. However, it doesn't works in Microsoft Visual Studio 2005. It states that the System.Configuration is obsolete. Does anyone …

Hi, I'm designing a database for a company that retails computer products, phones, faxes and so on. As you can imagine, there are a number of different types of products, eg. hard drives, CPUs, routers, optical drives and so on. One of the requirements is that for each category there …

[code] import java.awt.*; import java.awt.Event.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.*; public class UpdateRecord implements ActionListener { private ScrollingPanel fields; private JTextArea output; private Connection connection; public UpdateRecord(Connection c, ScrollingPanel f, JTextArea o) { connection = c; fields = f; output = o; } public void actionPerformed(ActionEvent e) …

This is code for retrieve data from table Results. The output must display to user via SMS. Now the problem is I cannot call all the data from table RESULTS. Dim da As New SqlDataAdapter("Select * From Results Where Metric_Number='" & content1 & "'", conn) Dim dst As New DataTable …

Hi, all here is my question:- My application uses vb6 as front-end,ms sql server7.0 as back-end. i connect my apps with the rdbms using an odbc dsn connection. now i've created some reports for my apps using crystal report 8.5. the print is going well. now i want to export …

hello. how to do if when we double click at list view, then the information from list view will be appear at label. many times i tried but always debug (run time error '_2147217904(80040e10) 'no value given for one or more required parameter) . Private Sub ListView1_DblClick() checkConnection strSql = …

Please Help me how to use FOR_XML_NULL_TREATMENT Can u please provide a sample code.

I have created a new XML file and schema that is used to run sql scripts but I am having a problem doing a few things. below is an example of what I am hoping to create. XML file. [code] <root> <script> <name> Script for Upgrading </name> <file> C:\Files\Scripts\Upgrade.sql </file> …

Hi, I've installed Reporting services developer. When I browse Reports folder in IIS, I get: The request failed with HTTP status 400: Bad Request. error. What's the reason? Can anyone help me out? Regards, Shrinivas

hye...im having difficulities to retrieve data from one table. i need to retrieve data from few columns and multiple rows in one table and display it the data. is there any way of doin it? urgent help need!!

I am making a simple payroll program that keeps track of my hours, jobs, descriptions, etc. It also keeps track of the checks I've gotten. I have three main tables: Hours consisting of date, time started, ended, total hours, customer, job, description, Payperiod number, I know this one could be …

I can't find any DTS tool on MSSQL 2005 Express Edition Is there any tool that execute DTS tasks? I need to perform 2 tasks: - import a large Access file into MSSQL - deploy database to production environment Any help is welcome. []s

Hi, I'm working on VB.NET Express and SQL Server Express. I have a DataGridView control in the form, with 8 columns, of which one column, which has default values, is hidden and one column is already filled with default values. I want to populate the DataGridView with records that exists …

Hi all, this is my question :- I've created a table in ms sql server 7.0 using the enterprise manager. there i've a field named "address" which is a varchar type field. now in my vb6 apps i used a multiline textbox to write address. now when i'm trying to …

i just want to know if it is possible in SQL select statement to have more than one column to be compared for the searchstring(recordsource) like for example select * from [Tablename] where lastname like ... AND firstname like ... because the VB is giving me a run time error …

Can any one please tell me how to retrieve image that i have stored in SQL SERVER 2000 and display the image in datagrid in VB.net 2003? I am able to display text data in datagrid but the picture cannot be display (in datagrid the picture is not shown but …

Customer: customerId, customerName Order: orderId,customerId,product, date, productDefinetion I want to display the order which is the latest order from the customer and I want to display all customer Name Example: customerName product productDefinetion John Video bla bla bla Maria ------ -----------

hello all, I want to know that how to run or execute the sql server agent jobs in C# language.

[B]I've following database structure (just junk values)[/B] [CODE] [ChannelID] [ChannelName] [ChannelCatID] [RSSFeedURL] 1 YouTube 1 ret 2 GoogleVideo 1 ert 3 MSNVideo 1 rtertert 4 ABC 2 retert 5 YahooVideo 1 erter 6 CBS 2 rtr 7 NBC 2 trtrt 8 ESPN 2 rt 9 FOX 2 rtrtttr 10 AOL …

Hello, I'm just getting back into writing software again after being away from the field for four years. My background is in developing VB6 and Access. I'm teaching myself VB.Net and SQLServer and looking for a job where I can be a part of a team environment. For details on …

I need help with sql statement that includes two tables one table has id and name, lets call it tbluser second table has id and all other info, lets call it tblinfo Something like this Select id from tbluser where name = txtname Select * from tblinfo where id = …

Hi all, I have a form in which there is a drop down menu. The values from the drop down are populated from a database. When the user selects a value from the drop down, I would like the to display related data from a ms sql server database within …

hi, i have 1 prob. i created 1 desktop database application. which i wanted to deploy on the client machine. my client machine dosent have sql server installed on it , neither .net framework is there. so i used setup and deployment project for creating the setup for my application. …

how many triggers can be nested in sqlserver2000

Hi everyone. New to this web forum. Just looking for some help here. I am using Microsoft Visual Web Developer 2005 Express. I am wanting to create a page of names. This page of names will need to point to a template .aspx file, and insert criteria into 3 GridView …

hye there...anyone can help me out here...im having problem in running sql command its shows error : "sqlConnection does not support parrallel transactions" trans = conn.BeginTransaction() Dim strs As New SqlCommand strs.Transaction = trans strs.Connection = conn strs.CommandText = "Insert into StudentSMS (RecipientCode,RecipientNumber) values ('" & RecipientCode & "' , …

I need to SQL Query to get the value from database for every half hour or 15 minutes. E.g There are data updating in a table for every 1minute. I need to get the avearge of every 15minutes and give as single data. Kindly help me on this query

I’m selecting data from tables in a SQL Server 2000 data base, and putting the result into a Dataset. I’m writing the dataset out to a file in XML format using ds.WriteXml(myXmlWriter, XmlWriteMode.IgnoreSchema). The table names are in singular (i.e. table customer is called “customer”), if I have more than …

I’m selecting data from tables in a SQL Server 2000 data base, and putting the result into a Dataset. I’m writing the dataset out to a file in XML format using ds.WriteXml(myXmlWriter, XmlWriteMode.IgnoreSchema). The table names are in singular (i.e. table customer is called “customer”), if I have more than …

I have a data base with multiple Tables, columns and Rows I need to produce an XML file. I'm required to send ALL columns even those that are NILL. In SQL 2005 I can use FOR XML ELEMENTS ISINIL, however I'm using SQL 2000 so I can't get the NILL …

I would be grateful if anyone could let me know of an easy way of searching multiple tables for information. I would like to display any found results in a grid alowing the user to choose the correct one and have this disply in the main form. If this easy …

hi all, i was tasked to develop a records sytem that will store on a database probably sql server 2005. the main function of the program is to store records and be able to retrieve them to for report generation, and it should be efficient and fast when a query …

hi i need some help with the login authentication for for my website.i don't know how to do the admin , user and data entry side. how it will recognize the difference between them my table is [U]user:[/U] login password security level(admin,user,data entry) i'm using sql server2000 please help me