f



connect to sql server

Hello,

I am trying to connect sas to a remote sql server database and would
like to know the proper syntax for doing so. when i try using sas help
i get the following errors when i use the info:

  libname sqlsvr  user=sa
  password=XXXXXX path='sqlodbc';

ERROR: Libname SQLSVR is not assigned.
ERROR: Error in the LIBNAME statement.
    run;

Any help in resolving this problem would be greatly appreciated.
Thanks, Nevin
0
nkrishna (1)
6/23/2003 9:50:46 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

1 Replies
1335 Views

Similar Articles

[PageSpeed] 29

Here's what I use:

%macro dblib(server,dbname,libnam); 
  libname &libnam ODBC DATASRC=&server
          USER=&RLOGIN PASSWORD=&RPASS
          DBCONINIT="use &dbname";
%mend dblib;

&server is your ODBC data source.
&RLOGIN and &RPASS are defined elsewhere
(e.g. %LET RLOGIN=sa; %LET RPASS=yaddayadda;)

nevin krishna wrote:

>Hello,
>
>I am trying to connect sas to a remote sql server database and would
>like to know the proper syntax for doing so. when i try using sas help
>i get the following errors when i use the info:
>
>  libname sqlsvr  user=sa
>  password=XXXXXX path='sqlodbc';
>
>ERROR: Libname SQLSVR is not assigned.
>ERROR: Error in the LIBNAME statement.
>    run;
>
>Any help in resolving this problem would be greatly appreciated.
>Thanks, Nevin
>

0
6/24/2003 2:02:43 PM
Reply:

Similar Artilces:

connect SAS server to SQL servers
Hi, We=92re moving from PC SAS to SAS server. SAS server resides on Windows 2k3 OS. We=92re having issues having SAS communicate with our SQL servers. Our SQL servers are set up with Windows Authentication only (no mixed mode). From PC SAS I used to connect to SQL servers using a libname statement such as: LIBNAME test oledb init_string=3D"Provider=3Dsqloledb; Integrated Security=3DSSPI;Persist Security Info=3DTrue; Initial Catalog=3DABC;Data Source=3DSERVER0123" schema=3Ddbo; Obviously Windows Authentications was used to pass my credentials to the SQL server. The ...

SAS connection to a remote desktop connection where I need to access SQL Server
Hi, I'm trying to hook up SAS to connect to an SQL Server (which I access through a remote desktop connection). do I need to have SAS on the remote PC to do this? if anyone could explain to me how to do this then I'd be really grateful Thanks Ben On Feb 1, 9:08=A0am, ben.sp...@glass.co.uk wrote: > Hi, > > I'm trying to hook up SAS to connect to an SQL Server (which I access > through a remote desktop connection). do I need to have SAS on the > remote PC to do this? > > if anyone could explain to me how to do this then I'd be really > grateful > &g...

Entreprise Manager error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '#####'. The user is not associated with a trusted SQL Server connection.(28000,18452)"
Can anyone give a quick description of the meaning of this message and what needs to be done to get a connection. I'm running DBArtisan with SQLServer 2000 client SP4 installed. I also get the same message with MS Enterprise Manager so this is coming out of the actual ODBC connection attempt. Thanks in advance! In the future, please do not put part of your message in the subject line. Makes it harder to read. In any case, you're trying to do integrated login and don't have that login set up in the DB. You need to add that login, or change to a SQL Login. -- Greg Moore SQL...

connecting sql server 2000 from SAS
I want to connect remote sql server 2000 from my home' windows xp. I don't have sas/access, so I have to use odbc. Though I read sas odbc user' guid, I still don't know how to do it. Does anyone give me procedure in detaill.By the way, I download sas odbc driver and try to configure odbc management. thank you Does the following SAS technical note help? http://support.sas.com/techsup/technote/ts765.pdf Art ---------- On Feb 25, 12:27 am, yangsk...@gmail.com wrote: > I want to connect remote sql server 2000 from my home' windows xp. I > don't have sas/access, so...

SAS/EG connection to SQL Server
Hi all, =20 I'm trying to configure a connection from PC EG to SQL Server databases via SASMain running on unix server. We are connecting from EG to SASMain through Integration Technologies. I'm able to connect to read-only production databases fine but am having problems creating libnames that connect to user schemas. It seems that we have to create two libnames: =20 libname SQLv sqlsvr dsn=3DUPM_Product_Mgmt uid=3Dsassql01 pwd=3D"&sql01pw." schema=3D"windowsdomain\user"; libname SQLc sqlsvr dsn=3DUPM_Product_Mgmt uid=3Dsassql01 pwd=3D"&sql01pw...

