Skip navigation links

MySQL Forums :: Connector/ODBC :: SAS 9.1 to MYSQL via ODBC


Advanced Search

SAS 9.1 to MYSQL via ODBC
Posted by: Rainer Erras ()
Date: August 04, 2006 03:13AM

Hello,

i want to insert datasets from sas in a mysql-database via odbc.

i can create a libname on a odbc-connection:

"libname remote odbc datasrc=mysql_test user=ras;"

Then i delete the existing datasets:

"proc sql;
delete from remote.tbldatum;
quit;"

If i want to insert new datasets:

"proc sql;
insert into remote.tbldatum select * from work.a;
quit;"

i get an error:

"Error updating table entry: [MySQL][ODBC 3.51 Driver][mysqld-5.0.15]Invalid cursor position"

How can i get the cursor in the right position?

Pleas HELP

Options: ReplyQuote


Subject Written By Posted
SAS 9.1 to MYSQL via ODBC Rainer Erras 08/04/2006 03:13AM
Re: SAS 9.1 to MYSQL via ODBC Richard Bronosky 03/30/2007 02:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.