6,934 Topics
 | |
| | [I]<<split from [URL="http://www.daniweb.com/forums/thread289067.html"]here[/URL]>>[/I] As tha same i 2 had tried but t is coming error like [B]Default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, [COLOR="Red"]error: 40 [/COLOR]- Could not open a connection to SQL Server)).[/B] |
 | I have a client and a server - the client sends the server a message, and depending on what message is sent, the server will perform an action and then reply to the client. Most of the actions that I have implemented are working. I need help with one of … |
| | this is 'pemaju_semakan2.php' coding <?php include("db.php"); ?> <?php $IDSykt=$_POST['IDSykt']; $query = "SELECT * FROM pemaju WHERE PJ_SYKT_NO='$IDSykt'"; $result=mysql_query($query); while($row = mysql_fetch_array($result)) { $IDSykt=$row['PJ_SYKT_NO']; $NamaSykt=$row['PJ_SYKT_NAMA']; } this is 'db.php' coding <?php $hostname_connection = "localhost"; $database_connection = "zaza"; $username_connection = "root"; $password_connection = ""; $connection = mysql_pconnect($hostname_connection, $username_connection, $password_connection) or trigger_error(mysql_error(),E_USER_ERROR); ?> …  |
| | Is it allowed? What I mean is, if I have two queries? Like I need to read a dataset to populate a gridview and other than gridview, in one form.  |
| | I'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information. All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and … |
| | Hi I need an urgent help...... I Have made a project on C# where i have use MS-SQL as a database....after that i have published the program which creats exe of my program.......after creating exe 1) I download .net framework 3.5 to friends computer. 2) Then i install MS_SQL Server … |
| | SCENARIO 1 : I have 3 projects in my solution: 1) Web Project (Presentation Layer) 2) Class Library Project (Business Logic) 3) Class Library Project (Data Access Layer) Following are the dependencies among these 3 projects: 1->2->3 (It means I have referenced PL in BL and BL in DAL. In … |
| | I'm tyring to connect to the sql server on my lcoal machine and have this error. "An error has occured establishing connection to the server. Failure may be caused by the fact that under the default settings SQL server does nto allow remote connections.(provider:Named Pipes Provider,error 40 - could not … |
| | I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column - hi, how are you, … |
| | Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " … |
| | Hi I need to know, is there any option to use For loop instead of While and ForEach to retrieve the result. While Loop ----------- [CODE] $query = "SELECT name, subject, message FROM contact"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "Name :{$row['name']} <br>" . }[/CODE] instead to … |
| | I have this error when I run my system in XAMPP but it works succ on WAMP.. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\xxx\xxx.php on line 29 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\xxx\xxx.php on line 38 My coding: [COLOR="Red"]7[/COLOR] … |
 | Hi I need to write a sql script to split a string in two or more parts. e.g. I have a string: "tag: key1, key2, key3" I would like to use the ":" as a seperator and thus end up with two strings: "tag" and "key1, key2, key3" Is this … |
| | Hello ppl, I have a mysql db and i want to know how is better to use queryes on my website in the table favorite i have many rows with id (some numbers..) and fav ( img1 img2 img3 img4 img5 etc..) and a table named img where the first … |
| | Hi I was wandering if sql tables can determine the order in which forms appear in a delphi application and if so how does it determine this order and will I be able to go in and edit the order. Thank you in advance |
| | So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they … |
| | Boas. Estou com uma dúvida para o qual preciso mesmo muito da vossa ajuda. Criei um report que inclui dados de 1 trabalhador (id, nome, residencia, bi, categoria profissional, etc...) e preciso de fazer o seguinte comando SQL: [B]SELECT * FROM Trabalhadores WHERE id_trabalhador = ' + valor + '[/B] … |
 | I have this long winded query [code=sql]select i.id,i.name, i.item_type_id, (select it.name from items it, relations rel, relation_types relType where it.id=rel.to_id and rel.from_id=i.id and rel.relation_type_id=relType.id and relType.name='CityCtountry') as cityCountry from items i where i.item_type_id=2;[/code] Cut the long story short, we inherited database from customer that hasn't been happy with other company, … |
