Search results for query: *

Hi! I use a VB DLL in which I have written code to form DB Connection String (read from the registry) This logic is written in a subroutine (public) in a modlue of the project. I call this subroutine from Class_Initialize of the Class File. When instantiate this DLL in another project and...

Hello! I have a server side array (VBScript). I pass data from this Server side array to a client side array <SCRIPT LANGUAGE=vbscript> <% For intRow = 1 to Ubound(arrMlt,1) For intCol = 1 to UBound(arrMlt,2) %> arrCMlt(<%=intRow%>, <%=intCol%>) = "<%=arrMlt(intRow, intCol)%>" <% Next...

Hello! I am facing a problem in opening an XLS file available in the webserver. Let us say I have File1.XLS in server SERV1 in the following Virtual Path. http://SERV1/MyPath/File1.XLS. I have the following piece of code in my ASP Page (Client side javascript) var Server_Address =...

Hello! We have to display the contents in a webpage. When the user selects a value from a multiselect list box a Stacked Bar Chart should display the contents in a portion of a page. (May be I can use a IFRAME) The Chart will display Dates in X Axis and Values in Y Axis. Each date will have...

Hi! I have data as below CREATE TABLE #Input (OldAsset Char(20), CurrAsset Char(20), Status Char(3), InpSrlNo INT Identity(1,1), GUID uniqueidentifier, InpProcstat char(1)) DECLARE @GUID Uniqueidentifier SELECT @GUID = NewID() INSERT INTO #Input (OldAsset, CurrAsset, Status, GUID...

Hello! I am generating script for all the Stored Procedures in the DB. I have the following text before each SP script. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO How do I supress this? Thanks in adavnce.

Hello! I have an application that has DLLs, ActiveX DLLs and SQL Script files as deliverables. I have to write a deployer application in VB to install these deliverables in the host computer. I can write code to deploy SQL Script files and DLLs. But I need to create Package for the ActiveX...

Hello! I have a requirement to find the number of DML statements (SELECT, UPDATE, DELETE) in all Stored Procedures in a database. Is there any way to get it quickly. Thanks in advance. Karthik

Hello, I have been encountering this problem. But on an increased frequency off late. A Stored Procedure which is not giving desired output. Say returns a wrong row or value in the recordset being returned. When we take the text of the SP from the same database, using SP_Helptext and...

If any one has any idea to do this, will be helpful.. 1. I am trying to connect to my SQL Server database using a DSN. 2. I have given UID/PWD (SQL Authentication) in my DSN and have given a default DB. 3. I am trying to execute the following code in VB <CODE> Dim oADO As ADODB.Connection...

SQL Server Documentation says, "SQL Server supports both the SQL-92 outer join syntax and a legacy syntax for specifying outer joins based on using the *= and =* operators in the WHERE clause. The SQL-92 syntax is recommended because it is not subject to the ambiguity that sometimes results...

Hi! I have a need to show a text file in notepad to the client. The text file is generated in the server and will be available in a designated location in the server. When the page gets downloaded in browser (IE), the browser should open instance of notepad and display the content of the text...

Hi! A wierd behaviour that I am comming across. I have a common function in a .JS file which will open a new window. function windowopen(path,nm,attrb) { var filename = CtrlForm.gCFile.value var newpath = path hlpwinref = window.open(newpath,nm,attrb) } When I call this from my ASP page...

Hi! I would like to know if I can call a function that is not in the current database. I know we can access tables of another database. 1. Say I have two databases MyDb1 and MyDb2 in same server. 2. There is a function dbo.MyFun1() in MyDb1. 3. I would like to call this function from MyDb2...

Hi! I need to create a user with Sysadmin fixed server role(so that the user can use SQL Profiler). However I want to prevent the user from creating and dropping databases. Is that possible? Thanks in advance Karthik