9,022 Topics
Hello everyone, I used to have my MS Access 2002 DataBase placed in my application folder and connect to it through an OLEDB connection. Everything worked fine. Now I decided to create an ODBC DataSource and suddenly I'm not able to pass parameters to the SQL Query the way I …
I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is …
I have a database with two tables customers & sales what i would like to do is in the sales datagrid is to have a total column that calculates the quantity*price columns and shows the result in the total column i don't know if i need to do this with …
Hello friends, I started a new podcast over a week agao. I hope some of you can check it out... yesterday I posted show #3. I'd appreciate constructive crtitsism. Please, check it out. In Tuesday’s show, we talk about Visual Studio 2005, SQL Server 2005 and a little about [url]www.myspace.com[/url]. …
Dear Colleague: How can I use "begin transaction", "commit transaction", "rollback transaction" and the like in the visual basic 6. Is it possible to populate a combobox in VB form with the data that is retrieved from SQL server database table? How the code looks like? regards, benyam
Regarding my subject line: Here's my HJT log. Can anyone help? Logfile of HijackThis v1.99.1 Scan saved at 4:21:38 PM, on 3/3/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\Explorer.EXE C:\WINDOWS\system32\LEXBCES.EXE C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\LEXPPS.EXE C:\WINDOWS\System32\hkcmd.exe …
SQL is very simple language, even though not everyone is able to use it. In many cases good WYSIWYG SQL editor (or composer by better words) could help. But is it possible to graphically represent all SQL commands? Simple queries - why not? But what about those, not very simple, …
Dear colleague: with out placing an ADODC object on the Vb form, I want to create a connection with a SQL server database. And add record in the table, retrieve a data from a table and amend some data as well, through textfields in VB. Please forward me the code, …
im working on a asp.net project, sorta like a web portal, which will need a user database. i have a very good understanding of sql. i just want some examples or tips on writing a good user database. ive create a few which i think are good, but could be …
This is not working for some reason it is telling me that ds_products does not exist. here is the code... <CFQUERY NAME="products" DATASOURCE="ds_products"> SELECT ProductName FROM tblProducts </CFQUERY> <html> <head> <title></title> </head> <body> <h1>Product Listing</h1> <ul><li><CFOUTPUT QUERY="products"> #ProductName# </CFOUTPUT></li></ul> </body> </html>
i am working in a big site , and i need data base,i will use SQL SERVER and ASP to build this data base . so i am asking if i can connect SQL and ASP with flash 8 or shall i use DreamWeaver....and if i can connect them i …
Hello over there.... I really need your help. i want to do an appication which require to retrieve data from database and use it to create bar chart. but what matter i tried i can make it ........ Anyone if you know the way.please tell me....thank you
this is my code for login but it has an error.it stuck when comes to Myconn.open(). the error is : The ConnectionString property has not been initialized. this is the code : Function DBAuthenticate(ByVal strUsername As String, ByVal strPassword As String) As Integer Dim conMyData As SqlConnection Dim cmdSelect As …
I'm not sure if I am posting this to the correct location or not. I just purchased Microsoft Visual Studio 2005 Professional with SQL Server 2005 Developer Edition. My question is, does anyone have any specific instructions or suggestions on how to best install and configure these two products to …
Hello everyone. I have a pretty straight foreward problem. Here is an overview of what i am trying to accomplish 1. I am trying to allow "teachers" of my quiz site to create a class list and in that class list, they can have a list of students. I created …
Hi all, I'm a 3rd year Computing Science Student, who will be starting my fourth year soon. I am primarily interested in databases, particularly sql server. I am also interested in .Net Programming, particularly asp.net. I have been trying to come up with ideas for a Final Year Project, and …
I've been having trouble with a strange popup box showing up when I try to access my IIS server through it's IP address (even on the host computer itself). If I enter the host computer's user/pass it will work fine, but unfortunately the other users on my intranet have to …
I am working on this screen, where top part of the screen is a browse/edit/add panel for table called "Package" And depending on the Package_ID (@@Identity) I am filling a datagrid in the bottom part of the same screen which has data from various other tables , like "Components" , …
Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance …
trying to get a count of transfers from one account to another account within the same bank relevant columns: table transfers transferid, toaccount, fromaccount table accounts accountid, bank what i have now is select count(*) from transfers where toaccount in (select accountid from accounts where bank = @bank)and fromaccount in(select …
Hi everyone. I am trying to show data from a sql data source. My Columns are as follows: QuizID (Which record the quiz # that the person took), DateTimeComplete (Which shows when the quiz was completed), Score (which is a numeric value that shows the person's score), and UserName(Which is …
Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye
I know this is probably a basic question, but I'm stuck and can't seem to figure it out :-/ This is in VB.NET 2005 and I'm making a windows forms app. I'm filling a DataTable from a SQL command, and then binding a dropdownlist to that DataTable. I'm assigning the …
Hi, in the .NET 1.1 and VB application, I am calling a store procedure [SQL-SERVER 2000] in a subroutine. the store procedure simply SELECTs rows from tables and returns data, when I try to use the data to fill the web form, it works fine until it hits any column …
I'm working on a side project/consulting job for my former employer...basically I want to recreate an app I did in VB6 using VB2005. It's a simple app, but it was built when I was less experienced, and while I've got the business logic, I'm having troubles getting to a point …
I got some experience working and managing ms sql databases, but now I am in a need to replicate 2 databases and I can't make it work. Please advise. If it's possible step by step. Thanx
Hello there, is been a while since I last posted here, mostly because I didn't have the time I needed to program. But now, I reentered the exciting world in Visual Basic, 'cause I have a lot of time now and my mom wants me to make her a database …
Hi to all, I need help regarding my project in asp.net Firstly, in my project there are two faces one is administrator and another is user. Secondly, an administrator has following roles 1. He must be able to add, edit/update, or delete a category( e.g. book, phone cards, cds, dvds, …
I am having problem in connecting to database. The problem is with the following code. [CODE]dim objCmd as new OleDbDataAdapter() objCmd.SelectCommand.Connection = dbconn objCmd.SelectCommand.CommandText= sql [/CODE] I am having error on line2 the error is [COLOR=Red]System.NullReferenceException: Object variable or With block variable not set.[/COLOR] I think there is problem in …
Alright guys, I'm having quite a time with this one. I'm getting an VB script error : Microsoft VBScript compilation error '800a0408' Invalid character /addcust2database.asp, line 25 MM_conn1_STRING="Provider=Microsoft.Generic.OLEDB.3.51;" & _ "dsn=www.motorlists.com;" &_ "uid=mechanic; pwd=k1n3t1c;" &_ "Server.MapPath("motorlists.mdb");" I'll print the code, but it's pretty long. The purpose is to send a …
I am doing a movie booking system, my booking page consists of buttons, representing as seats. Each time this seat is clicked, the button number is listed into a listbox. For example, buttonA1, buttonA2 are clicked. The listbox display this two as A1 and A2. How can i save A1 …
I am using an SQLDataAdapter to bind information from a database table to a listbox. However, the user have to select an item from a dropdown list box, DropdownMovie before the information for that particular movie is bind to the listbox. No errors in the codings. But when i run …
Is it possible to save everything in a listbox into the SQL database table? I was given a suggestion: Allow MULTIPLE in select tag to make the user select all/any of them or write Java Script code to loop thru the length of select and append them to a hidden …
i have written a jdbc program and compiled it successfully on running it i got a error: Exception in thread "main" java.lang.NoClassDefFoundError: com/microsoft/util/Ut ilDummyPrintWriter at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:120) at DBCreate.main(DBCreate.java:7) the program code is as follows: import java.sql.*; import java.util.Properties; public class Rows { public static void main(String args[]) …
Hi I recently installed SQL SERVER 2000 Personal edition on my Windows XP Prof PC. I installed using the windows authentication mode. But when i try to connect the database from .NET in my ASP.NET application. I get an error saying "Server does not exist or not access denied" pLEASE …
hi all I get this error no matter what i try, i know this is caused when no data is matched on my query, what i need to know is how to make it so i can give the user an option to register of not. this is the error: …
I am working on a seat selection page for an ASP.NET school project on movie booking system. I have created the seats using buttons (A1, A2, A3) etc. When the user click on the button, the button colour changes and the user finalized the payment. I have an issue here. …
Hi, I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted. The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd. Is there a …
Hi, I have made the necessary changes in the web.config so that I can get to the security Tab for the ASP.NET configuration. The new error when trying to go to the security Tab is: The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. …
[b]JodoHost celebrates its 3rd anniversary [/b] and enters into its 4th year of business. We are providing Shared and Reseller Hosting on Windows, Linux and VPS (Linux) Servers. It has been a long journey for us since December 30th, 2002, when we started off as a tiny webhosting company offering …
I worked on this site over the summer at an office, I'm now back on christmas break, and will work again this summer. With the help of many people online I got the following code to work. But now, it doesn't work. As far as I know, the code SHOULD …
I've been enlisted by a friend to remove Hacktool.Rootkit, but I can't seem to get rid of it. It seems to be acting differently than the other reports I've read. The computer was infected in a similar way (IM about pictures) but Norton isn't constantly popping up errors, it only …
Good Day, Can anyone on this forum elaborate on comparisons of performance and functionality between SQL Anywhere and Access? Regards, Keith :?:
Hello every body, Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating. Table 1 Sno SID Name 1 212 Klen …
Does anyone know how to connect to an MSSQL View in syntax. If you know please right back asap. I need this project done quick. Thanks.
Gallery database -------------------------------------------------------------------------------- Hello averybody I would like to know your opinion how do you design a database that will works as photo gallery, let's count there will be a lot of pictures. Do you save the pictures on the disk or directly on the database? Write please your ideas …
For some reason i cant get the mssql function to be inabled. When i go to view the phpinfo.php that i made to view the extension that are enabled it gives me an error saying that it cant load the extension. So i try to enable the pdf.dll in php.in …
Hello, I would appreciate it very much if someone can give me an idea of a dissertation using visual basic.net with any other application...maybe sql etc. If there is a company requiring a project to be done i would be very thankful if you could let me know. Iv only …
I have a project in Borland C in which i need to Connect with SQL server 2000 plz give me the code for that.
hi, i want to give facility to search in my website both search through a keyword and advance search. if any body can send me some code of search option. i m using VB.NET as tiel language and sql server 2000 as database. thanx in advance Prakash Roshan
The End.