Re: Access Linked server generates (Error 7399) - Help!
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 19 Sep 2005 19:46:12 -0400
See "Monitoring with SQL Profiler" in SQL Books Online, which has a
wealth of information on Profiler. Your goals is to create a trace,
filtering out all the noise, which would include system databases and
other applications running on the server. All you're interested in is
looking at the SQL statements that Access is passing to SQLS, and what
the result is that the server sends back. Traces consume server
resources, so you want to make sure that you don't pull down more
information than you need.
--Mary
On Wed, 14 Sep 2005 08:51:26 -0700, AdsoftDesign
<AdsoftDesign@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I'm not really upto speed on SQL Profiler . . . Any help on templates and
>settings would help greatly. I have tried but haven't had any luck pin
>pointing this.
>Thanks,
>
>"Mary Chipman [MSFT]" wrote:
>
>> Did you try putting a SQL Profiler trace on the job? That can be
>> invaluable in troubleshooting these kinds of problems.
>>
>> --Mary
>>
>> On Thu, 1 Sep 2005 15:54:02 -0700, AdsoftDesign
>> <AdsoftDesign@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >I have created a linked server to an Access 2.0 database. I have a proc.
>> >that updates a table in the Access database. When executing the proc using
>> >Query Analyzer all works as it should. But, when I created a SQL Server Agent
>> >Job and attempt to run in on a schedule it fails with an error of:
>> >OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [SQLSTATE
>> >42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed.
>> >I have tried several variations of permissions with no luck. Any ideas?
>>
.
- References:
- Access Linked server generates (Error 7399) - Help!
- From: AdsoftDesign
- Re: Access Linked server generates (Error 7399) - Help!
- From: Mary Chipman [MSFT]
- Access Linked server generates (Error 7399) - Help!
- Prev by Date: Re: Help: inappropriate OLEDB timeout:
- Next by Date: Re: Access Linked server generates (Error 7399 / 7312)
- Previous by thread: Re: Access Linked server generates (Error 7399) - Help!
- Next by thread: Connection Pooling(Expecting Quick reply to get help)
- Index(es):
Relevant Pages
|
