9,022 Topics
Hi All, I am currently trying to create a perl script that takes sql statement that is stored within text files and add up the frequency for that sql statement in that text file and store the sql statement and the no of frequency in another file. Below is a …
i am trying to figure out how to flag a value in my asp, sql 2000 db web project. i have one accepted time, "6A-2A", and i need to allow my salesstaff to enter in any time slot(s). i have to flag a time slot which lay outside of the …
Hello all, I have a MS SQL database which is meant to be quite small. For some reason it appears to have grown to 1GB in size. There are quite a few tables in the database. Is there any way to get a report (using enterprise manager) of the table …
going crazy over here!!! If you will notice in the bottom left hand corner the ProductCategoryName Column is producing two and three results on the same product and these products are not in the categories table, this categories table is where the ProductCategoryName is at so i am not sure …
Non of the java programs which used to run fine in my computer has stopped running. There are no errors in da programs as they still run fine in other computers. All programs gives the folllowing error "Exception in thread "main" java.lang.NoClassDefFoundError" I set my classpath and the path fine …
so i guess i need some help with this thing i dl HJT and i did that scan thing...here is what is says... Logfile of HijackThis v1.99.1 Scan saved at 7:39:08 PM, on 6/26/2005 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 …
I have just spent considerable time getting rid or a range inbedded programs eg. yazifind.com. I thought that was the end of it now I have - AmberCasino.com. It just appears on my desk top. How do i get rid of it. This may help with the solution - Logfile …
I am trying to databind one entry retrieved from a SQL statement. All I want to do is databind in the code behind page. For some reason I have lost my brain and cannot figure out how to do it....
Okay this is a good one I believe. In a dataset, you can create single relations (ParentTable.PrimaryKey to ChildTable.ForignKey) using the dataset.relations.add method. You can use a string variable something like this: Dataset.Relations.Add("relationName",Dataset.ParentTable.columns(strParentKey),dataset.ChildTable.columns(strchildForeignKey) This method works fine for single to single keys generated dynamically using schema info. Now if there …
Hi guys Lemme explain the situation in 2 lines: DB Structure: [url]http://img133.echo.cx/img133/6610/dbstructure6hs.jpg[/url] Client goes to computer shop. Shop has 1 or more NORMAL promotions (of the kind: for each u$sXX ammount you buy, you get X qtty of points to exchange them later by gifts). EACH NORMAL PROMOTION can have …
:cry: I'm new to this MS SQL and I've been trying to understand this Primary key and Foreign key. I know that I use the foreign key to reference a table but for some reason I'm not getting this down right can someone point me to the right direction. Also …
I created a database in Sql Server 2000, unless I made atleast one field in the table as "Unique", I could not insert data into table. But no-where in the documentation , books or Sql server online I could get a text saying we need atleast one Unique Key per …
Hi! i have a table with 3 fields: ParentFolder,DocumentNo and VersionNo the DocumentNo give each document a unique number. ParentFolder is a number specifying which folder a document is in. and each document(with same name) can have many VersionNo(1,2,3 etc). i am creating a house keeping function for user. this …
i have two tables table1 has the folowing fields lastprice symbol time table2 has the same fields now table1 stores only the last data of the corrosponding symbol but table2 goeson adding the data as it comes in now i want to write a query get the difference of the …
Hi all I have created an Access database and I can retrive info from it, but when I try to upload new info using a form I created it gives me an error which says "Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot …
I have two dropdownlists. I can choose say USA and then it goes into the DATA base but does not save it in the dropdownlist itself. I can not figure out why this is happening. > <code> > Edit mode the index of a dropdownlist does not start at the …
I'm having a wee bit of trouble. The code is as below: <%@ Language="VBScript" %> <% AlbumArt=/music/Request.Form("artist")/Request.Form("album")/Folder.jpg %> The values of artist and album are obtained through a form. What I want is that whenever a user submits the form with, say artist as "Dream Theater" and the album as …
Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each row), then I could do something like this: SELECT * FROM table WHERE type …
I have programmed a web application using classic ASP and MSSQL, but our company is upgrading to ASP.NET and for my next project I thought I would the application in pure VB.NET. However, I am struggling to get my application to talk correctly to the MSSQL tables. I know my …
hi every one i have a problem with my program the problem is cant make a chek if the account is exist or not in the data base (for login the web site) the error message is: [SIZE=3][COLOR=Red]The ConnectionString property has not been initialized[/COLOR].[/SIZE] here is my code Imports System.Data.SqlClient …
Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30506: Handles clause requires a WithEvents variable. Source Error: Line 70: Line 71: Private Sub cmdLogin_ServerClick(ByVal sender …
thank you for entering this page i would like to explain what i should do in my project and my problem: 1- the project for student in the school . 2- every one has an private account and can use it for many things 3- every account has a table …
When attempting to connect to my sql server through Vale Software's MSDE Manager, I get the error [SQL-DMO]Service Control Error: The RPC server is not available. I made sure all processes involving RPC were turned on, and I also turned on the DCom service process launcher as I read to …
In developing customized software for different development sites, I copied the mySQL database from original server to my development server using mysqldump to creat a copy, then mysqladmin to creat it to the development server. The web page I am testing is the same for both development sites, but an …
Hello, How can a timestamp field (int, 4) witch displays as hhmmss be converted that it looks like hh:mm:ss? Can anyone help?
hi every one .. thank you for entering this message i have a problem with connection to sql server 2000 from vb.net the message is : The ConnectionString property has not been initialized. and this is my code Line 41: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …
Is there a way to download an image (binary) from a database in sql server and insert it on a page as an image control? I want to add the image to a page when it loads. I can't figure how to do it and I am not sure if …
Hi I am getting the following error if I leave my comp(WIndows XP Client)idle for approx 20 mins.Infact I am authenticated to SQL Server thro a 2003 server.PLease suggest what can be done. Error message in the event log : Event Type: Warning Event Source: LSASRV Event Category: SPNEGO (Negotiator) …
Hi, I am designing a scan folders software, I need to save all information about files (name, extension, size, attributes,...) in ms access Database (It's a requirement). My database contains about 85000 records to be diplayed. I tried to use ADO to paginate, but I need to retrieve from the …
Hey everyone, I've got a recordset of terms in my page. I know the recordset has all the terms from the sql table within it because i can get it to print just fine to screen. I need to put the recordset into an array. That way, a script that …
Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios. TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, …
Hi, I need to make a menu that can read from an SQL database and build its needed dropdown menu arrangement accordingly. I'm having real troubles finding any sort of tutorial for this and was hoping someone could point me in the right direction ... (Or if someone knows of …
I have a news article site which loads its information from an sql database. I need the page to have a dl button so that the article with proper formatting and images can be saved as a document on the users computer. Has anyone ever done smth like this? I'd …
I am a .NET Developer with 2.9 yrs of Exp, I am ready to take new projects ,Projects to be completed,etc in ASP.NET,C#,Sql Server2000 mail me at :manjudna@yahoo.com
I'm having this problem with Aurora, like lots of others. Here's my log: Logfile of HijackThis v1.99.1 Scan saved at 10:55:10 AM, on 6/4/2005 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:\WINDOWS\System32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Common …
Hello I have ASP files in one web server and dll's in vb6 that connects to sql in another server. I would like to know if there are needed any specified component in order the application, asp pages that call a main dll that references another dll's and that connect …
Ok, I am trying to read data back from a database, when I build my program it throws an error saying: "No overload for method 'SqlDataReader' takes '0' arguments." Here is the code from the program: [CODE] [size=2]SqlDataReader existsRdr [/size][size=2][color=#006400]= [/color][/size][b][size=2][color=#008b8b]new [/color][/size][size=2][color=#191970]SqlDataReader[/b][/color][/size][size=2][color=#006400]();[/color][/size] [size=2]existsRdr[/size][size=2][color=#006400].[/color][/size][b][size=2][color=#191970]Read[/b][/color][/size][size=2][color=#006400](); [/color][/size][/CODE] Anyhelp would be great. Thanks in …
The MCSD .NET certification tests users on building Web-based, distributed, and commerce applications by using Microsoft products, such as Microsoft SQL Server, Microsoft Visual Studio .NET, and Microsoft Component Services. MCSD .NET builds on the more entry-level MCAD certification by encompassing not only development, testing, deployment and maintenance, but also …
hai! i"m doing my final project same like Tina. I"m facing al ot of prob in doing my project.Let me describe my project first, i"m developing Online Course Registration System for my U. for the ADMIN interface i'm using VB (off-line)and for the user interface i'm using Dreamweaver Mx (on-line).Here …
Hey there people basically i am currently doing my final year project,about decreasing the time taken to locate functions within mobile phones. therefore i am required to create a menu for a mobile phone which will solve the issue. I am looking to create a search faciltated menu which is …
Hi, I'm attempting to set up dotnetnuke with Microsoft's SQL MSDE as my database. After getting SQL up and running, I created a database aptly named dotnetnuke, and a login called dnnuser. I set dnnuser's role on dotnetnuke to system administrator and it's role membership to db_owner. After altering the …
Hi, I am wodering how to store and retrieve czech, or other utf-8 related language, characters using IIS 5.0 and SQL server 2000; I try to explain: at the beginning I was using the 1252 default codepage (with no charset specified) and some character was immediately changed when posting toward …
[B]How to search a database[/B] [B]Intro[/B] Searching a database is actually a easy thing. It just involves a form, and a page that displays the results. Im going to show you how to make a simple form, and a page that displays the results. [B]First steps[/B] So the first step …
[CODE]Dim myReader2 As SqlDataReader[/CODE] can any one tellme why i get this error: type 'SqlDataReader'is not defined thanks. :D
I have a windows nt server with sql 7 installed and am getting the following in event viewer. The product Microsoft SQL Server 7.0 is out of licenses. Use License Manager from the Administrative Tools folder for more information on which users are out of compliance and how many licenses …
Hi everyone! I am trying to develop an application to communicate with a Microsoft Acces database. For doing that I import the java.sql package to use the DrvierManager class to get a connection. The problem seems to be the application doesnot find the java.sql package. I have the 1.4.2_08 version.. …
I have a SQL query: SELECT * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID=Requester_Reco rd.Requester_ID; if i want to call an attribute from Job_Request_Record table e.g. rs.getString("ID")is it valid? or anything else. please help. Also, is it possible to have a create view table in ms access 2003?
[COLOR=DarkRed]Hello, I am Software Engineer and Working in Visual Basic 6.0, SQL Server 2000, Crystal Reports, Visual Foxpro 6.0 etc... Please consider me when u have some information or I need information about theses tools also from You...[/COLOR]
I'm in the beginning stages of designing a mechanism to share and integrate data between 2 software systems. Each software system uses a large scale relational database. One is written in asp/vb and uses sql server 2000. The other, i'm not familiar with the specifics, but I want a solution …
Hi, Accidentally one the member has compressed the disk drives in the SQL Server. Before we go ahead an uncompress the disk drives, we need to make sure that the database is unaffected. 1. What is the normal database compression ratio when Hard Disk is compressed? 2. Do uncompression of …
The End.