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>
Organization: http://groups.google.com
Subject:      cannot write tables on database
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

hello!

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
it.
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
to create.

a SHOW TABLES made on database show me no table called mickey: it was
not created!!

it seems i cannot write on database, even if my access credentials are
for root user and policy on diodbc is very permissive

any idea?

tnx in advance!