Search results for query: *

SQL Server 2000 I have a DTS that just copies the data from one database to the SQL server. No custom code involved. This works for all 69 other tables but this one table is giving me the error: "Error at Source for Row number 1. Errors encountered so far in this task: 1. Multiple-step OLE...

SQL Server 2000 Is it possible to trigger a backup from a DTS package? I need to perform a backup once a month but the dates vary so scheduling won't work. Also, it needs to be dummy proof so for someone to just trigger the DTS which could trigger the backup would be ideal. Thoughts? Thanks...

I have a form with a cmd button that imports data from another DB into my DB. I'm not to DB VBA coding so here is what I have (which works for one table): DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=XXXXXXXXXX", acTable, "DB1Table", "DB2Table", , False Now, I have over 100...

CR10 SQL DB I have a main report with a subreport and a formula field called @time in each (that's how they are linked). The @time field takes the time (in a field in the DB) and removes the date and the seconds from it. Here is the code: CTime(Mid(totext({Pages_ADV_All_Sites.Time}), 12,6) &...

Here's what is happening, we're changing to a new domain and moving the SQL2000 Server off of the server that houses CE10 and moving it to a dedicated SQL server. CE10 will remain on the same server. What I need to do is move the CMS (instances, schedules, users, the whole works) from the...

Server: Win 2003 Server IIS 6 CE 10 Report: CR 10 Advanced Developer I've created a report that runs off of a tab delimited text file. When the report is ran from Crystal Reports, the report works fine. When I put it into CE and try to run it, CE prompts for a password (which there isn't...

WinXP CR 10 I need to search all the names in a report to find the ones that end with either " OR" or " AND". If there are some, then I need to remove that part of the name. The I'm having problems with the fact that all the names are different lengths so how do I say, go to the end of the...

Here's the problem... I have 88 tables (2 of them are linked tables). What I need to do is import data (into these 2 tables) from another datasource based on queries that are set up. For instance: I have a query that looks at all the records in the "DEPLN" table and pulls out only the Loan...

I have a nvarchar field (COLDES) in the db COL. I need to replace any comma in the field with a space (there are about 10,000 records to go through). I've created a Stored Procedure that looks like this: CREATE PROCEDURE [dbo].[LoanAnalysis_Update] AS BEGIN UPDATE COL SET COLDES =...

Windows Server 2003 Director Server/Console/Agent 4.21 We have a few computers on our network that are connected to the network but are not registered on the domain. These machines have Director agent installed and we use them as relays. The problem I've run into is that these machines have...

We've upgraded all of our workstations, clients and Servers to Director 4.21 (WIn XP workstations, Win2003 server). Now, we have a group of workstations that all show up as unavailable when they ARE turned on. If I go and reset the computer, they will show up but some time over night they will...

I'm trying to install IBM Director Server 4.21 (upgrading from 4.12) but I'm running into a problem. Installing on a Windows 2003 Server (Standard Edition). Part way through the install an error message pops up... ****IBM_ERROR -- C:\WINDOWS\system32\wbem\mofcomp.exe "C:\Program...

I've just installed RDM 4.11 on a Director 4.1 server. When I go to add or remove a task, first i get the below in the event log: (we use Director Console 4.12) Unhandled JVM Exception Application: 'ibm|rdm.30 (TWGVersion 4.12 2004-02-22 build id 464)' Thread Name: StcManagerRunner Thread...

Is there a problem with installing RDM on a 2K3 server(is the management server) and have DHCP on a Win NT server?

DHCP - Win NT 4.0 RDM - Win Server 2K3 We've been experiencing a problem where systems are being delivered duplicate IP addresses. From what I understand, our DHCP server issues an IP, then at night Director boots the systems to the network and RDM delivers a new IP address. Turns out RDM is...

I'm trying to link two DBF files in Crystal but the problem is that in the Names DBF, the account number is 7 characters and in the Deposit DBF, the account number is 9 digits (an extra 2 digits added on the end). Without manually going into the table and removing the last 2 digits from every...

I have 3 databases: db1 db2 db3 Each database has a table that I has a field that I need to compare between the three: db1 - memshp.memshp (number) db2 - names.acct (character) db3 - names.acct (character) What I need to return are all the records from all three databases that have duplicate...

I have a parameter that accepts a range of numbers. Is it possible to show on the report the range that the user has entered? IE: user enters age range 19 - 30 in parameter field. The report should have the title "...ages 19 to 30". I'm not sure where to start...

I'm editing the Software Dictionary and I'm trying to get Director to locate a file in a specific folder, and call it Software A but if it's in a different folder, then it's software B. If I just enter the file I'm looking for, then it finds it (in either location) but if I enter...

CE 10 Win 2K3 When running a report in CE, the font used displays differently than prints. The font we are using is Script MT Bold (a basic font). The font that is shown when viewed through the web is Time New Roman. The font that prints on the printer is Script MT Bold (the correct font)...