Accessing SAS ODBC DSN - Urgent
in [SAS]
|
From: Ramchandra on 5 Sep 2006 02:12 Hi All, I have created one DSN for SAS (dsnsas) and one DSN for MS Access database (dsnaccess) on my machine. when I try to access sas dsn (dsnsas) from sas base I am getting followinfg error ERROR: CLI error trying to establish connection: [SAS][SAS ODBC Driver][SAS Server]178 - TCP method failed rc = -1005 (Unable to locate service.). : [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). But If I try to access MS Access dsn (dsnaccess) then it is connecting properly. I am using following sas base code. PROC sql; CONNECT TO ODBC(DSN='dsnsas'); QUIT; Please let me know if anyone knows about this. Thanks, Ramchandra Nile
From: NordlDJ on 5 Sep 2006 02:45 > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of > Ramchandra > Sent: Monday, September 04, 2006 11:12 PM > To: SAS-L(a)LISTSERV.UGA.EDU > Subject: Accessing SAS ODBC DSN - Urgent > > Hi All, > I have created one DSN for SAS (dsnsas) and one DSN for MS Access > database (dsnaccess) on my machine. > when I try to access sas dsn (dsnsas) from sas base I am getting > followinfg error > > ERROR: CLI error trying to establish connection: [SAS][SAS ODBC > Driver][SAS Server]178 - TCP method > failed rc = -1005 (Unable to locate service.). : > [Microsoft][ODBC Driver Manager] The driver > doesn't support the version of ODBC behavior that the > application requested (see > SQLSetEnvAttr). > > But If I try to access MS Access dsn (dsnaccess) then it is connecting > properly. > > I am using following sas base code. > > PROC sql; > CONNECT TO ODBC(DSN='dsnsas'); > QUIT; > > Please let me know if anyone knows about this. > > Thanks, > Ramchandra Nile Ramchandra, You need to provide a little more detail if you want to get useful advice. Are you trying to access two different data sources, or are you trying to access the same data source from SAS and MS Access? I assume you are working on a MS Windows computer. What is your data source? An MS Access database, a SAS dataset, a ...? It seems like you might want to use an MS Access database in SAS. You should be able to do that with the same DSN that you use for Access. If you write back to SAS-L and describe what your data is like, and what you want to do with it, someone (maybe even me) may be able to help you. Dan Daniel J. Nordlund Research and Data Analysis Washington State Department of Social and Health Services Olympia, WA 98504-5204
From: Gerhard Hellriegel on 5 Sep 2006 08:27 Your dsnsas is a logical name (LIBNAME ? ) for a SAS library? Is that right? Or do you mean a SAS dataset (table)? In both cases it is wrong to access that via ODBC! The ODBC connaction you need to access you database, not a SAS structure. A SAS table is simply accessed by proc sql; select * from libname.sastable; quit; if you want to do that with SQL. try: proc sql; select * from sashelp.class; quit; as an example. On Mon, 4 Sep 2006 23:12:19 -0700, Ramchandra <ramchandra.nile(a)GMAIL.COM> wrote: >Hi All, >I have created one DSN for SAS (dsnsas) and one DSN for MS Access >database (dsnaccess) on my machine. >when I try to access sas dsn (dsnsas) from sas base I am getting >followinfg error > >ERROR: CLI error trying to establish connection: [SAS][SAS ODBC >Driver][SAS Server]178 - TCP method > failed rc = -1005 (Unable to locate service.). : >[Microsoft][ODBC Driver Manager] The driver > doesn't support the version of ODBC behavior that the >application requested (see > SQLSetEnvAttr). > >But If I try to access MS Access dsn (dsnaccess) then it is connecting >properly. > >I am using following sas base code. > >PROC sql; >CONNECT TO ODBC(DSN='dsnsas'); >QUIT; > >Please let me know if anyone knows about this. > >Thanks, >Ramchandra Nile
|
Pages: 1 Prev: Read Excel data into SAS format Next: Check if macro parameter is empty |