Search results for query: *

I have a SQL Server 2000 with SP3a running on Windows 2000 Server and a job that is scheduled to run twice a day (2PM and 8PM). The job executes a DTS Package by running the following command: DTSRun /S "(local)" /N "KHH_LoadGL" /R "." /G "{396FE90C-257D-4FA4-AD4E-B7040DCF0E55}" /L...

I am trying to post some of my reports on the web and they work fine if the reports do not have subreport. When I have a report with a subreport I getting the following error: Missing prompting unit. Description: An unhandled exception occurred during the execution of the current web request...

I am trying to get the OU from AD using the following query: SELECT * FROM OPENQUERY(ADSI, '<LDAP://DC=test,DC=COM>;(&(objectCategory=Person)(objectClass=user)); ou, sAMAccountName, givenName, sn, name, PhysicalDeliveryOfficeName, homedirectory, telephoneNumber, department, mail,info...

I am getting the following error when trying to run the reports on a machine. It runs correctly when I run it on my dev machine but fails on a production machine. The application is a stand alone application. I distributed the application using the setup project in VS2003...

I am having problems with login into the SQL Server using the osql -S XXXX -U xxxx or osql -S XXXX -U domain\xxxx I get "Login failed for user xxxx" I can login with osql -S XXXX -E The server is set under the Authentication to SQL Server and Windows. I need to use user name because...

Hi I have a form that has a grid that can change depending on the user properties and available modules. The fields in the grid are populated from a database. What I want to achieve is when you click on the grid the on click event will check what function has to be called and calls it. How...

I have a problem with a report which has 2 subreports. When I try to run it from vb6 I get &quot;Server has not yet been opened&quot; error message. The data is retrieved using SQL stored 3 stored procedures. one for the main report and 1 for each of the sub reports. the code that I am using...

Hello I have few stored procedures that need to use a temporary table. In MS-SQL that is easy by just doing SELECT A, B INTO #tempTable1 FROM ABC Then I have to use the temp table to get the correct data. How do I do a similar statement in DB2. Thanks for any help

I am trying to access date in second database using stored procedure that is called from the first database. Both databses are located on the same server. In MS-SQL it was simmple you just do: Select * from DB2.DBO.TABLENAME How do you do similar select statement in DB2. Thank You

Hello I need to create few stored procedures that will be able to access another database on the same server and combine the information selected with data that resides in the db from which the sp was called. I am running DB2 V 8.1 on Windows OS. That is easily done in MS SQL but I don't know...

Hello I am trying to create a test stored procedure. I know the syntax of the sp is correct but when I try to build I get the following log and it says that the sp build failed. BUSDAT.ADMINISTRATOR.PROCEDURE1 - Build started. Create stored procedure returns -7032. -- LOG FILE P4373962.log...

I have a problem with a MSDE installation. The MSDE was installed on the Domain controler computer correctly. I am able to log in from command prompt by typing the following statements: osql -S SERVER -E or osql -S SERVER -U sa SERVER is the name of the Machine I also created database. If...

Hi I am new to DB2 I am creating few sotred procedures in one of my databases. Some of them need to retrieve data from another database that is located on the same system. I am not sure how to do so. Thanks for any help Pawel

I have a question. Can you encrypt a stored procedure in pervasive? Thanks, Pawel

Hello I need to create a stored procedure that will select some data from table into temporary tables and then I need to union the temp tables to get the data I need to get. In SQL Server that is easily done by doing Select xyz into #temp form xyz. How do I do the same in Pervasive. Thank...

I am new to Pervasive and I am trying to create stored procedure which inserts data in to a table. The stored procedure has to check if a record already exists and if it does then it just updates the record on the other hand if the record does not exists it inserts the info into the table In...