Search results for query: *

I eventually figured out why this issue occurred & the solution would seem to me to be very strange. But, just in case someone ever has a similar problem. Here is how the issue was resolved. I ran a tracert to the IP address of the SQL 2005 express database server. - I ran one from my...

Hi, I have a problem using DTS (within SQL 2000) connecting to SQL 2005 Express using Ole DB provider. It is an old problem that I never got round to solving. I have had a work around in place for years... On my development pc, I have a developer edition of SQL server 2000. From here I can...

Well spotted... I should have posted back here after discovering the issue. The issue is as provided by Roadki11 in the link above. We are using the content management system Ektron. A component of the functionality in this system (note: in an earlier version of the system) created a dll file...

Thanks for the quick response. I used process monitor, & added the path to the temporary folder. To watch when a file first appears & what processes touch it. The files are being accessed by: w3wp.exe, cidaemon.exe, ciscv.exe, cvtres.exe. It looks like it is first created by w3wp.exe, then the...

Hi, I hope there is someone out there that can help with this query. I have a server used for hosting a website. The server operating system is Windows Server 2003. The website uses IIS. The website is deveopled with Visual Studio 2005 (all aspx pages). The problem I experienced was that the...

Hi, Does anyone have experience with what appears to be a database called FormBase. I've inherited an old system or application called FormBase & would like to extract the data, or better understand how data is stored. It appears to have been created by Columbia Software. Version 1.1 - July...

SOLUTION... I eventually figured it out... But maybe it will be useful for someone else! (so I'll leave the code here) **Note: You need to have a CONNX Data Dictionary set up. Then using the data dictionary, create a DSN "yourDSNName". Sample Code as follows: Dim cnxConnection As New...

Does anyone know where I could find some sample code for vb.Net. To connect to a CONNX Data Dictionary (which is build on Dibol RMS files). I've been to the connx website, I know how to reference the "System.Data.CONNX.CNXCommand" but I have not got a clue of the code to open the connection...

Hi, Excellent tip! I found that the offset can be different for each um.dat. As the um.dat is ordered alphabetically by login. If you have a user name that appears aplhabetically before "Admin" they will appear at offset 80. And Admin will apear further down the file. morgancrr tip is...

Hi, I have always called DTS packages through jobs by using the xp_cmdshell. I've always called the DTS with a systems administrator name & password. execute MASTER..xp_cmdshell 'dtsrun /S<ServerName> /U<User> /P<Password> /N<DTS_Name> & it's always worked successfully. Now I need to trigger a...

Hi, I have created a DTS package, that does some processing and then calls an application (.exe) file. When the application has completed the DTS carries out some more processing. My problem is: The DTS can be executed with no problems, but when the DTS is scheduled as a job, the .exe file...