Accessing Microsoft SQL Server using PC File Server

[raphcla]

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?

[SASKiwi]

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

[raphcla]

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

[andreas_lds]

---

@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.

[raphcla]

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

[David236774]

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