topic Re: Accessing Microsoft SQL Server using PC File Server in New SAS User

Accessing Microsoft SQL Server using PC File Server

raphcla — Tue, 29 Jan 2019 18:58:15 GMT

Hi every one.

I'm trying to access a SQL database via SAS.

My SAS is installed in Linux server and SQL Database in Windows. I try to map the library with this code:

libname teste pcfiles server=&IP. port=&porta. DSN=SQL UID=&USER PWD=&PASS schema=DBST800 database=dbo.dados_gestao_risco;

and doesn't work. I will put here a print of SQL structure. I'm missing something?

Re: Accessing Microsoft SQL Server using PC File Server

SASKiwi — Tue, 29 Jan 2019 20:14:54 GMT

A better way is to use SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC. Do you not have either of these?

Re: Accessing Microsoft SQL Server using PC File Server

raphcla — Wed, 30 Jan 2019 12:34:17 GMT

Unfortunately i don't have this software. I only have PC File Server, it's useful?

Re: Accessing Microsoft SQL Server using PC File Server

andreas_lds — Wed, 30 Jan 2019 15:19:58 GMT

@raphcla wrote:
Unfortunately i don't have this software. I only have PC File Server, it's useful?

Access to PC Files is useful for accessing some file-types, like MS Access Files, but afaik it is of no use, if you want to process data stored in an MS SQL DB.

Re: Accessing Microsoft SQL Server using PC File Server

raphcla — Wed, 30 Jan 2019 15:53:51 GMT

I dont't know. But apparently in this online manual (http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n12tx6b9ilne0kn198ddk83po0lc.htm) exist a way to use pcfile to do this connection. See this part below:

Re: Accessing Microsoft SQL Server using PC File Server

David236774 — Fri, 31 Mar 2023 06:29:30 GMT

The server you specified in the libname will need to have the PCFiles listener running, and the ODBC data source set up.