Export SAS results do SQL Server

Hello, not long ago I posted a question about how to export SAS results to SQL Server tables... I closed the question before I had a chance to fully test it, so I'm creating another one because I found some kind of error creating the connection to SQL Server

The previous question: http://www.experts-exchange.com/Database/Miscellaneous/Q_28129375.html

I tried with the ODBC Driver usgin this code:
libname SUPPLY odbc 
     noprompt="DRIVER={SQL Server};SERVER=toddsServer;UID=ToddsUserName;PWD=secret;DATABASE=ToddsDB" ;

Open in new window


And got some error related to this driver (attached)

Anyone knows how can I get this to work, please?



Thanks in advance :)
sas-error.bmp
toddinhoAsked:
Who is Participating?
 
theartfuldazzlerConnect With a Mentor Commented:
Hi

It looks like there is an issue with your installation of SAS Access to ODBC.  My suspicion is that you will need to contact your SAS Rep and re-install this component.
0
All Courses

From novice to tech pro — start learning today.