Date: Thu, 4 Dec 2008 03:41:52 -0800
Reply-To: TheClue <theclue@EMAIL.IT>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: TheClue <theclue@EMAIL.IT>
Subject: cannot write tables on database
Content-Type: text/plain; charset=ISO-8859-1
I'm quite new to SAS and I usually don't use an external RDBS to store
my tables. Howeaver, i have an ODBC source (mysql-based server) and i
add the server definition on SAS Management Console, then i added the
login row to the group that will use the server (ETL Developers) with
dbuser/dbpassword (in a domain called MySqlAuth).
Finally i added a library and i imported all my existing tables into
Everything works like a charm:; i can access to database, i can read
table definitions, i can update metadata.
But when i try to create a new table in data integration studio using
"target table wizard" (which should be used when the table still
doesn't exist on physical storage) there are problems: i can use the
wizard and the metadata is well-formed and i have no errors, but when
i try to open it to add some test observations i have this error:
"Unable to execute query: com.sas.iom.SASIOMDefs.GenericError:SQL
passthru expression contained these errors: ERROR: File
DIODBC.mickey.DATA does not exist"
where DIODBC is my library libref and "mickey" is the table i'm going
a SHOW TABLES made on database show me no table called mickey: it was
it seems i cannot write on database, even if my access credentials are
for root user and policy on diodbc is very permissive
tnx in advance!