[microsoft:sql-server] Forum Topics

I have three tables that are linked as follows: SOShipheader.shipperid, SOShipheader.invctot SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge Here is what I want the report to look like: S80709 150.00 abcpart 3 40.00 defpart 1 10.00 misca 20.00 S80710 30.00 defpart 1 20.00 miscb 10.00 I have group1 as soshipheader.shipperid …

I am using a ADODB connection to connect to an access database and am using an SQL string as the comandtext....but i need to check the validity of wat i have typed.....here is the sql statement.. [code] dim cmdcommand as new adodb.command With cmdCommand .ActiveConnection = conConnection .comanttext = "select …

hi help me out. i get error msg when i try to "Test Driver Connection" from WebLogic 8.1 with SQL Server 2000. do i set any privileges from SQL Server for WebLogic 8.1 server to eastablish connection. Thanks in advance Deborah D

I developed a web interface using ASP.NET and a database using SQL Server 2005. I created connection to database using SqlDataSource control. I also used GridView control to display data. Using Visual Studio I can see the query results using a browser on a local machine. What I want now …

hello, I have SQL server 2005 installed on my computer. How can i construct a database for my new website? From where can i start my process? I didn't find any loop inside. I have full of ASP pages. Hope somebody would help me AV

I'm creating a web application in VB.NET 2003 that connects to a SQL database... how do I display the data in separate controls (TextBoxes, labels, etc) instead of in a data grid? Thanks, Windows 3.11

Hello to all I am calling a sql stored procedure in VB. If we pass the Parameter as '1' then we have to add the item in listbox, the value is updated else list box should be empty.how we have to write the code for this with regards sma

could any one plz help me for this query. i have tried a lot but only the first one is working. see my code: (1) CommandText = _ "SELECT sr.ResponseAnswerID, count(sr.RespondantID) from SURVEY_RESPONSE sr INNER JOIN ANSWER a on " _ & "sr.ResponseAnswerID=a.AnswerID where a.QuestionID= 284 " _ & "group …

I'm having a terrible problem using two drop-down forms in the same asp page. No matter what, the values for the second form are not passed to the SQL database. I've confirmed this by commenting out the first form and then the second form works fine. I'm sure it is …

hi everyone im wondering how will i connect a VC++ program with an SQL server. i would like the program to have direct access with the tables/data. if you can provide a sample source code would help. thanks.

Hey all, just a quick question regarding the number of possible connections using xp Professional Edition to an SQL database... (at the same time, from different client machines)... I've been searching the internet and haven't been able to find anything useful for this question! If you could help that'd be …

I'm using asp and use the Connect style to my database, it works perfectly on my virtual localhost PC, but when i need to use the server i have my web page it doesnt work, then i says i need to create a database as well using their MsSql "MyLittleAdmin" …

Hai guys, i want to know how to create a database in sql server for creating a database in sql what should be download in my system. and how to download it .my system has windows xp proffessional. please tell me how or give some website name to know detail …

Hi! First of all, im from sweden so my english isn't the best :!:.. I read a guide "How to make a simple login page" ..(something like that) But i need help with my languages(aspx,C#,sql2k5) The problem for me is how to make the SP for checking if Username and …

Forgive my ignorance, I am new to RDMS and SQL both. My question is this: I have 2 tables, one a primary table and 1 a relational table table 1 has ten rows valued 1,2,3,4,5,6,7,8,9,10 table 2 has 4 rows keying from table 1 row1 = 1 2 row2 = …

Hello, I want to know that how to run or execute the SQL DTS Package in C#.NET. Any person can help me. please...

Hi all , I'm new to EJB Programming. I need your suggestion of which type of Entity bean i can use for my task . Here's the task i need to accomplish : ============================ I have data in XML now i need to store in SQL SERVER tables which i …

Hi, I have a excel sheet "Biodata.xls" (already containing data). I need to load this data to a table "Details " in sql server. I have done it using the DTS wizard. Is it possible to do this through some code in c#? Can somebody help me out....... Thanks, Aswathy

Hi, I have to create Graphical charts and text format reports from Visual Basic 6. This will run as a batch program. The data is extracted from different databases in SQL Servers. Pls assist for writing Graphical Charts and text's into MS word from VB6 Code. Thanks & Regards. Ruth.

Hi All. I am now doing this tutorial step by step ; [URL]http://www.azroc.co.uk/csharp/asp_net/asp_net_data_access_layer2.htm[/URL] ----------------------------------------------------------------------------- It shows on how to create a dataset and retrieve it.Then it will be show in the browser.But then, when try to run, it says got error at my aspx.cs file. Well,I run the codes by …