New IBM Laptop running SQL server cannot connect to another sql server on network
I am trying to connect a new LBM Laptop to an SQL server on the network and I get "test connection failed because of an error in initializing provider, [dbnetlib][connectionopren(connect()),] SQL server does not exist or access denied. The laptom has sql server running on it locally and I am trying to connect to an SQL server on the network. Thanks Tom Hi You should make sure that SQL Server is at Service Pack 3a on both machines and check the MDAC installation on the laptop with the MDAC component checker (see microsoft download centre)? If you can connect to the network SQL Server f...

Connecting to Oracle and SQL-Server with SAS/Access to ODBC
******************************************************************************************************************************************************* This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. ******************************************************************************************************************************************************* We have SAS 8.2 on Solaris 8 and are moving over the next 6 months to SAS 9.1 on Solaris 9. We currently license SAS/Access to Oracle (connecting to Oracle also ...

Re: Connecting to Oracle and SQL-Server with SAS/Access to ODBC
Nigel, If you get SAS/ACCESS for ODBC, you will be able to extract data from any application that acts as an ODBC server; for example, I can pull data from an MS-ACCESS database, or from an Oracle database, and if I happened to have access to a SQL Server database I could pull data from that as well. Since I haven't benchmarked doing the same extraction using both ODBC and the appropriate specialized SAS/ACCESS version for the same database, I'll pass on comparing the performance of the two approaches. It might help if you indicated what features of the SAS/ACCESS link you use curre...

SAS/Connect: SAS Client/User access monitorin in SAS NT Server
Dear SAS Users, I have SAS/Connect both of PC and NT Server. It can use remote SAS Server (Win) when i write a code in PC and use rsubmit to run it under SAS Server. Since number of SAS user/client have been increased, so I want to monitor and to know who SAS client is running and accessing SAS Server. Anybody know how to configure it... Regards, DWI SUSIYANTO GE Consumer Finance Indonesia http://support.sas.com/faq/002/FAQ00268.html With SAS 8.2 and later, use the -LOGEVENTS option on the PC Spawner installation to determine who is connecting to a remote spawner. This creates an entry ...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45289357610)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45289357610) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to ...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45287858052)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45287858052) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to ...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45286357605)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45286357605) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to ...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45286632409)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45286632409) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to <staffing@e...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45287232415)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45287232415) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to ...

US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45288432411)
US-TX-San Antonio: SAS Programmer, SAS 90, SQL, Graphics, Oracle, SQL Server; C- (45288432411) ============================================================================================== Position: SAS Programmer Reference: SMC01176 Location: San Antonio TX Duration: C-P Skills: 5+yrs strong SAS programming experience in a pharmaceutical research environment. Technical skills include SAS 90, SQL, Graphics, Reports, Tasks, Charts, and Plots. Oracle and SQL Server. Please send your current resume in confidence to ...

Web resources about - connect to sql server - comp.soft-sys.sas

First Capital Connect - Wikipedia, the free encyclopedia
( FCC ) is a British train operating company , owned by FirstGroup , operating the Thameslink Great Northern franchise . FCC operates passenger ...

Connect
mobile photography technology, culture and community www.dpreview.com News Reviews Features Phones Tablets Cameras Apps Forums Mobile photography ...

CloudCraze Connects Consumers To Facebook Brands Via Cloud Technology
Brands on Facebook are always looking for new, efficient ways to connect with customers . CloudCraze, which recently released its 3.0 e-commerce ...

Dating App Festar Connects Users Based on Mutual Interests, Not Looks
... release in Japanese, dating app Festar has launched in beta on Android in 13 countries in English and Korean. From AI Pacific , Festar connects ...

Movesum step-tracking app connects how you move with what you eat
... your funny bone . Movesum Lifesum - Healthier living, better eating, more movement Pedometer++ Moves Movesum step-tracking app connects ...

Solar Plants: UK’s Lightsource Connects 100 MW Of Solar In December
Lightsource Renewable Energy has announced the connection of 23 new sites in December, totaling more than 100MW of new capacity. This is a solid ...

Triple-whammy Bluetooth keyboard connects to 3 devices flawlessly
Lust List: K380 Multi-Device Bluetooth Keyboard by Logitech Not one, not two, but three devices, all commanded by a single keyboard. Three Bluetooth ...

Qualcomm at CES Brings Technologies to Power, Connect Devices
The chip maker unveiled products to run everything from connected cars to the smart home, and offerings to connect these devices and systems. ...

The Online Classes That Help The Homebound Connect
Friendships form easily over video chat at the Virtual Senior Center, where the course list helps prevent isolation and loneliness.

The Unlikely Way That Agent Carter Will Connect with Doctor Strange
The World War Z sequel loses its director. Zack Snyder teases the mythology of Batman v Superman ’s villain. Supergirl could actually cross over ...

Resources last updated: 1/28/2016 7:49:30 PM