Recent content by Earthworks

Briefly... I have an ADO .NET data source to a remote SQL 2000 server with a SQL Command that does a simple Select from field1,field2 ... from a table on the reomte server An OLE data destiation to the local SQL 2005 server extracting the rows from the remote to local server

I have a package which runs with TransactionOption set to Supported but not when I set it to TransactionOption Required. Package freezes at following point in the Progress results. "Information: Starting distributed transaction for this container." I have to stop debugging after leaving it...

I'm trying to query the domain active directory (AD) from a DMZ. The firewall is open for port 389. Once I move my script from the domain into the DMZ it no longer works. Are there additional ports that require opening on the firewall? I've tried replacing LDAP://DC=doaminname,DC=com with...

Is it possible to export document fields to a preformatted MS Word template? If so some code to outline the basics (or the whole solution) would be appreciated.

Thanks - what needs changing? The agent does not appreciate me cutting and pasting from the querysave event. Code Below: Dim session As New NotesSession Dim workspace As New NotesUIWorkspace Set uidoc = workspace.CurrentDocument Set db = session.CurrentDatabase Set uidoc =...

I have some work done for new documents in a postsave event. (create 11 related sub documents using @DocumentUniqueID to link them) However, I have 400 existing documents that I want to run this work on. If I can open each in edit mode and save again, hopefully my postsave event will run and...

Ok - as I have only a few months experience, I will lose the Notes locking and implement your suggestions as the system with the locking issue, is not useable and does not help instil user confidence. Thanks

Thanks for your reply. The database is on a server. I'm using the Database -> Properties -> Allow Document Locking and nothing else. Think I may have to turn this off and when a user attempts edit mode check if it is already in edit mode and not allow them to go into edit mode if another user...

I have a form that randomly does not release the edit lock and have had to code an unlock button for users to get around the issue until resolved. All clients are the same version 6.5.1 and accessing the db from a Citrix session. I have investigated every possible cause with no success. Is it...

I want to prevent the user from gaining edit mode to a form based on the value of a field on the form. i.e. the form should not be editable after a review date has been entered. If it is blank the form can be edited.

The DTS Wizard has only created one Copy SQL Server Objects Task - Have I used DTS correctly for what I'm trying to do?

I have 2 databases@ LIVE and RELEASE with the same tables in both - I have added fields to a table in RELEASE and now I'm trying DTS to copy the data from LIVE to RELEASE. It keeps failing. Is it because of the different table structure. DEV and RELEASE are the same for the first 12 fields...

DTS Package source is a SQL query. When using the preview button the result columns are in the same order as in the SQL query. The destination tab shows the result columns in the order I require. The transformation tab shows the columns in the order I require. However when I use the test...

Hi, A while back I set something to delete the swap file everytime I shut down the PC. As this is slooooooooow it is now very annoying. HOWEVER I cant remember where or what I did. Can someone please remind me.........

I did not change this setting so it is set to its default value. As the site is some distance away I will have to visit to check this setting. What should it be? PS Thanks for the ICS tip