LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 15 Feb 2001 07:58:23 -0500
Reply-To:   Lionel Teed <teedl@TDBANK.CA>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Lionel Teed <teedl@TDBANK.CA>
Organization:   TD Bank
Subject:   Fw: access to sql server / odbc
Content-Type:   text/plain; charset="iso-8859-1"

Not sure if I remember the original request, but I seem to believe it had something to do with connecting via ODBC to Sql server without setting up the drivers via the control panel ODBC Driver utility. Try the following.

LibName SqlLib ODBC NOPROMPT="DRIVER=SQL Server;Database=dbname;Server=servername" ;

In my case, the server was (local), and the dbname was auxdb, so my resulting statement was....

LibName SqlLib ODBC NOPROMPT="DRIVER=SQL Server;Database=auxdb;Server=(local)" ;

----- Original Message ----- From: "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU> Newsgroups: To: <SAS-L@LISTSERV.UGA.EDU> Sent: Wednesday, 14 February, 2001 9:22 AM Subject: Re: access to sql server / odbc

> Not the answer to the substance, but the answer to the 'why?'. Because > Micro$oft said so. MS is recommending to third parties that they not use > the Sybase connectivity tools of the past. In fact, there are features in > SQL Server 2000 that you can't get to with the Sybase drivers (from Unix SAS > 6.12). > > FYI, the original SQL Server (4.21?) was basically just a PC recompile of > the Sybase Unix product with some better GUI's added. From there the two > products have diverged, but the Sybase driver was still the original one. > > David Dickinson wrote: > > > > > Third, why would SAS put in place a solution like this that is seemingly > > harder (at least to me) to use? Am I missing another easier option? > > > > Thanks for any help. > > David > > > > -- > > To Reply, Remove NOSPAM from my address > > David Dickinson, URREA > > -- > Lawrence H. ('Doc') Muhlbaier > Assistant Research Professor > Duke University Medical Center 919-668-8774 (office) > DUMC 3865 919-383-0595 (home) > Durham, NC 27710-7510 919-668-7057 (FAX) >

Back to: Top of message | Previous page | Main SAS-L page