Viewing 8 posts - 1 through 8 (of 8 total)
Interestingly I experienced something very similar on a Customer's site yesterday. They happen to be on SQL2005, although our packages are Legacy 2000 style DTS packages. Again they had been...
March 11, 2008 at 4:45 pm
It is also possible to use QUOTENAME to generate the required quote marks for your existing query
January 29, 2007 at 9:25 am
Try setting the Password property of the connection instead.
This is 'hidden', and can be set in a disconnected edit.
April 12, 2006 at 5:49 am
In the Link Tables dialog, you can select "Save password" checkbox. This will prevent the request for a password in your app.
March 17, 2006 at 5:20 am
What often happens when SQL Authentication is used, especially in Novell environments (not sure if you are) is that the Windows authentication to SQL is achieved by mapping a drive...
October 31, 2005 at 4:47 am
Sounds more like a permissions problem for your Windows user.
Is it a memeber of the same group where other users are allowed in?
Has it been revoked access to SQLServer perhaps...
October 31, 2005 at 3:42 am
If I am right, you are working in Access not SQL so the Change Owner Sp will not work.
All you need do is rename the linked table entries in the...
June 10, 2005 at 4:27 am
Have recently been through this process at a number of customer sites.
There is a known problem specific to upgrading to SQL2000 with SP3 applied where your SQL6.5 system...
June 4, 2004 at 2:04 am
Viewing 8 posts - 1 through 8 (of 8 total)