Hi all, I am new to java; earlier i was working in .net (c#). My company assigned me an existing web project which is developed in java (jsp). i have installed jdj7 and Apache Tomcat 7 as service on my machine. Whenever i placed my project in webapps folder it generate an error in logs (Catalina)

Sep 12, 2013 3:11:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Tomcat 7\webapps\myproject
Sep 12, 2013 3:11:57 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Sep 12, 2013 3:11:57 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/myproject] startup failed due to previous errors

Thanks

rmshah Developer

Thanks jschell, MS SQL Server is installed on client's machine. The location of the MS SQL Server files. it on client's machine(C drive) and data file and log file lying on pen drive. The Visual Studio application is lying on client's machine(c drive). The connection string is fine as it works on my machine. i am using a pen drive for data file and log file. Thanks again.

rmshah Developer

Hi all, I am trying to connect db file from a pen drive. it is fine when using on my local machine. But giving following error when trying it on my client machine. i am using vs2008 and mssql express 2008. Mssql express 2008 also installed on my client's machine. Type of application: Window application. Error:Failed to generate a user instance of sql server due to a failure in startng the process for the user instance. the connection will be closed. i have deleted mssqlexpress folder form the location: C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\ and restarted machine, but still getting the same error. Connection string: " Data Source='" & (SqlServerName) & "';AttachDbFilename=" & driveName & "dbfolder\dbname2.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" if i remove the "User Instance=True" from the above connection string it gives me following error: "Create database permission denied in dataase 'master' an attempt to attach an auto named database for file failed. A database with the same name exists, or specified file cannot be opened, or it is located on usc share." Kindly help me. Thanks

rmshah Developer

Hi All, I have developed an accounting application in vb6 with mssql 7 as backend. with the passage of time microsoft developed a lot and recently launched VS2010 and MSsql 2010. Being a developer i updated myself up to VS2008 and Mssql 2008. Currently i am working in Vs2008 and Mssql 2008 express. Upto Mssql 2005 there was no problem between me and my clients. but now as i have upgraded my all systems to mssql express 2008 i am facing problems as some of my client have xp sp2 and mssql 2008 studio does not work with xp sp2. whenever i tried to install to mssql 2008 studio on xp sp2 it required win powershell which only support on xp sp3. as result i am unable to resotre database to mssql 2005 developed in mssql 2008 express. kindly suggest me the solution. Thanks

rmshah Developer

Thanks for reply, Kindly suggestexample codes. Thanks

rmshah Developer

