Viewing 15 posts - 16 through 30 (of 32 total)
Sorry, I forgot to mention that you have to delete the lock files..... PDOXUSRS.LCK and PARADOX.LCK need to be removed from the copied files... These two files should be in...
November 30, 2004 at 8:04 pm
You cannot open Paradox files that are being used by other users unless you are looking at the same pdoxusers.net??(the locking file) file as whoever is using it... you may find that the...
November 30, 2004 at 3:19 pm
Hi Andy,
When you run a DTS package manually it uses the account that the scheduling tool is logged on as. What scheduling tool do you use? I use the Microsoft...
November 28, 2004 at 4:59 pm
Found this code, tried it and it worked...
SELECT count(*) RecNum,
a.LastName
FROM Northwind.dbo.Employees a join
Northwind.dbo.Employees b
on a.LastName >= b.LastName
group by a.LastName
order by a.LastName
Url for it:
November 10, 2004 at 10:35 pm
As stated you have issues with the credentials. When you run a DTS package using the job sceduler within SQL it uses the account that SQL uses for the service......
October 21, 2004 at 7:48 pm
Are you loading the data using Access or SQL
October 19, 2004 at 12:24 am
Hi Perry,
Have you seen this?
http://support.microsoft.com/default.aspx?scid=kb;en-us;323630&sd=tech
What Microsoft have to say about it..
Plus found this from similar source:
I've found out why there are suddenly so many lock escalations!
The...
October 13, 2004 at 12:46 am
Isn't Pervasive fun. Are you running your odbc connections to Pervasive using the client engine or the Engine interface? Pervasive also works in interesting ways... it can actually download the...
October 13, 2004 at 12:37 am
Are you trying to run this as a local package on the server or from another location?
Michael
October 12, 2004 at 11:39 pm
Have you thought about deleting these customers using a DTS package. I have found that when things time out I can use a DTS package, which has the ability to...
October 12, 2004 at 11:30 pm
Hi, I use the gui for creating the scheduled job. The account you are using... read_report... is that a domain account? You can't use a sql account or a local...
October 11, 2004 at 12:19 am
I have a feeling that I have confused you. When I say that you will be scheduling a task. I mean that you use Windows scheduler on the server to...
October 6, 2004 at 8:48 pm
Sorry, as with most things they are either so easy they dont get explained properly or too difficult to explain properly.
When you are logged on using your logon account the...
October 6, 2004 at 4:36 pm
We had issues running a DTS package linked to Oracle. DTS packages run using the account that SQL server runs under (usualy the default local system account). The 'contractors' that...
October 5, 2004 at 4:01 pm
Hi Metra,
I did a Google (as I do every problem...) and got this:
FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server...
October 5, 2004 at 1:21 am
Viewing 15 posts - 16 through 30 (of 32 total)