troubleshooting Question

Export SAS results do SQL Server

Avatar of toddinho
toddinho asked on
Databases
1 Comment1 Solution419 ViewsLast Modified:
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/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" ;

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
theartfuldazzler

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros