Solved

MS Access adp to SQL 2000 connection failure

Posted on 2006-07-04
11
479 Views
Last Modified: 2008-01-09
Im working with Win 2003 Server, SQL Server 2000 (all on the server) and my client machine is Win XP as a client - has SQL client tools and MS Access 2000. I have an adp linked to SQL server. All working fine. Network is new.

So I opened the adp file and made some (very minor) adjustments, when I tried to close and save, the write failed. Came up with a message about "Delay write failure  Event ID 26 Failure of hardware or network connection" This in turn creates an file named adp1 whilst trying to write? When i tried to re-open this adp file (which is still and adp file) the error message is "adp file not correct format for Microsoft Access Project"

We've just set up this network and noticed that the connection to the server keeps dropping. This is possibly the problem, could anyone point me in the direction to analyse the set up for the connection?
0
Comment
Question by:Donnaa5dcp
11 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 17036253
What kind of event happen when the ADP initializes...Have you changed providers?
0
 
LVL 5

Author Comment

by:Donnaa5dcp
ID: 17036634
No event when the adp initialises. Just that error msg. I have no provider, its a stand alone network
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 17036788
what do you mean by stand alone network?
0
 
LVL 5

Author Comment

by:Donnaa5dcp
ID: 17036810
There is the server, the wire and 3 client machines.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 17036838
If the applications are on the client machines, I do not see how you could not be using a provider? How does the client application call the server?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 5

Author Comment

by:Donnaa5dcp
ID: 17036844
This is not done over the Internet. I have the application SQL Server 200 here. I installed it on the server myself.The provider, if you like it the organisation, which is fibre optic linked.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 17036862
Oh I got it ;)

I am not refering to provider as internet provider but the logical provider that regulates exchange between you client apps and server (ODBC, OLEDB, SQL Native...)
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 17046985
I believe ADPs' only use OLEDB connections. When you intially configure an ADP it uses the OLEDB driver and you enter the connection stuff, just like a UDL file but you don't get to pick the provider.

Was this ADP file on the server or on the local workstation when it crashed?
0
 
LVL 5

Author Comment

by:Donnaa5dcp
ID: 17048650
Ive solved it. Its the properties on the network card. I unticked "allow to disconnect if idle" box. Simple one really
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 17105367
Closed, 250 points refunded.
Netminder
Site Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now