Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

connecting to a sql server 2000 named instance Expand / Collapse
Posted Friday, October 19, 2007 6:20 AM


Group: General Forum Members
Last Login: Monday, October 19, 2015 11:10 AM
Points: 128, Visits: 561
I have an application that is accessed by desktops and laptops. I can access the sql server 2000 named instance fine at the desktop level but not with the laptop. You wouldn't think it would make a difference. I believe accessing the application via the laptop performs a download of some of the database objects. Any ideas and does anyone have a sample connection string to logon to a named instance?
Post #412723
Posted Friday, October 19, 2007 7:09 AM



Group: General Forum Members
Last Login: Tuesday, October 25, 2016 8:37 AM
Points: 6,822, Visits: 8,830
check the MDAC level of the devices that are not able to connect to your named instance. It should be at least MDAC2.6 at client level.

btw you can download it the latest at

but mdac_typ.exe is also on your install disks.

component checker can be downloaded at


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution"

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #412773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse