Search results for query: *

I'm trying to write a stored procedure that will loop through a schema looking for a string. I need it to search all tables and all columns. I'm able to get the list of all of the tables and columns to search and then populate a temp table with them. I can't get the syntax correct for...

I've got a bunch of Sun Servers (6800's, 6900's) running Solaris 9 that I'd like to turn into Virtual Servers. In other words, make one of my 16 processor 6800's into half a dozen Linux Servers. I'm having problems finding a virtual server product that can use Solaris as the host os. I've looked...

I'm writing a procedure to rebuild indexes from one tablespace to another. The procedure compiles fine but when I run it I get the following error: HDEV8> exec rebuild_indexes('PSINDEX','PSINDEX1','N','N'); BEGIN rebuild_indexes('PSINDEX','PSINDEX1','N','N'); END; * ERROR at line 1...

I'm inheriting a new project that uses Oracle 10g Lite to synch up with a larger Oracle 9i Database. The application is using the OC4J that comes with Lite instead of a an Oracle Application Server. My understanding is that the OC4J should only be used for development and testing. Has anyone...

I'm trying to use the code below to send an email from my vb application. I get the following error: Run-time error '429': ActiveX component can't create object The error occurs on the .Send command. I'm trying to do this on Windows 2000 Professional. I registered cdonts.dll. Do I need to...

I'm new to PHP and have inherited a site that has a page for file uploading. The site doesn't work. Before jumping in and trying to fix it I thought I'd look at some examples and try to create a simple page first. My example consists of 2 pages (upload.php, upload.html). The code for both is...

I am trying to pass 10 parameters to an Oracle procedure and get a recordset returned. The procedure executes correctly in SQL*Plus and when called from an Oracle form. I have searched microsofts knowledge base, oracles metalink, and google extensively and tried numerous ways. The code from...

I can't get my Oracle 9i JSP reports to run on Oracle 9iAS. I get the following error: oracle.jsp.parse.JspParseException: Line # 1, Error: java.lang.ClassNotFoundException: oracle.reports.jsp.ReportTagExtraInfo at...

Is it possible to use multiple recordsets with an Oracle Database? If your connecting to SQL Server or mySQL you can do somthing like this: private sub Example Dim sSQL Dim oRS Dim oCON set oCON=server.createobject("ADODB.Connection") oCON.Open ("SOME_CONNECTION_INFO")...

The following code extracts software information from the WMI. It works well. However, I notice in the Windows MMC there is also information on Internet Explorer. The IE information is not stored in the same place in the WMI as the other software information. I've read several articles on...

I am trying to execute a stored procedure in my Oracle Database from within my SQL Database. I have linked the SQL Server to my Oracle Server. The select statement I have below works. select * from openquery(OrclSvr, 'select * from pa_projects') But when I try to execute the stored procedure...

I have some code in an Access 97 database that performs a screen scrap and populates a form. All of a sudden the code has stopped working. Nothing was changed. The code compiles fine but when it runs I get the following error: "The specified module could not be found." After I...

I am using an Access 97 database on a Windows 2000 machine and get the following error when I try to print a specific Access report. "There isn't enough free memory to update the display. Close unneeded programs and try again." The report prints fine but the message always comes up...

I need help seperating a large string and placing it in 3 variables. The varibles are sClassID, sClassName, and sDate. The string is in the following format: sClassID & "--" & sClassName & "-----" & sDate On the screen it looks like this: 12 Cost Management...

I have a form with two list boxes. I populated the first list box with data from a database. The second list box is populated from the first one. The user picks things from list box one and they are entered into list box two. List box two will contain about 15 entries that I want to insert...

I need to write some ADO code in an Access 97 database and am having trouble with the connection. How do I set the connection object to the current database? Do I need to provide a connection string like you do in visual basic? I seem to remember that in DAO there was a CurrentDb() function...

I am writing a program that needs to open an existing excel worksheet, create a chart, and then save the chart to HTML. I am using the Shell() function to open the existing file but how do I access the sheet once its open. I assume I need to create some kind of object. I know how to create a new...

I use the code below to make sure the user has entered a UserName and Password before enabling the OK button. I have used this exact code in other applications and it works fine. In the current application I'm developing this code never executes. The Form_KeyUp event never gets called. Anyone...

I am creating an application that will have a lot of users and I need to minimize the number of trips the program makes to the database. I am trying to make the program execute on the client machine as much as possible. When the user initially logs on the program retrieves a recordset from the...

I am populating a list box from a database using the following code: Do Until MyRS.EOF with lstProducts .AddItem MyRS(0) .AddItem MyRS(1) .AddItem MyRS(2) .AddItem MyRS(3) MyRS.MoveNext loop The data displays in the listbox but in...