LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 22 Jul 2004 13:24:17 -0700
Reply-To:   "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:   Re: Proc Export to MS Access
Comments:   To: "bill_droogendyk@DOFASCO.CA" <bill_droogendyk@DOFASCO.CA>

Bill -

Don't know if you're in v9, but we have been piloting the libname access engine and it opens up access tables like SAS datasets inside a library.

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Bill Droogendyk Sent: Thursday, July 22, 2004 9:45 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Proc Export to MS Access

Thanks to Paul Choate.

Both solutions work, i.e dropping the workgrp path (which the wizard asks you specify) or adding all 3 of dbpwd, pwd, uid.

wd Today's gift is ... Today!

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Choate, Paul@DDS Sent: 22 July, 2004 12:30 To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Proc Export to MS Access

Hey Bill - A stab in the dark:

Have you tried all three with double quotes? Your DBS might be defaulting to an UID and confusing the WGDB.

DBPWD=""; PWD=""; UID="";

Or taking off the WORKGPDB="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdw"; ?

Hope that doesn't hurt!

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Bill Droogendyk Sent: Thursday, July 22, 2004 9:09 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Proc Export to MS Access

Folks:

The Export Wizard built the following code for me. It works well in Wizard mode, but produces the security error when I try to run it in a program. The Access mdb has no passwords attached to it. Adding dbpwd=' '; and pwd=' '; do not make any difference.

Does anyone have any ideas?

PROC EXPORT DATA= data.INVENTORY

OUTTABLE= "SERNOF"

DBMS=ACCESS2000 REPLACE;

DATABASE="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdb";

WORKGPDB="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdw";

RUN;

ERROR: The security information supplied is incomplete. Check the usage of PASSWORD and DBPWD.

Thanks, wd Today's gift is ... Today!


Back to: Top of message | Previous page | Main SAS-L page