[microsoft:sql-server] Forum Topics

ive made a program that links into an access 2000db. ive written the code for the find button as [CODE]Private Sub cmdFind_Click() Dim x As String x = InputBox("Input the first few characters of the Company Name ", "Find on Name") Data1.Recordset.FindFirst "Name like '%" & x & "%'" cmdFind_ok: …

Hi all, I need a fresh set of eyes :eek: . Can anyone see what is wrong w/the sql statement? Dim sql As String = "INSERT INTO order " & "VALUES ('" & itemId & "', '" & description & "', " & oNum & ")" Danka, Cindy

while iam running a jdbc connection program iam getting the following exception : Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at DBCreate.main(DBCreate.java:7) plz …

i have a sqldatabase in remote local system.from the web i have to connect to local remote system and copy the sqldatabase using dotnet.how to do.

I have a value E101 as my empId in my employees table and now i need to increment this value, i.e. E102, E103...etc. How can i get this to work? I've used the procedure but it's not working what am i doing wrong? ALTER PROCEDURE CalcPrimaryKey AS DECLARE @numValue int, …

[B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows …

Situation table1 has 2 columns: userid and requiredInfo It will have an entry for every user table2 has 2 columns: userid and optionalInfo It will have entries for some users but not others Problem: need a statement that returns either userid, table1.requiredInfo, table2.optionalInfo --if table2 has an entry OR userid, …

PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table …

Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I …

Hello Everybody. Can somebody help pls. I'm fresh from school and my first task is to develop an e-commerce website. I've been trying to do the login page. No matter what i do i get "Invalid Login". What am i doing wrong. :sad: Here's the code i use Function ValidateUser(ByVal …

hi all i wanna to use sql server 2005 but i never use it or any sql server before can any one help me what steps i should follow to learn it i will use jsp . as i used it before but with access thank u

Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I …

Hello I Was A Good Software Developer Just Migrated To Web Development I Want To Deploy A Site On Server2003 Standerd Edition This Site Is Sql Based When I Go To Aunhentication Pages It Gives Me This Error Http 500 -internal Server Error In Sql I Ahve Created Default User …

I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS …

Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o

Hi friends, i have 2 issues 1. how can we write code from text file to vb6.0 form/module/class code window programatically. 2. how can i replace Existing IIF in MS acces query with equalent SQLSERVER QUERY. First 1 : present senario: i am preparing with one TOOL so, that we …

I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] …

hello i m using MSDE version with the web site i have developed for ASP but i m unable to create guest user for internet access, which is defult builtin account by windows plz help me this is very urgent issue for me take care bye

I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks …

how can i access microsoft sql using php.

I am currently working on ASP and wants to establish a trusted connection with database (i.e. SQL Server 2000 in my case) Can any one help me out. Thanks Qasim

I have an sql table that consist of three key constraints Policy_Nbr, Trans_CodeOrig, Trans_Eff_Date. Now I need to create a stored procedure that will handle violations on the table. What I mean here is that the old values(three key constraints) when I do an update on the table should be …

I have the following procedure SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /* ------------------------------------------------------------ PROCEDURE: dbo.prc_TransOverride_upd Description: Updates a record In table 'dbo.prc_TransOverride_upd' ------------------------------------------------------------ */ CREATE PROCEDURE dbo.prc_TransOverride_upd ( @Policy_Nbr varchar(7), @Trans_CodeOrig varchar(6), @Trans_Eff_Date datetime, @Override_Code varchar(2), @NR_CodeOvr varchar(1), @Trans_CodeOvr varchar(6), @CreatedDate datetime, @CreatedUID nvarchar(48), @ModifiedDate datetime, @ModifiedUID nvarchar(48), …

hi there. have come across this site many times in google results over the years and decided to sign up - it seems a really friendly board. a bit about me.. i'm currently a developer in the clinical sector, although im moving jobs in 3 weeks to be a (mssql) …

Hi Paladine, Am new to ASP.NET. I followed all the steps which you had given for Login Page and Registration Page. Everything is working properly. Thank you so much. Paladin, I need one help from you, as per you steps I created one table called "tblUser". In this table U_id …

:cool: hi,iam working with sqlserver and i want to connect to jsp file i know the code but inorder to connect we also need some jar files how to set the path in tomcat? :?:

I am doing a website with asp.net. i have used session variable in my GLOBAL.ASAX file. the code is given below: Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs) Session.Timeout = 100 Session("Loggedin") = "No" End Sub Sub Session_End(Sender As Object, E As EventArgs) ' Code that runs when …

Hello, I've got the qoolaid trojan downloader and can't get rid of it. Norton and Ewido etc. find it and can't delete it. I go through safe mode and still can't delete them manually. Here is my hijackthis log. Any help would be great. My systems are the identification of …

Hi all, here's a bit of code for a registration page im working on. <%@ Language="VBScript" %> <%reg=Request("reg")%> <% if reg <> 0 then %> <SCRIPT LANGUAGE="JavaScript"> alert("Confirmed. The information has been entered.") </SCRIPT> <% End If Set Con = Server.CreateObject ("ADODB.Connection") Set rs = server.CreateObject ("ADODB.Recordset") Con.Provider="Microsoft.Jet.OLEDB.4.0" Con.Open(Server.MapPath("cesa.mdb")) sql …

