Advertisement

10.23.2007 at 03:54PM PDT, ID: 22913314
[x]
Attachment Details

Error connecting adp file to SQL Server 2005 Instance

Asked by kalliopi in Microsoft ADP, Microsoft Access Database, SQL Server 2005

Tags: , , , ,

Hi,

I have a new SQL Server 2005 Install and can't connect my MS Access 2003 ADP file to it any more.  I've done this in the past without issue, but now it's not working.

There are a couple little things that I'm doing differently this time, one is that when I installed SQL I used a named instance instead of the default.  I can connect without issue to from SQL Server Management Studio using the IP to connect, but from MS Access I try connecting to the <IP> or the <IP>\<the instance> but neither way works.  I get the error: "[DBNETLIB][ConnectionOpen (Invalid Instance()). Invalid Connection."

I'm not sure if the Instance name is the problem, or something else with the Install.  Any suggestions for help would be greatly appreciated!

ThanksStart Free Trial
 
Keywords: Error connecting adp file to SQL Server…
Title
1 Access ADP is sending sp_fkey rathe…
2 Network error problem with Access adp
3 Query about ADP Files
4 ADP and Export
5 Access ADP over WAN
6 Access ADP is crashing when a form …
 
Loading Advertisement...
 
[+][-]10.23.2007 at 04:21PM PDT, ID: 20135345

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.23.2007 at 11:03PM PDT, ID: 20136581

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 08:08AM PDT, ID: 20139634

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 09:20AM PDT, ID: 20140336

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 09:25AM PDT, ID: 20140375

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 10:06AM PDT, ID: 20140803

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 10:13AM PDT, ID: 20140874

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 10:31AM PDT, ID: 20141059

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 10:34AM PDT, ID: 20141090

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 01:24PM PDT, ID: 20142600

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 01:26PM PDT, ID: 20142630

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 04:56PM PDT, ID: 20143858

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 05:19PM PDT, ID: 20143986

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft ADP, Microsoft Access Database, SQL Server 2005
Tags: sql, server, adp, 2005, instance
Sign Up Now!
Solution Provided By: cmangus
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906