[COLOR=#000000]Hi, I have 2 tables a parent and a child. I want to insert value from C# (Windows Form) to DB(MSSQL) in VS2005. Although I’m sending data to both of them but the new record will be generated only in parent table but not child. At the first I thought …

Hello Everyone, I have a DTS package, which has been working fine for few years. it runs once a month to get information from different databases and save it into the destination database. Now I get this error: error source: microsoft ole db provider for sql server error description: could …

On Page One of my application, I have a dropdown list that populated by a SQL query. The list displays the "Text" of the items on the list, but the values (that will be passed are the indexes from the database table) . The user can select multiple items from …

Hi all, I got a SELECT QUERY name "Q: Naming Assignments" in MS ACCESS which do the naming assignment for all the products in my company. In this query, i inner join several tables comprises (T:Supplier Code, T: Manufacture Date, T: Country Code, T: Material Code, T: Assignments , T: …

[COLOR=black]Hi,[/COLOR] [COLOR=black]I want to send the FK from parent table to child table by getting the object with executescalar and converting the value of it to string and then to integer finally pass it to child table. The problem is that the converted data will lose the information. I mean …

Well, Iam using asp and sql server to store data in database. I have a work to show data to all users. But data is very fast and it must update in a second... so im updating it in a second on a webpage....but ofcourse on internet, it disappears before …

I'm having a problem querying data from two different databases on a SQL 2000 server. We have two databases, a main data db, and a separate security db that has login info. Database logins for the data db DO NOT have access to the security db. I have a function …

[COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR]

Hello, I have tables which have relation. I want to know how can I set the PK value of table A which is the FK of table B while I can’t have “SET IDENTITY_INSERT BATTERY ON” for two table at one time? Thank you,

I am developing a web application using Visual Studio 2005 to build the web interface and SQL Server 2005 to build the database. I need to be able to access the database queries via the web interface. What I want is that after accessing the website (via its address, say, …

Hi, I am designing a small advertisement management program in asp, and Sql Server 2000 as database. My table has the following fields which are pretty self explanatory: bannerId, bannertitle, bannerurl, imageURL, bannerpirority bannerId = Autoincrement to generate unique id for a banner ad bannertitle = String title of the …

I just started my first web design job and am a little confused. The company I am working for uses templates to design the e-commerce website. The developer is able to add more code to the templates to further customize the site. The templates seem to use VB for the …

By using "comunity server" ,I can't make a forum. How can I get one? I get problems between the server (SQL SERVER )and database login. :confused: Thanks

Hello everyone, I have a MSSQL db with PHP front end. The data in the table is similiar to: "Two spaces" with 2 white spaces in the middle. When I use this code: [code] $sql = "select Name FROM Name_TBL WHERE Number = '$Num"; $rs = mssql_query($sql); $RT = mssql_fetch_array($rs); …

Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary

Hello everyone, This was posted in the PHP section also... I have a MSSQL [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]db[/URL] with PHP front end. The [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]data[/URL] in the table is similiar to: "Two spaces" with 2 white spaces in the middle. When I use this [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]code[/URL]: [code] $sql = "select Name FROM Name_TBL WHERE Number …

Hi, I'm a newb of ASP Server side development area. I've just installed SQL server 2000 to my computer. I think it is for database design. Can anybody clarify how is it work, how is it possible to design? I'm well aware with HTML, CSS, ASP, Java applets etc. Hope …

OK, I'll admit straight away i'm new to SQL. I've got a SQL 7 Server with two small databases running. I have been able to backup both to file. However when I try and "restore" them on a test SQL 2005 Server, it errors because the file & folder structure …

[COLOR=midnightblue] Hello All, Apologies if this is the wrong forum section. Some help and advice please regarding a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]SQL[/URL] Report. It is for a Feedback form and below is a quick mock up of the DB diagram [IMG]http://img219.imageshack.us/img219/4102/feedbackbr8.jpg[/IMG] tblFeedback is populated with a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]Customers[/URL] details and the tblResults with the …

Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls …

Hello, I was looking around for some tutorials about how to backup my database in my hard disk using [B]SQL Server 2000 Enterprise Manager[/B]. Can someone explain me in a friendly and step-by-step method? (screenshots preferred) Thanx so much in advance

Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls …

How can i add, delete, update using datagrid?currently, im using Sql Server as the database.

I want to select single value from Table and display in lable. I wrote a program :- [COLOR=darkgreen][code] protected static string ConStr = "Data Source=URJIT6;Initial Catalog=Employee;Integrated Security=True"; protected SqlConnection NewCon = new SqlConnection(ConStr); String QStr = "SELECT Username FROM Register WHERE LoginID=' " + LoginIdtxt.Text.ToString() + "'"; SqlCommand SqlCmd2 = …

Hi Friends, I have one strange problem the if conditions are not working, it is not supporting at all. Any idea why ? iam using ODBC_CONNECT() with MSSQL and PHP. Regards

[B]Anyone can help me as soon as possible. I want to create table on my database. i tried Following code Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim ConStr As String = "Data Source=Urjit6;Initial Catalog=MyDB;Integrated Security=True" Dim MyCon As New SqlConnection(ConStr) Dim SqlCom As New …

Hello... :eek: Sorry, I'm new here and new to SQL (please dont kill me for asking) What I'm trying to do is write a script to backup a few databases in SQL. I know that I can just right click on the db and back it up, but how is …

how i can convert different packages in mssql 2000 to 2005.

Hi I have a "Repair Record Entry" table and form where the form is used to enter the information and it will be saved in the table then. I placed a command button with queries written at the side of the textbox on the form so that i can be …

I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx