Connecting to SQL Server with Access 2003

[Joe Black]

Hi all,

I have a site with about 50 PCs, these all run XP pro other than 2 W2K
machines, I have Office 2003 Pro installed on all these machines. On the
Server is Windows 2003 server and it has an instance of SQL Server Express
running on it, I also have an instance of SQL Server 2000 running on another
machine.

My problem is as follows:

I open MS Access and select new, then select create project with existing
data, I give this a file name and I am prompted with the Data link
properties window. In Windows XP I can select from the server list all of
the SQL Server instances on the network, but with Windows 2000 this list
shows neither SQL Server 2000 or Express instances.

Does anyone know why this is the case and how to resolve this problem?

My google searches have revealed no specific information, but maybe I am not
asking it the right questions :-(

TIA

Joe

 

[Norman Yuan]

Try to manually enter the SQL Server/SQL Express server (and instance) name
into the combo box, select appropriate login security and then click
"Refresh" button.

 

[Joe Black]

Hi Norman,

Thank you, but I have tried this already, I should have mentioned this in my
first post. When I do this and select Test Connection I get the following
error though:

"Test connection failed because of error initialising provider. [DBMSSOCN]
General network error. Check your network documentation."

I don't know if this helps at all.

Cheers

Joe

 

[Pepe]

Be sure to have installed on the W2k machines the lastest MDAC.

Regards

 

[aaron.kempf]

more importantly dont you need all this Native Client bullshit on each
of the desktops?

that's the provider you're trying to use right?? DBMSSOCN?

 

[Wei Lu]

Hi Joe,

Welcome to use MSDN Managed Newsgroup Support.

Have you tried the suggestion Pepe provided?

You can find the latest MDAC in the following site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Joe Black]

Hi Pepe,

I have just given that a try, sadly it still exhibits the same problems. I
have applied all the latest updates from the microsoft update site too, and
still no joy :-(.

Thanks

Joe

 

[Joe Black]

Hi all,

I got it working, many thanks to all of you for the help.

I needed MDAC 8 installed as Pepe suggested, then I needed to type in the
server as Norman suggested.

Joe

 

[Pepe]

BRAVO!!

Hi all,

I got it working, many thanks to all of you for the help.

I needed MDAC 8 installed as Pepe suggested, then I needed to type in the
server as Norman suggested.

Joe