Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, October 19, 2007 6:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 13, 2014 12:59 PM
Points: 126, Visits: 535
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 6,743, Visits: 8,515
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 http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

but mdac_typ.exe is also on your install disks.

component checker can be downloaded at http://www.microsoft.com/downloads/details.aspx?familyid=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en


Johan


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