6,934 Topics
 | |
| | The program I use is housed in a SQL Database. What I am trying to do is term Members based on meeting 2 guidelines (PCP and Insurance). WHat I want to do is term a group of members that have the same PCP and Insurance plan. This data is broken …  |
| | Hullo daniwebbers!! I have created a little cd database at home on my home network. And I want my machine to act as the server. I want the other pcs, i.e my sister's and mom's which are connected to my network to access it, and be able to change and …  |
| | hi can we deploy setup of [B][COLOR="Red"]sql server express edition[/COLOR][/B] along with our own apllication? does any licensing issues come into picture? because express edition is freeware, but when i install it on my client machine then it is asking to accept License agreement. if it is free then why … |
| | can any one explain me about connecting data reports,ms sql and vb6.0  |
| | hi, Is MS SQL server 2005 Express Edition is freeware??? anything(webpage/link/material) that gives support to above statement will be most welcome..... thanx and regards. chaitanya. |
| | hi all, iam using asp.net with c#, i want to insert data from excel sheet to sql server. while inserting the column does not starts from firstrow itself ex: fristname,lastname-------> these are the columns these columns does not start from 1st row ,these starts from 5th row so how can … |
| | hi everyone. I have a web application on ServerN that needs to access data from SQL Server 2000 db on ServerD over the Internet. However, for security purposes, ServerD is not allowed Internet access. Therefore, there is a ServerM on same LAN as ServerD. ServerM has Internet access; and can … |
| | Im getting invalid coulmn index...any suggestions?...thanx in advance [code=java] public static int[] getListSummary(UserDataVO userData) throws Exception { Connection connection = null; PreparedStatement pstmt = null; ResultSet resultSet = null; int[] listSummary = {0,0}; int leadCount = 0; try { connection = DataBaseConnectionManager.getConnection(); if (connection != null) { if (userData.isAgentType()) { … |
| | Dear friends, Fine and hope the same with you all. I am here with one more new problem which I might be able to solve with your suggestions as we have did earlier. Problem: I have a requirement from my client where I need to give update or edit privileges … |
| | I want to create new table in Access database during the runtime of my VB code. I am developing a "Library Management System" using VB6. At first i have used SQL statement to do the job. But it worked for once & then it stopped working. No error message was … |
| | I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell … |
| | My search page has form as below to pass data to tsearchresults.asp so that my database can be filter to display correct data. [CODE]<form action="tsearchresults.asp" method="get" name="townSearchForm" id="townSearchForm"> <select name="varBeds" id="varBeds"> <option value="%" >All</option> <option value="1 Bedroom" >1 Bedroom</option> <option value="2 Bedrooms" >2 Bedrooms</option> <option value="3 Bedrooms" >3 Bedrooms</option> <option … |
| | I am about to pull what little hair I have let trying to figure if this is possible. On my website I have a drop down menu with different tables in the drop down part. What I am trying to do is have a user choose the table to get … |
| | I couldn't find anywhere to ask this question and i'm working with PHP so i thought i would ask it here. What would be the SQL statement to modify a database field from 'YYYY-MM-MM' to 'DD-MM-YYYY'. Thanks, |
 | I am calling this constructor but it is not getting complied public conn() { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql:///dbetech", "root" , ""); } throwing error message: D:\etech\WEB-INF\src>javac *.java conn.java:16: incompatible types found : java.sql.Connection required: com.mysql.jdbc.Connection con=DriverManager.getConnection("jdbc:mysql:///dbetech", "root" , ""); ^ 1 error |
| | Hi I have the following code which generates an error 'Data Type mismatch in criteria expression' The purpose of the code is to write a value to a database at a specific row. [CODE] Dim IntSid As String Dim Sid As String Dim I As Integer IntSid = Me.TTIn.Text Sid … |
| | When i try to install MS SQL 2000 on Windows XP machine it says that server component is not supported by this OS.What should i do get it run on this machine? |
 | Hi folks. I Have a question : I'm interested how you generate query string to search DB with more than 1 form with LIKE. For example : We have $_POST['name'], $_POST['title'], $_POST['phone'], $_POST['email']. How do you generate sql query to search with two criteria ( name and phone ) ? … |
| | Hi :) How can i start a conection between c# and Pervasive.SQL database ? Can you show me how its done, or point me to tutrials ? Thanks |
| | hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i … |
| | Hey everyone I want a where clause based off a variable input and I'm having some trouble with the syntax. My current code(incorrect) is below but it shows what I am aiming for. Does anyone have any suggestions? [CODE](CASE WHEN @inIndustry = 'ALL' THEN WHERE EXISTS (SELECT 1 FROM sysdba.C_PROJECTREVENUE … |
| | |
| | Hi Everyone:* I am working on Database project using DAO. Now I got a problem in counting all the data from one Field:-/ . Please help Me in this problem. :confused: And Tell Me how can I get the total of any field by using SQL STATEMENT? Thanks In Advance |
| | Hi All, I'm unable to install MS SQL Server 2000 Developer on Windows XP. Windows XP service pack 2 is installed. When I start setup, it does something for 2-3 seconds and nothing happens. When start setup again it shows that setup already running. But it does nothing. Please help …  |
 | I would like to move my forum database to a new server. However, the MySQL database is approximately 700 megs, and takes a great deal of time to import. Doing a [inlinecode]mysql> source backup.sql[/inlinecode] took well over 12 hours the last time I did it, and that was months ago. …  |
| | I need to return some HTML code stored as a text data type in my database. Is there a way to return this HTML effiencly through PHP that will execute this code when HTML parses the page? Currently I have this: [CODE]$result = @mysql_query("SELECT * FROM sponsors"); $num_rows = mysql_num_rows($result); …  |
| | Hi all i new to MySQL and currenlty now is trying to do a database and upload it up to PHPMyadmin so that the page im am creating can use it but im facing a big problem here Error SQL query: # # Database structure for database 'database name' # … |
| | I am working in ms access database2000 and my frontend is vb 6.0. I have three tables namely:- AREA:- areaid,areaname ROUTE:-routeid,routeno,routename,areaids PARTY:-partyid,lastname,firstname,address,areaid The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,' The problem is that i want to derive …  |
| | [B][COLOR=red]Hello everyone, [/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]someone help me ? i have a problem with vb script i paste the coding here just chek it out where i am wrong [COLOR=green]raj.ActiveConnection = MM_ravi_STRING[/COLOR] i got error here:( Thanks email me on [email]ravindrakale007@gmail.com[/email][/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]<[/COLOR][/B][EMAIL="%@LANGUAGE="][B][COLOR=red]%@LANGUAGE="VBSCRIPT"%[/COLOR][/B][/EMAIL][B][COLOR=red]> <!--#include file="Connections/ravi.asp" --> <% Dim raj Dim raj_numRows[/COLOR][/B] …  |
| | i want to delete a selected row from the database.the entries of database is shown by a gridview and i do <OnRowDeleting="GridView1_RowDeleting"> in source code. i select and bind as follows. [mycode] string str = "select PNR,CreditCardNumber as 'Credit Card Number',EmalAddress as 'Email Address',PassengerName as 'Passenger Name',PassportNumber as 'Passport Number',IPNumber …  |
| | Hi, I have few reports which have been created using the Microsoft Sql Server Reporting Services.Now i want to create similar reports using Oracle Reports 10g. Will i need to start from scratch the creation or is there migration tool that would reduce the efforts for the same. Thanks in … |
| | I have a simple login screen where I want the user upon entering the correct userid/password , for his userid to be inserted into a table in a database so to keep track who visited his web page. My ISP is supposedly has created a DS named "win5_zjconstructioninc_com" but the … |
| | LibraryDB is a database system that keeps track of information concerning the books and their circulation in an imaginary library. [B]Disclaimer[/B]: The data that populates the database are artificially constructed and by no means correspond to actual real-world data. The schema for the LibraryDB database is given below. [INDENT]borrow([U]transactionID[/U], personID*, …  |
| | I want to store the results generated out of SQL query into excel file ... how do I go about doing it? help  |
| | [B]Description:[/B] The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's … |
| | can any body helpme on this point! i have the merge module MSDE n i have to deploy website to another PC i dont want that i install mysql there i want to attach just a fileor dll of database to the project set up . so i will not …  |
| | Hi, I am currently trying to write some sql that includes a where clause to limit responses but will leave blanks where there is no match. I will include the code so its easier to understand: SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher INNER JOIN student ON teacher.teachername = student.teachername … |
| | Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I … |
| | Hi, I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel. Could any one tell me how this can be made possible.Also could any one …  |
| | hai all i am undertaking a project of sending sms to mobile phone using sql server 2005,pls guide me how to do that,[COLOR=red]this is urgent please:'( [/COLOR] |
| | I am writing a front-end application using visual basic in Visual Studio 2005 Express. I already have a connection to my database (Access 2003), but I need to retrieve and manipulate that information. I found the syntax in c, but I can't seem to find it for visual basic. Does …  |
| | i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login. ALSO i can login well using the sql server … |
| | i want to connect to a sql server running on another xp computer. i have made the sql connection, sql data adapter (using Data controls, not connecting manually from code). i can fill the data adapter from the design view by right clicking on the adapter, Fill dataset and i … |
| | I am using visual devloper express, and i have been following allow in the "starter videos". for lesson 8 (editing and insterting into a sql express db file on the local host), the example worked fine, but when i try to replicate the example with a SQL database (external one) … |
| | Visual Basic 2005 How do I go about adding a column to an SQL database. Everytime I did it in the past it was a disaster and I literally had to start all over again from square one. I would go into Dataset Designer to add the column then I …  |
| | Hi guys, I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and … |
| | Hi, I am getting error when i am installing Sql Express 2005 on Vista Machine. I am getting error message like this "Microsoft Express service Can not be started.Installation Aborted." Even i have checked the Log file on "d:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\summery.txt" in that also it has given the … |
| | Hi, I am writing a query that requires as input the difference in days from two dates (Project_End - Project_Start, both of data type DATETIME), how can I find it? Can I subtract the two dates? Thanks, Robert |
| | Hi! I want to share news... Found an interesting SQL editor supporting intellesense. Site vendor [URL="http://www.yukondev.com"]www.yukondev.com[/URL] there is no editing tables, but otherwise that is what I was lacking. [COLOR=black]Regards, Mike [/COLOR] |
| | Hi, I have created a stored procedure that would insert new records in one of my database tables. I have tested the procedure in SQL Server 2005 and it works all right. What I want to do next is to connect the stored procedure to my form in VB.Net so … |
The End.