Link to home
Create AccountLog in
Avatar of toddinho
toddinho

asked on

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: https://www.experts-exchange.com/questions/28129375/Export-SAS-results-do-SQL-Server.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
ASKER CERTIFIED SOLUTION
Avatar of theartfuldazzler
theartfuldazzler
Flag of South Africa image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account