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 (September 2003, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 4 Sep 2003 18:55:36 -0400
Reply-To:   Glenn Heagerty <gheagerty@ADELPHIA.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Glenn Heagerty <gheagerty@ADELPHIA.NET>
Organization:   Consumer Solutions, Inc.
Subject:   Re: Microsoft SQL server
In-Reply-To:   <E1F6D3710A92D111BF8400600866404949D083@XENA>
Content-Type:   text/plain; charset=us-ascii; format=flowed

Hello Peter,

I have a customer that just installed teh OLE DB module of SAS/ACCESS for Relational Databases to move data between SAS and SQL Server. It works great in an interactive session and we have encountered some difficulty establishing the connection in batch. By the way, they are running Windows 2000 Server.

Good luck,

Glenn

Peter Baade wrote: > Hi, > > I use SAS 8.2 on Windows XP. We have data in a Microsoft SQL Server (Version > 6.5, on Windows NT) table that we would ideally like to access via SAS. > > Is there a straightforward way to do this, do we need a specific SAS module, > or do we need to export the SQL table into another data format, and then > read it into SAS. > > If more information is required, please email me directly. > > Regards, > > Peter. >


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