|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|
|Content-Type: ||text/plain; charset=us-ascii; format=flowed|
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.
Peter Baade wrote:
> 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.