RE: Connecting to SQL Server
From: Steven Liu [MSFT] (stevenl@online.microsoft.com)
Date: 04/04/03
- Next message: Steven Liu [MSFT]: "RE: I can't get to https sites"
- Previous message: shawn: "Computer Administration Password does not work"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: stevenl@online.microsoft.com (Steven Liu [MSFT]) Date: Fri, 04 Apr 2003 02:27:52 GMT
Hi James,
The latest MDAC is the version 2.7SP1. It contains the latest ODBC. It's
also integrated with the Windows XP Service Pack 1. Please make sure you
have installed the Windows XP Service Pack 1.
Some older applications that do ODBC data access to a SQL Server etc may
require the use of older versions of the sqlsrv32.dll drivers.
However if the system is updated, eg with MDAC 2.7, the older application
fails to funcion, as the default sqlsrv32.dll has been updated
MORE INFORMATION
================
It is possible to set up and use alternative ODBC SQL Server data sources,
using older drivers, in addition to the standard drivers.
Standard drivers are usually stored in system32
The ODBC configuration defines what drivers are used and where they are
located
Eg if the application requires a data source called Test32 that needs to
use the older sqlsrv32.dll version 2.6
Set up a dedicated c:\winnt\system32\sqlsrv_26 directory containing the 2.6
versions of the sqlsrv32.dll and sqlsrv32.rll files
Set up a Driver called SQL Server 2.6 under
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBCINST\ pointing at
c:\winnt\system32\sqlsrv_26\sqlsrv32.dll
and set Test32 to use the "SQL Server 2.6" driver
Let's see whether this works.
Thanks for using Microsoft News Group!
Sincerely,
Steven Liu
Online Support Professional
This posting is provided Ħ°AS ISĦħ with no warranties, and confers no
rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "James" <jblackburn@freedomcorp.com>
| Sender: "James" <jblackburn@freedomcorp.com>
| Subject: Connecting to SQL Server
| Date: Thu, 27 Mar 2003 08:21:58 -0800
| Lines: 11
| Message-ID: <009b01c2f47c$fdb1b880$a101280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcL0fP2xUEJ/MW4NSUuRm6XxjX+vMA==
| Newsgroups: microsoft.public.windowsxp.security_admin
| Path: cpmsftngxa08.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.windowsxp.security_admin:52094
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.windowsxp.security_admin
|
| I am unable to connect to SQL Server with a user with
| basic rights. The user has to be a part of the Domain
| Admin Group in order to connect to SQL Server. The same
| user can connect to SQL Server from 2000, NT, 98, and 95
| machines without any issues. Only the XP client
| workstation is the issue. Is there a flag or a rights
| change that I need to do in order for the XP client
| machine to talk to a 2000 server with SQL server
| installed?
|
| Thanks!
|
- Next message: Steven Liu [MSFT]: "RE: I can't get to https sites"
- Previous message: shawn: "Computer Administration Password does not work"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
