6,934 Topics
 | |
| | Hi, I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm not sure if that was the correct way doing it coz i seem to have problem … |
| | I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL … |
 | Hi all, I have an application written in C#, it connects to a SQL database using SQL Server 2005 Express. What I need to do is install my application on multiple computers on a network, but they must run from a single database on one of the machines, so I …  |
| | We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or … |
| | Greetings. How are all of you? I'm new to Daniweb, but heard of you through Mauisun. Anyhow, I have a copy of SQL 2000 standard, but it's an old school copy without reporting services. I understand that 2000 now comes with RS for free... does anyone know where this "free" … |
| | Hello all - I've got an interesting problem that I can't seem to solve, so any input on this would be greatly appreciated. I have a group of web pages. I'm passing several variables back and forth between those pages successfully. One of the variables is called sntime. Essentially, it's … |
| | I am programmer.Have been using VB 6 and Access.I now want to start using SQl server.Somebody to assist me on how to connect. Thanks  |
| | Greetings all! To get to the point, I'm having issues accessing SQL databases. The specific error is as follows: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here's the setup: The workstation(s) … |
| | Hi all, DECLARE @STA as char(50) SET @STA = 'TT' SELECT * FROM ABC_TBL where ABC_Filed in (@STA) if i have multivalue in parameter @STA, like 'TT', 'DD', 'AA' so how can i write my statement? i only need to pass one parameter with multilist, so do anybody know how … |
| | hi, can anyone help me how to redirect sql query result to a file in shell scripting using sqlplus. Is the below code snippet corrct: sqlplus -s username/password <<- ! select * from testhil1; quit ! > rony3.txt |
| | Hello Everyone, I need to complete a task, although I am not quite sure how? The task is to create a very unusual search system for a car rental site. There is a database of cars that the rental company possesses, and when the user specifies the rental period - … |
| | Hi, Im a NIIT student and I have just given my MS-SQL Server's examination and now I have an [COLOR=#555555]opportunity to give an examination for the same [COLOR=#555555]course conducted by Microsoft itself. Our [COLOR=#555555]faculty tells us that it has [COLOR=#555555]round about 35-40 question of 1000 marks but the problem is … |
| | please guide me how to acess database for mysql thr' php, i tried a lot but getting error like cannot open the page or c:/program files/ apache/htdocs/dbconnect.php Could not connect to database why these error, i am using mysql 5.2.0, php 5.2.0 and apache 2.2.3, are there any setting needed?? … |
 | Hi, do anybody knows how to connect in sql mdb2 in Visual Basic 6 I only know how to connect in php... this is my sample connection in php.... #======================================# $mdb2 = connectdb(); $sql = "SELECT <fieldname> FROM <tablename>" $results = selquery($sql,$mdb2); closedb($mdb2); #======================================# do anyone knows how to do … |
