Hello community,
Iam getting below error when I was trying to connect to odbc server .
Can anyone help me to fix this?
Thanks in advance!!
Hey @Siva_Harish ,
You need SAS/ACCESS to ODBC with the correct SQL Server ODBC driver installed on the same server.
Kind Regards,
David
I want to configure My SQL odbc 5.3 driver 32 through odbc data source administrator(32-bit) .However we are not able to get in my system(above image for your reference)
Any thoughts !!
Please post logs by copy/pasting the text into a window opened with the </> button. They are much easier to read and we can insert comments to point to mistakes.
Similarly, use the "little running man" button right next to it for posting SAS code.
proc sql threads noprint;
connect to ODBC (dsn=&DSN. user=&USER. password=&PWD.);
execute (delete from legal.m_f_tymetrix_lineitem_test
where cast(date_format(Invoice_Processing_Date, '%Y%m') as signed) in (&mon_yrt.)) by odbc;
execute (commit ) by odbc;
disconnect from odbc;
quit;
When we ran the sas code we got below error
The ODBC source must be defined on the host on which SAS runs. As much as I can read from the log picture, the ODBC source is not defined.
Please tell us a little about your SAS setup:
If in doubt, run PROC SETINIT and post the log.
And please post the logs as text, using the </> button, and not as pictures.
Original site validation data Current version: 9.04.01M3P062415 Expiration: 31DEC2020. Grace Period: 45 days (ending 14FEB2021). Warning Period: 45 days (ending 31MAR2021). System birthday: 28FEB2020. Operating System: W32_WKS . Product expiration dates: ---Base SAS Software 31DEC2020 ---SAS/STAT 31DEC2020 ---SAS/GRAPH 31DEC2020 ---SAS/ETS 31DEC2020 ---SAS/FSP 31DEC2020 ---SAS/OR 31DEC2020 ---SAS/AF 31DEC2020 ---SAS/IML 31DEC2020 ---SAS/QC 31DEC2020 ---SAS/SHARE 31DEC2020 ---SAS/CONNECT 31DEC2020 ---SAS/EIS 31DEC2020 ---SAS/SHARE*NET 31DEC2020 ---MDDB Server common products 31DEC2020 ---SAS/Secure 168-bit 31DEC2020 ---SAS/Secure Windows 31DEC2020 ---SAS Enterprise Guide 31DEC2020 ---OR OPT 31DEC2020 ---OR PRS 31DEC2020 ---OR IVS 31DEC2020 ---OR LSO 31DEC2020 ---SAS/ACCESS Interface to DB2 31DEC2020 ---SAS/ACCESS Interface to Oracle 31DEC2020 ---SAS/ACCESS Interface to PC Files 31DEC2020 ---SAS/ACCESS Interface to ODBC 31DEC2020 ---SAS/IML Studio 31DEC2020 ---SAS Workspace Server for Local Access 31DEC2020 ---SAS/ACCESS Interface to Netezza 31DEC2020 ---High Performance Suite 31DEC2020
So you have a single workstation installarion and license with all the necessary parts. You need to correctly define the ODBC source (DSN) in Windows, so you can then use it from SAS.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.