what should i do..to design database for uploading files/documents from user..? what field i should create?please.. :?:

This is about a stored procedure I'm working on. I have a field which gives me a value of datetime type. I need to display the 6 months starting from the month in the field. E.g. field gives me Feb, I have to display Feb, Mar,April, May, June, July seperately. …

is it possible to have a validation password while open a MS Access password?? Where should i set it and how can i set it? the open connection or? pls advice.... thanks...

Hi, I really need some help I've been banging my head again wall with this one. I have created login page, username and password stored in sql database but now I need to add roles to webpage. Need them to be stored in database because the high amout of users …

I'm trying to populate a table from a sub-query. [CODE] CREATE TABLE test ( ID int ) INSERT INTO test VALUES (SELECT [Customer Id] FROM [Customers]) [/CODE] QUESTION: I know you can do this in ORACLE but Is something like this possible in T-SQL. I can also write something like …

CAN SOMEONE PLEASE HELP I HAVE BEEN INFECTED WITH THE TROJAN.CACHECACHE.KIT VIRUS AND CANT GET RID OF IT MY NORTON 05 KEEPS DETECTING IT IN WINDOWS\SYSTEM32\RDRIV.SYS HERE IS MY HIJACK LOG 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\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe …

how can i access Time from Server, i am using ADODB in VB6.0 and Sql Server 8.0.

Hi, Okay, here's the deal. I've created a project which requires user registration. Now, the registration part works like a dream. However, when I tried implementing an option where the user can update his details, the update isn't working. It says I have an error in my update statement. I'm …

Hello e/one, im getting error no. 9 "subscript out of range" in following situation. - i have a data grid on page on which i place a query to select data from SQL SERVER 2000 database just like that "select size_number, product_size, type_number from product_size" -Below this grid i have …

I built a function as following [code] def IsExists(fxfcustid): #global noduplicates db = db_connect("triumph","freight","vcpdb") cursor = db2.cursor() #************************************************************************* #*** Query to get entries made by the person acessing the system *** #************************************************************************* sql = '''select count(*) from triumph.fxf_salescontest_entry where fxf_acct_nbr = %(fxfcustid)s) and (delete_flag is null or delete_flag not in …

I want to insert datetime into the database.I want to insert date as a dd/MMMM/yyyy format SqlDateTime x; if((TextBox1.Text).Length==0) { x=SqlDateTime.Null; } else { x=DateTime.Parse(TextBox1.Text); } command=sqlConnection.CreateCommand(); command.CommandText="insert into Table2 values('"+x+"')"; sqlConnection.Open(); command.ExecuteNonQuery(); Response.Write("Save"); when I add this type of dates ex.25/02/2005 it occur error, how can I solve this.

Im quite new with programming in vb.net! I have to hand in a project before monday where I have to create a treeview linked to a database tables! Eg. all the rooms and the bookings linked to them. Can someone please help! Code please!! I'm using access-dont ask why-but its …

Hi I m a final yr comp Engg student. I m working on .NET,i m usin mssql with ASP.NET,VB.NET for creatin online banking site.I hv a problem: Hw i can [B]record the transaction made [/B]by client for report generation. shal i use database for [B]report generation[/B]?if yes then hw? otherwise …

[First I have to apologize because I am posting this in two different forums on this site -- in hopes of finding someone who might be able to help.] I am building a system to mimic the NT user and group system. It works fine, but because of the way …

[First I have to apologize because I am posting this in two different forums on this site.] I am building a system to mimic the NT user and group system. It works fine, but because of the way I am storing and querying the data (from MSSQL), it takes forever! …

click on modify button? Public Sub DoModify() Dim bm As BindingManagerBase = Me.DataGrid1.BindingContext(Me.DataGrid1.DataSource, Me.DataGrid1.DataMember) ===>>> Dim dr As DataRow = CType(bm.Current, DataRowView).Row <<<=== Dim editform As New EditTransOverride(dr) Dim retval As DialogResult = editform.ShowDialog() If retval = DialogResult.OK Then bm.EndCurrentEdit() Try Dim substr As String = dr.Item(4) substr = substr.Substring(0, …

I have developed some webpages using asp and they work fine on my computer with Access 2003 (using iis as a local server). However, I am aware that SQL 2000 is a better db to use, but I am not sure in which ways. Since I intend to put my …

Hi guys this is my first post and its a troublesome one. Ihave been at this for 3 days please can someone help. OK here is what I want to accomplish: I have 6 Servers all running Win '03 server standard Server 1 : Configured as a Domain Controller w/ …

i decided to switch over to ms access (thinking it would be easier) from mssql but i am having the same problem that i had with ms sql: "SQL Server does not exist or access denied" i have put the ms access db into the web server from the web …

im fairly new to the .Net world and i'm tryin to make a simple page that dynamicly fills a table/form from a database based on user log info. i've been doin some reading and the datalist/repeater seem like more than i need...or maybe they are exactly what i need but …

Hi I have a problem with making a setup file for my application If a setup file is not possible please tell me how would I be able To move the application around…. I have made an application with front end in C# and dbms SQL Server (ie. ADO.net)… As …