| | Sorry I can't think of a better Title, I have an Invoice Table, Where The Structure is: [B]InvoiceID, ProductID, Qty, Sum, Location, etc[/B] Primary Key is InvoiceID + ProductID A single Invoice can have more than one Row so a single invoice will look like this: [CODE=Table]InvoiceID | ProductID | … |
| | I have been using the code below to edit SQL database fields from the data stored in a dataset. Problem is I have to repeat this long code for each database field to be edited....I find this very tiring...IS THERE A SHORTER WAY OF EDITING SQL Database FIELDS. (Am using … |
| | I run a non-profit association bulletin board using vBulletin software. I have been unable to find a vBulletin coder to help me with a MYSQL query. Seems straight forward to me. I have a csv email file of paid up association members. I also have vBulletin members/users who might or … |
| | hello everyone i have been trying to run my ejb-jsp code using j2ee server and have connceted to oracle using sun.jdbc.odbc.jdbcodbc bridge driver. but i am encountering this particular problem again and again and no data is inserted into database Error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed … |
 | hi there:twisted: i'm verry new here but i hope that there is sombody here that can help me with the following i have a fusker script called fusker.ne build in in a verry old xoops engine i wil use this script again but there is a verry hard to understand … |
| | I want to use rdo with/without using a sql, ado without using sql and dao using sql for my application programming can you show some simple and understandable examples |
| | So far progress overall has been going well in general on my pet project I call the TAXA project (nickname for taxonomy). The heart of it is a botanical tree on all the woods of the world. Since viewing it can make it easier for any of you to understand … |
 | I need help. I have a SQL Server database that will store information for events that will be taking place. The sql database looks like (see attached). I am fairly new to programming so I need a lot of help, please. I need a web page that will allow a … |
| | Hi everyone, first of all, sorry for my english... I'm in this situation: I have a table in my database named products with the fields [B]id[/B] and [B]model[/B] in it. Now, I need to get 'all' the products but with different model names and each result represent a valid product. … |
| | Hello guys! I'm trying to make a script for a school website, so the principal can send mails to all of his students, teachers or other admins, it should be very simple but the page just keep coming blank or sending me syntax errors. Right now it's showing the following … |
| | Hello all...incoming newbie question. I'm new to building desktop apps after a couple of years using ASP.NET online. I'm using MS Visual C# 2010 Express to play around and learn with. In order to test something that would be of real use to our company I want to be able … |
| | I am running a Query that throws "All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. " in my code, yet I can run the same query in my query browser directly on the server and it works … |
| | TITLE: Connect to Server ------------------------------ Cannot connect to CHATHURA-PC. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: … |
| | Does anyone know a way to fire a trigger to launch a stored procedure after a BCP?. We have a hot folder that we would like to drop files into, then have BCP pick them up and import them. Once the file completes the import, I would like to run … |
| | Hello guys! I'm trying to make a script for a school website, so the principal can send mails to all of his students, teachers or other admins, it should be very simple but the page just keep coming blank or sending me syntax errors. Right now it's showing the following … |
| | I have a database query that I'm trying to build. Within this query I have 2 columns (Amongst many). Column X is 3 statuses (O, I, E). Column Y is 2 options (W, W/O) I'm trying to build a report that counts the variations. Ultimately I'd like a simple table … |
| | Hello to everybody I have a problem with a MYSQL query and I almost got it but am stuck for a while now. I would appreciate if anyone could help me or point me in the right direction. I have 3 tables: [icode][B]t1 (products)[/B] id | name ---+------- 1 | … |
| | I am trying to just Insert from my script but I keep getting :: "Conversion from string "INSERT INTO [PURCHASE_ORDER_OFFI" to type 'Double' is not valid." Here is my insert code... any ideas... this is driving me crazy today! [CODE] Protected Sub linkOfficeAddRow_Click(ByVal sender As Object, ByVal e As System.EventArgs) … |
 | I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so … |
| | I want to save image from Picture box to SQL Server DB. I am trying to do this using the following code but cannot able to do so. Please help. My Code Snippets are as following: Dim fs As FileStream = Nothing fs = New FileStream(picPhoto.ImageLocation, FileMode.Open) Dim fi As …  |
| | Hi guys, I have a table that outputs all my contacts via a while loop from my database. my syntax is like this: [CODE]SELECT * FROM contacts WHERE id = $_SESSION['user_id'] ORDER BY name ASC LIMIT 5[/CODE] that pulls out all my data and only gives me 5 results. Now … |
| | i wrote a software which would work perfectly fine on vb.net with connection string: SQLConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename='" & a & "';Initial Catalog='" & f & "';Integrated Security=True;User Instance=True" but if i try and run it on a pc with sql server 2005 installed it fails to run what changes … |
 | I would like to know why sql query for month and year is working, and i[B]s not working for day[/B]: [CODE] string myQuery = "SELECT StudentName FROM Students WHERE " + "YEAR(Birth) BETWEEN @yearFrom AND @yearTo AND " + "MONTH(Birth) BETWEEN @monthFrom AND @monthTo AND " + "DAY(Birth) BETWEEN @dayFrom … |
| | hi there, my project is a desktop application, i am trying to transfer(upload) a file(can be excel,doc,txt pdf) to another sql server in another computer in the same network how can i do this in C#.net desktop application, i am not using web service or asp.net how can i do … |
| | I am trying to populate a SQL entry with data from a php script but it doesnt work. I have the config file set up right and everything. This is the code I have [code] <? include_once "secure/dbconfig.php"; //check md5 $SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxx'; $sig = md5('userId'+":"+'appId'+":"+'SECRET'); if($_REQUEST['sig'] == $sig) { … |
| | Hi all, Thanks for taking the time to read my post. I've got a complex SQL query that outputs categories, their related categories, and product name(s) and image(s) related to the main category. To resolve cross-join effects, i was advised to use group_concat on product information at the end of … |
| | ive been able to succesfully link a mdf databse to a vb.net program.My program runs flawlessly but if i change the location of the database from e:\new\xyz.mdf to c:\new\xyz.mdf then it throws an exception : System.Data.SqlClient.SqlException' occurred in System.Data.dll [CODE] SQLConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename= e:\new\xyz.mdf;Initial Catalog=xyz;Integrated Security=True;User Instance=True" [/CODE] And … |
| | Hi everyone I am trying to develop a friend system where you can view friends who you are friends with. I have been able to get it to show one result but it wont show any other. Please can someone tell me what I am doing wrong. Here is the … |
| | Can any one tell me, what is the difference between SQL and MySQL? |
| | Hello. I am using Easy php i am trying to connect with the following code [code] <?php $con = mysql_connect("localhost","admin",""); if (!$con) { die('Could not connect: ' . mysql_error()); } // some code ?> [/code] getting error as follows Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'localhost' (using password: NO) … |
| | Hi there, The program in hand must retrieve a bunch of data from an SQL Database (currently stored in a DataTable), fiddle around with the data, and then upload the changed data to the same SQL database. Everything works fine at the mo apart from the final bit, uploading to … |
| | i dont know how to read from database SQL. i try this : [CODE] string sql = "Select * from Table1 "; DataSet ds = new DataSet(); string connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataAdapter adapter = new …  |
The End.