Thanks Louis, i was finally able to hit the tables using SQL pass thru, but will test your method as well..Thanks very much for your response..

nevin

LouisBB wrote: > Dear Nevin, > > There are a number of possibele reasons. One is that the default schema for > SQL server is called 'dbo'. > If your tabels are not in dbo then you can add the schema=... option to your > libname statement. > > Another possibility is that the names of your tables 'confuse' Sas. This can > be mended with the preserve_tab_names=yes option on your libname statement. > > The libname options for ODBC are mentioned here: > http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a001355231.htm > http://support.sas.com/onlinedoc/913/docMainpage.jsp > > LouisBB. > > <nevin.krishna@gmail.com> wrote in message > news:1160009306.042162.264920@h48g2000cwc.googlegroups.com... > > Hello all, > > > > I am attempting to extract data from a remote sql server database using > > SAS. I am unfortunately running into some problems i hope you can help > > me with..First a little background: i am using sas > > 9.1 on an xp machine..I have an odbc connection set up with the remote > > server which i tested by connecting with ACCESS (successfully)..when i > > use the following code, the log states "odbc libref was successfully > > assigned." > > > > > > libname odbclib odbc dsn=hosp uid=xxx pwd=xxxx; > > run; > > > > however, when i use explorer in sas to view the newly created lib, > > there are no datasets appearing.. > > Has anyone experienced this? and how can i fix it? > > > > --thanks, > > > > Nevin > >