Date: Fri, 17 Jan 1997 13:42:06 EST
Reply-To: David Hopkins <DHOPKINS@ERS.BITNET>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: David Hopkins <DHOPKINS@ERS.BITNET>
Dear SAS Folks,
I am trying to access a MS SQL database with my win SAS 6.11, TS 040,
I think its called Wave 2. My machine is a Dell Pentium, with
plenty of RAM and disk space and WIN 95. My SAS ACCESS program is
bombing at the attempted opening of the database. The SAS usage notes,
V6-ENGINE-B964, describes my problem an suggests that I switch to
SAS 6.11, WAVE 2. Am I running Wave 2? Can anyone see my problem?
Is there any other software, like MS supplied client drivers that I
need?
SAS log below....
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.11 TS040
Licensed to USDA-ERS, Site 0011310028.
1
2 libname demo 'd:\farminc' ;
NOTE: Libref DEMO was successfully assigned as follows:
Engine: V611
Physical Name: d:\farminc
3
8
9 proc access dbms=sqlservr;
10 create demo.farminc.access;
11 server=d01sv05;
12 database=XXXXXXX;
13 user=XXXXXXX;
14 password=XXXXXXX;
15 table=XXXXXXXXXXXXXXXXX;
16 assign=yes;
ERROR: Could not locate vendor supplied DB-Library .DLL in the current system s
ERROR: Database error. Examine fields and/or messages below.
Install of Sybase bridge failed.
17 list all;
ERROR: Database table must be entered first
18
19 create demo.farminc.view;
20 subset
21 WHERE
22 (year BETWEEN 1994 AND 1995) ;
23 select all;
ERROR: Database table must be entered first
24
25 run;
NOTE: The PROCEDURE ACCESS used 3.79 seconds.
--David Hopkins
+----------------------------------------------------------------------+
| David Hopkins, Programmer/Analyst| BITNET: DHopkins@ERS.BITNET |
| USDA/Economic Research Service | INTERNET: DHopkins@ECON.AG.GOV |
| 1301 New York Ave., NW,rm. 1208 B| |
| Washington, DC 20005-4788 | Tel: 202-219-0129 |
| | Fax: 202-219-0044 |
+----------------------------------------------------------------------+
| 
