6,934 Topics
 | |
| | I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same …  |
| | Hi all, I create a database on SQL 2005 Express edition and link it to a C++/MFC application as follows. It wont gives any compile time errors. But at run time, it gives an error. Here are details. Link the database in OnInitDialog() here is the code [code=c++] BOOL CSRFDBDlg::OnInitDialog() … |
| | Just a question on database setup and application. If I have one database, with multiple tables within it, at what point does it become prohibitive. 50 tables? 100 tables? Is it a memory thing? How can I check? Thanks, -JP |
| | I have Vb SQL Software I want apply it on a WAN network Is it possible.please give an explanation for me. How a WAN network established |
 | Here's the situation guys, I make a program that only in one computer the data will be saved. what I mean is I put this program in two or three computers then one must be the "server"? Can you guide me how to do this... here's my code to connect …  |
| | Hi all, Can you guys explain how can I connect a SQL database to a C++ application(actually my application is a MFC) through ADO.Net I've use Visual Studio .Net 2003 and SQL Server 2005 Express edition(because I work on WinXP) If you guys have a simple example, its better to … |
| | Help me on this, I'd like to know how to use SQL in VB?  |
| | Hey there, Recently, i am working on one of the community website, which is developed in Asp.net/sql server. I want to implement image verification during registration process so as, there won't be any automated registration.. Can anybody help me to program this utility?? |
| | Hi guys, sorry in advance for the following question: So, I've downloaded the adequate SQL Server 2000 driver, from the Microsoft's website. I've installed it to C:\JDBC\. I've set the classpath variable using the command promt by typing: set CLASSPATH=.;c:\jdbc\lib\msbase.jar;c:\jdbc\lib\msutil.jar;c:\jdb c\lib\mssqlserver.jar; The problem is that the following error message appears, …  |
| | Weird ASP/SQL Problem Consider the following HTML Form, it has a textbox and a search button. [CODE]<form method=post action="search.asp"> <input name="txtName" type="text" id="txtEmail" /> <input type="submit" name="Submit3" value="Search" /> </form>[/CODE] The search.asp page: [CODE]select * from tbl_group_contact where userName ='"& request("txtName") &"'[/CODE] if I put this query in the search.asp …  |
| | TITLE: Connect to Database Engine ------------------------------ Cannot connect to CHESF-HIMRIO\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: 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 default settings SQL Server does not allow remote connections. …  |
| | Hi am Raphael: I have developed An Access xp database with sql server as backend my problem has only been that if I want to deploy updates to clients, I Must go to the client and update tables Sp,views. I have tried using text files to update but so far … |
| | Can a VB6-SQL2000 softwre can execute in WAN network.How it is possible what is the procedures to create a WAN network |
| | Hi all, I have been trying to drop a stored proc for sometime using SMO. I can create with ease but can't seem to drop. Any ideas? I thought it might be permission but for testing used SA account. No luck... [CODE] private void btnCreate_Click_1(object sender, EventArgs e) { SqlConnection … |
| | Here I am again with my next sql problem. I'm not sure if I can use insert into for what I need. What I want to do is the following. My tables I have tblreminder with userid workid workdate I have tbluser with userid and username My textbox I have …  |
| | 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 … |
| | 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 … |
| | Hi I am trying to get to grips with querying an access database and displaying the information. I have started with a coun sql command to just return the number of rows but wanted to display this to the screen but each time it shows as null - there are … |
| | 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 … |
| | 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 … |
| | Hi everyone! I am very new to programming and SQL. I have created (designed) an application for a school project; that now needs to be coded to be functional. I have been able to pull data from SQL without a problem; however, I am stuck on inserting data into sql. … |
| | [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 … |
| | I am trying to set up a java server page and mysql. I have installed jdk and all of the neccessary tools and drivers. I am using Tomcat for the servlet container. I have also set up an account with a password on mysql. I think that the only issue … |
 | [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) …  |
| | While surfing the net, McAfee virus window popped up. Deleted file and after that, desktop background was changed to white. Unable to change by going to desktop display properties. :sad: Running XP Home with SP2. Did virus scan but nothing showed up. Any ideas? Hijack This log is below. Any … |
| | My query is below. I need to evaulate each row returned (and provide a "label" - shown with an astrick) based on the values in the 3 date columns and I'm stumped as to how to do it. Here are my conditions and labels: Action_Dt = Effdt AND Action_Dt < … |
| | Hi, I keep on getting the following error message: Software error: DBD::mysql::st execute failed: 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 '-50,50' at line 1 at arp3-data.pl line 48. My host is …  |
 | Hello, I have installed VB6 and SQL * plus (Oracle 8i). I want to connect VB6 and Oracle. That is, I want to preapare an application where in, if I enter a value in the text box, it should get appended in the table in SQL. I know how to … |
| | 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 …  |
| | Hi all I need urgent help to complete my project I am unable to update my sql database.I have to update the database using textbox value as primary key and the other tools are textbox,dropdownlist and calender which i have used I am doin project on ASP.NET using vb.net so … |
| | hello all, I want to know that how to run or execute the sql server agent jobs in C# language. |
| | 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 = … |
 | Peace, I saw a chat Program on the Net... The Messages In it automatically shows itselves without reloading the web-page.. I saw that and I wondered.... Does Any one know how to do that? |
| | 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. … |
| | Hello all, Am new here, so please bear with me - if i dont get some things right! Okie Dokie. Lets get started. I was working with Tomcat/Servlet/ODBC. I created a table in MS Access. Created the Connection, Statement, query and everything. I want to retrieve the information from the … |
| | |
| | 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, I have a report desigend in Crystal Report 11. The report has 2 sections which is divided in between by a simple dark line. The report's left side has the fields of TABLE A and will be used to show records from TABLE A only. And the report's right … |
| | Hello All, I am deleting a database but I am not seeing any entry in server logs or in event viewer. and same thing is happens when I am deatching a database. Can any body tell me the way through which I can know when a particualr database was deleted … |
| | First, I consider myself a novice in Mssql. I've recently began the revision of a website that uses MS Sql Server 2000. In a effort to set up a working environment on my pc, I asked to get a copy of the sql server database. The response was something like …  |
| | plzz anyone tell me does vs.net 2005 supports sql server 2000 coz iam not being able to connect it  |
| | rsYear1.Open "select count(ComplaintNo) from tblcomplaint where year(cDate) ='" + Year(DTPicker1.Value) + "'", ConSQL, adOpenDynamic, adLockOptimistic hi if u find any fault here reply me immediately rsYear1.Open "select ComplaintNo from tblcomplaint where cDate ='" + DTPicker1.Value+ "'", ConSQL, adOpenDynamic, adLockOptimistic i already try this also plzzzzzzzzzz |
| | Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table … |
| | Am new to SQL and PHP. Only been using them for about 3 weeks to create an e-commerce site for some friends. I have been trying to set up a link to paypal's shopping basket feature from my listing page. I'm trying to get the link to appear next to … |
| | Hi Friends! I stuck somewhere while developing my ERP application on VB.Net here i require to create a table in SQL Database from my Button Click event, for example ( there are 1 text box and a button on a form, we need to enter the name of a table … |
| | Hello This Is My Tutorial Over "SQL INJECTION" , Hope It Would Help Out Many Out Here. Basically SQL INJECTION Is A Attack Over Weak Programming And Can Affect Major Over The Databases. No Lets Jump Out Here: Consider a Form As Shown below, [url]http://www25.brinkster.com/vinothbabu/login.asp[/url] The Form Accepts a Username … |
 | Hi , Im new to asp.net and im need help connecting to an sql server databse in vb.net. I tried so many things and its still not working. I also need hep with inseting, updating and deleting data from a webform into the sql server database. |
The End.