hi all, i am using an excel file in vb.net as following Dim AppExcl As Excel.Application AppExcl = New Excel.Application If AppExcl Is Nothing Then MsgBox("Invalid Action: Excel Could not be Started!", MsgBoxStyle.Critical, "Sys Error") Environment.ExitCode = 0 Exit Sub End If AppExcl.Workbooks.Open("path\filename.xls) With AppExcl '.Visible = False .Range("N7").Value = VATNO.Trim .Range("E7").Value = Format(xVAT_DtF.Date, "dd/MM/yyyy") .Range("H7").Value = Format(xVAT_DtT.Date, "dd/MM/yyyy") .Range("D9").Value = CoName.Trim .Range("H9").Value = CoStatus.Trim .Range("M9").Value = xCoType.Trim End With With AppExcl Dim xPth As String = xChkxOrxCreateDir() If Len(xPth.Trim) = 0 Then Exit Sub .ActiveWorkbook.SaveAs(xPth & "\Abc3.XLSX", , , , , ,XlSaveAsAccessMode.xlNoChange) .Visible = True .DisplayAlerts = False .Workbooks.Close() .Quit() End With it is working very fine, but when i shutdown my system i found a number of excel files(as many times i use this excel file) opened about which system ask to save or not these files. kindly help me. thanks

rmshah Developer

hi all, i have developed an application in vb.net with Mssql Express 2008 which has about 600 store procedures and 200 tables. All are working fine. now i want to install me app to my client (end user) and want to hidden my database from any one other than me.i know how to encrypt a sp. my problem is how i encrypt 600 SPs. if i do it one by one it will be a very big job. kindly suggest me suitable solution. Thanks

rmshah Developer

Hi all, i have developed an application (HR PayRoll) in vb.net. kindly suggest me about suitable device. thanks

rmshah Developer

Hi all Happy new year. Currently i am working on a project which required an Excel File to be opened at the run time in a Richtextbox. i tried the following code Richtextbox.loadfile(path,type) it load the required file but content of the file was not readable. kindly help me. Thanks

rmshah Developer

Hi all, i am looking for help to insert online values in a excel VAT form of Punjab Excise Dept called e filling of VAT. i am using Vb.net 2008 and MSsql express 2008. Thanks

rmshah Developer

hi all, Please help me to solve the following problem. Today i am in trying to send an exe file to my client through e-mail. I attached the same and sent the mail successfully, and asked my client to download the same. But my client found the mail without any attachment.I repeated the same atleast 4 time but my client could not find any attachment. i could not understand, What is the reason? Kindly help me. Thanks Rafiq

rmshah Developer

Hi All, Recently i upgraded my vb.net 2005 application to vb.net 2008 and facing a problem. i have used crystal reports as reporting tool. it works fine in current and earlier. when see a report it also works fine but when i closed it and open another win form not having crystal reports the MainMenu goes missing. i could not understand why it is happened. i am using (Vista 64 bit). kindly help me. Thanks in advance

rmshah Developer

Hi all, Currently i am facing a problem when i try to insert rows in a table dynamicly. i using vb.net 2008 with mssql express 2008.here are the details of my codes USE [database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[TestSp] ( @name nvarchar(50), @tb varchar(200) ) AS BEGIN SET NOCOUNT ON; execute ('insert into ' + @tb +'(xname)values(@name)') END exec testsp 'testtable1','Abcxyz' Error: Msg 137, Level 15, State 2, Line 1 Must declare the scalar variable "@name". please help me.

rmshah Developer

Hi all, i want to use my window base application from different locations. i have an internet connection having speed upto 256 kbps. kindly suggest me the best way. what is the crest and what is the use of it in IT.? Thanks

rmshah Developer

Hi all, I have developed an window base application using vb.net and mssql 2008 express.It is working fine. now i have installed it on my client's machines, But i am facing a problem. my client has two pc One at home and another at his office. One person working on the home pc and another on office pc at the same time. my client wants to synchronize data when ever he wants by using Internet. In response i have an idea in my mind as following step 1 Take backup of one pc(say office pc) and send it to second pc(say home pc) step 2 ask to person working at home pc to download backcopy and restore it on the his pc. step 3 after updating home pc he also take backup of the home pc and same send it to office pc. step 4 at office the person working download the backupcopy and restore the same on his pc. but fear it takes long time and usage of internet. Kindly suggest me the best way in details. Thanks Rm

rmshah Developer

Hi all kindly help me to handle the followings. 1)I have Created a Group Name MasterGroup 2)Created an other Group Name ChildGroup Under MasterGroup 3) Created an other Group Name ChildGroup_A Under ChildGrup Doing like above i have created a Group and under Group hierarchy say up to 6 step deep. Now i have Created some account using group and under group. like:- Id Name UnderGroup 1 abc MasterGroup 2 Bzx ChildGroup 3 Kml ChildGroup 4 Axv ChildGroup_A Up to this there is no problem, But i want to fetch Records group wise. I want result using following sql statements Select * from Tablename where UnderGroup = 'MasterGroup' in response it will show me all records having under group mastergroup and the records having relation with mastergroup. similarly when i use following sql statement Select * from tablename where groupname='Childgroup' in response it will show me only records having the groupname childgroup and records having relation upto Childgroup. I am working in vb2005 and mssql. kindly send me code if posible. a help would be highly appreciated. Thanks rm

rmshah Developer

Hi All, I have developed an application in vb.net and it is working fine. pl suggest me how i keep on top a currently clicked form. Thanks

rmshah Developer

Hell all, i have developed an application say inventory management in vb.net/ ms sql. now i want to install this application on different machines of my clients. i have written maximum code in Sp's and have fear that some one copy it or edit/delete it. kindly suggest me a best way in which no one copy my database or edit/copy/delete it. thanks in advance

rmshah Developer

Hi All, I have developed an application in vb.net 2005/ Mssql express 2005. It works very fine on my machine, but give me problem when i am trying to run it on my remote machine. I am using LAN (Cross over Cable). It gives me an error "Login failed for user 'MyServerName\Guest' when i am trying to run it on my remote machine. My Connection String is like following. Conn = New SqlConnection("Server=myserver\SQLEXPRESS,1028;Trusted_Connection=yes;database=mydatabase") I have done following steps. Sql Server 2005 Surface Area Configuration. I have set Remote Connections Local and Remote Connections. Using Both TCP/IP and Named Pipes. Apply Done. Stop Service and again restart. Sql Server Configuration Manager Sql Server 2005 Network Configuration Protocols for SqlExpress Shared memory = Enabled Named Pipes = Enabled TCP/IP = Enabled Via = Enabled Sql Server 2005 Services Sql Server (SqlExpress) Running. Sql Server Browser Running. Stop and again restart. Ms Sql Server Management Studio SqlExpress. Set Security to Sql Server and windows Authentication mode. But still i am facing the same problem. Kindly help me. Thanks in advance.

rmshah Developer

Hi All, Kindly suggest me how i use same database file from different Computers. i am using mssql express 2005 with vb.net. thanks

rmshah Developer