Search results for query: *

We're using HS from an Oracle 10g instance to connect to a SQL server 2000 instance. We can use a 'select' query to find single values from a result set, but how do you return entire multiple rows? The syntax we use for single values is: DECLARE c INTEGER; nr INTEGER; val1...

I'm hoping someone out there can help. I have an Excel workbook (2002) which runs many queries & procedures against remote ADODB connections using VBA. Using the 'Workbook_BeforeClose' event I'm able to remove sensitive data & save prior to closure. On the user quitting the app, instead of just...

We're using CR8.5 to create reports in an application using an Oracle 8i DB. At run-time the reports are using the currently logged-in users credentials. Is there a way to return the logged-in username to a Crystal Report along the 'SELECT user FROM dual' function in Oracle?

I'm using CR8.5 against an Oracle 8 DB procedure and need help with the following if possible. Data records contain a start date and an end date(say D1 & D2), I need to include all records that have an end date that is either Null or ends within user defined period(start & finish), I then need...

I'm hoping that someone here will help me with a formula needed for a report. Currently using CR8.5 & Oracle 8. The criteria for the report states that only individuals who attained the age of 16 within a given period will be included within the report. I can calculate age as of current date...

Forgive what may be an obvious question to some of you out there but I could use some pointers in solving a problem. We have two group companies each with their own DB on our SQL server. We use Crystal Reports 8.5 to report on various aspects. I wrote most of the reports for only one DB, and it...

Hi Guys I'd like some advice to what is probably a simple issue to some of you, hopefully! We have two servers at work, one running SBS2k and a second running as a SQL server (also 2k). I need to create network share on the SQL box but when I do I get 'you do not have permission to access this...

I've recently set up a lan to lan vpn with a remote office with only four users. Using the vpn server facility of two Vigor 2600 ADSL routers everything seemed to go fine, it's only after a couple of days that we've noticed that if one user is using outlook to collect his/hers email that no-one...

Just a search for advice from any guys out there who may use VPN's either as individual teleworkers or Lan-to-Lan. At present I have two private sub-nets connected via a lan-to-lan VPN using Vigor2600+ ADSL routers. The routers act as VPN servers and are set to maintain a connection, the reason...

I've noticed recently that mail from any Hotmail accounts do not seem to get delivered to recipients on our domain. I can see the message arrive through message tracking, but then after the "started submission to advanced queue" it just disappears! Has anyone else experienced this, and if so...

Recently noticed that any mail from Hotmail isn't getting through to the recipients on my domain. Checked the message tracking utility and I can see the mail being submitted to the advanced queue - and then nothing! The mail seems to just disappear. Dropped the firewall briefly and re-sent a...

I am not receiving mail from a remote user (AOL account). Tracking centre finds emails and seems to proceed to submitting to advanced queue..........then nothing. Question is - is this the stage at which SAV picks up infected mail? Or does anyone have any other suggestions?

I'm having difficulty managing some client computers through the AD users & computers snap-in on our server. I can connect to 2k and some XPP machines but not all, the error message is that 'xcomputer cannot be managed'. I've compared services running and user accounts on all machines and they...

Running BE9.0 on a DC fitted with a Seagate Travan drive, seems to back up OK but won't restore! Returns an error code of "TFLE_UI_HAPPY_ABORT", ran a backup to disk and that restored OK - backed it up to the tape and same error repeated itself! Refers to backup errors - do you reckon...

Our CEO is unfortunately getting frustrated due to his inability to remember how to logon to his WinXP Pro workstation. Even when written down he tends to lose whatever its written on. Is there a way for him to be automatically logged on to the domain on startup? His PC is in a locked room when...

Since having to re-install VBE 9.0 I've been having all sorts of problems that I didn't before. After setting up Backup to disk folders and media sets the jobs keep failing at test with the media capacity check. Not being in any way very knowledgable about VBE can anyone advice me on the correct...