| | Is it possible for VB6 to establish a direct remote sql connection and make a query in the remote sql database? If possible what are the reference do I need to add to make it working? Somebody please give a me a good example... from establishing a connection, query in …  |
| | Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get … |
| | Hello guys, I have a Calendar control that I am working on. I am having problems with the appointment portion of it. Everytime you click on a time slot and type, it adds an appintment. Here is the code I use to add the appointment. [code] [COLOR=#008080]Appointment[/COLOR][COLOR=#000000] m_Appointment = [/COLOR][COLOR=#0000ff]new[/COLOR][COLOR=#008080]Appointment[/COLOR][COLOR=#000000]();[/COLOR] … |
| | Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …  |
| | I had moved my question on VB 4/5/6 category... sorry i made a mistake... |
| | [COLOR=#191970]The data table looks like this date num1 num2 num3 num4 num5 num6 1/1/06 1 45 32 21 15 48 SQL script 1 should be able to do the following show the Top 3 number pairs another words if the pair 45 and 15 shows up 98 times and 32 … |
| | Howdy everyone again, Just thought that i would post another snippet for those interested in working with databases and C# in the windows forms environment. I did some searching on this and found that there was not really any clear concrete answer on how to do this. After some searching … |
| | i don't see anything wrong with it... what's the deal? this is the results page that displays the results of a search query. [b]Parse error: parse error in ../../../../merchandise/testreg/results.php on line 21[/b] [code=php] @ $db = mysql_connect("localhost", "apache", "R3GP@SS!"); if(!$db) { echo "Error: Could not connect to the database. Please … |
| | Gentlemen: :?: Sorry to have posted twice, but I really messed up the title. Can anyone send me to the right contact for some SQL Topology assistance? I have posted on several SQL Forums and everyone seems to dance around this topic. I need to find out the proper way … |
| | I've did a program using vb6 to connect to oracle9i, i can establish the connection, the problem is when i execute the query in oracle sql*plus, it can execute successfully, but when run in vb application, the records affected return 0, it do nothing for this query, any setting need … |
| | for some reason or another, my AUTO_INCREMENT command won't work in my sql table for the column named 'ID'. i have no idea why. it SHOULD work, but it doesn't. anyway, that's not really much of an issue. however, i have decided to take this opportunity to learn something new … |
| | I have successfully got the data reader connected but i cannot figure out how to write the values to an array or variables on a windows form created in Visual C# Express edition all examples use the console. Can someone show me an example of how to write these values … |
| | Hi all, I am working with a project which includes Crystal Reports in Vb.Net and SQL Server2000 as Back end. The code in button click is [code] str5 = "D:\AttendanceReport.rpt" If Not IO.File.Exists(str5) Then Throw (New Exception("Unable to locate report file:" & vbCrLf & str5)) End If str6 = "SELECT … |
| | Hey I am just starting to play with some SQL stuff after upsizing a old access database. What i would like to do is be-able to pull information out of the SQL database and display this on a web site. The query i want to use i have built using … |
| | How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative? |
| | Hello there, I need a help. I have a computer that has windows 2003 server installed and I have 9 clients in domain control that use SQL Active Directory, an aplications in Visual Basic. The problem is that whenever they try to use it is soooooooooooo slow and if I … |
| | Hi, I have an MS SQL 2000 database with a table that is used to store the header information on product returns. One of the fields in the table is a true/false field that indicates if the return has been processed (become a credit note). Can anyone tell me how … |
| | [B]hi all,iI design database by sql by using visual studio 2005,i need to have pdf or any refrence guide to know how to write select,insert, delete statement ,could you help me[/B] |
| | Please let me know the code to populate the data from Table to Forms. What's the code for assigning values to Form buttons? |
| | Does anyone know the exact query for IN in the following senario... I want to search for 2 columns for 1 mobile number (mobile, alternate mobile) I am using the following query [code]strSQL = "select * from tblcontest where bar_mob_no IN('" & sSQL &"') or bar_alt_mob in('" & sSQL &"')"[/code] … |
| | Hi every body.This is siva from china.My s/w using postgres sql data base.Hw to use replication concept in postgres sql>if any body knows pls reply me.Advance thks  |
| | Hi all... I have an issue that I've been puzzling over here and there for about a week. I should say that I'm new to ASP.NET and new to this forum. I Had some experience with VB6 some years back then my career took a left turn. Now I'm back, … |
| | Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes … |
| | Hi, My goal is to perform a single SQL query (“select xxx from yyyy etc etc”) to a Database over a LAN, using BORLAND C++ 4.5 and managing USERNAME and PASSWORD. I tried 2 methods so far : Method N.1) I used “Tquery”, TdataSource and TDBedit components linked togheter and … |
| | up to 3am last night, any help appreciated!!! have a html form created in dreamweaver. want users to complete their details on a form. do not need a dynamic page or sql d.base as only one way traffic. i just want to receive date in either email or excel format. … |
| | [COLOR=#0000ff]Hi , Im new to asp.net and im need help connecting to an sql server 2005 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. Could anybody tell … |
| | Hi all, God Bless U, [B]Thursday, October 19, 2006[/B] [COLOR=red][B]first i am writing the my problem again......:!: [/B][/COLOR] i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer … |
| | Hi all,:confused: God Bless U, i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer 4 Goeffery Empl0yer ------------------------------------------------ Here the identity column is the first one. Now … |
| | I am trying to design a small database project for school. I have gone over this for about a gazillion time, and it seems to have turned into a challenging maze. This is from the book "Visual Basic 6 How to Program." Anyway, where is the problem: Define a complete … |
| | [COLOR=navy]Hello, this is my first post, so thank you in advance for any help you may be able to give! [/COLOR] [COLOR=navy]I have an ASP page that I need to have pull some information from a SQL table and display. The query in question is very simple: [/COLOR] [COLOR=navy][code]rs.open "SELECT … |
| | [B]Intro[/B] Here is how to set up Microsofts MSDE for personal development. [B]Getting started[/B] Download the MSDE from: [url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url] Select 'SQL2kdesksp3.exe' and save it to your computer. Double-click on the SQL2kdesksp3.exe you downloaded. Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt. Start > Run … |
 | what sql is?what can we make with SQL?do i have to know PHP BEFORE LEARNING SQL ?????? |
| | Hi, I've got a problem with searching for record(s) that match the staffID in my "Staff" table in the database. I have a string named mstrSql, a txtStaffID text box and a sql statement that goes [code]mstrSql = "Select * from Staff where staffID like '" & txtStaffID.Text.Trim() & "%" …  |
| | Hi every one, I have a little problem in php. problem is that i want to search mysql table by php coding. In php i want to use Drop down menu And a text field. I have mysql table name is guestbook, now i use two entries in dropdown menu …  |
| | The following SQL results in an "invalid procedure call" message. SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1 where (((ViewtimeHCPick1WRes1.X)>2)); SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1; works fine. ViewtimeHCPick1WRes1 is a query. X is a calculated field that results in a number of format x.y or x. Any suggestions as to why the where clause is … |
| | Dear All how can i connect my ASP page to SQL server database in a local machin i get this error Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. TESTS FAILED! |
The End.