BookmarkSubscribeRSS Feed
Siva_Harish
Obsidian | Level 7

Hello community,

Iam getting below error when I was trying to connect to odbc server .

Can anyone help me to fix this?

 

Siva_Harish_0-1606981451774.jpeg

 

Thanks in advance!!

 

8 REPLIES 8
DavidHD
SAS Employee

Hey @Siva_Harish ,

 

You need SAS/ACCESS to ODBC with the correct SQL Server ODBC driver installed on the same server.

 

Kind Regards,

David

Siva_Harish
Obsidian | Level 7

Siva_Harish_0-1606986335032.jpeg

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 !! 

 

 

DavidHD
SAS Employee
What do you mean by "However we are not able to get in my system"? If the drive is not installed on the system that your SAS installation is running on then SAS won't be able to connect to your data source.
Kurt_Bremser
Super User

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.

Siva_Harish
Obsidian | Level 7
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

Siva_Harish_0-1606987279710.jpeg

 

Kurt_Bremser
Super User

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:

  • single machine (SAS 9.4 on your desktop, Display Manager or Enterprise Guide with Local server)
  • client/server, if yes, which operating system on the server

If in doubt, run PROC SETINIT and post the log.

 

And please post the logs as text, using the </> button, and not as pictures.

Siva_Harish
Obsidian | Level 7
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
Kurt_Bremser
Super User

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

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.

Discussion stats
  • 8 replies
  • 919 views
  • 1 like
  • 3 in conversation