rstudio Teradata connection issue> Unable to locate SQLGetPrivateProfileString function

Question

When i am trying to connect a teradata database through teradata odbc driver 16.2 it gives me an error Unable to locate SQLGetPrivateProfileString function

my etc/odbc.ini file looks like this

[ODBC]
Trace=no
Pooling=yes

[ODBC Data Sources]
Teradata ODBC DSN=Teradata Database ODBC Driver 16.20

[Teradata ODBC DSN]
# This key is not necessary and is only to give a description of the data source.
Description=Teradata Database ODBC Driver 16.20

# Driver: The location where the ODBC driver is installed to.
Driver=/Library/Application Support/teradata/client/16.20/lib/tdataodbc_sbu.dylib
Ss
# Required: These values can also be specified in the connection string.
DBCName=
UID=
PWD=

# Optional
AccountStr=
CharacterSet=ASCII
DatasourceDNSEntries=
DateTimeFormat=AAA
DefaultDatabase=
DontUseHelpDatabase=0
DontUseTitles=1
EnableExtendedStmtInfo=1
EnableReadAhead=1
IgnoreODBCSearchPattern=0
LogErrorEvents=0
LoginTimeout=20
MaxRespSize=65536
MaxSingleLOBBytes=4000
MaxTotalLOBBytesPerRow=65536
MechanismName=
NoScan=0
PrintOption=N
retryOnEINTR=1
ReturnGeneratedKeys=N
SessionMode=System Default
SplOption=Y
TABLEQUALIFIER=0
TCPNoDelay=1
TdmstPortNumber=1025
UPTMode=Not set
USE2XAPPCUSTOMCATALOGMODE=0
Use32KMaxCharColumnSize=0
UseDataEncryption=0
UseDateDataForTimeStampParams=0
UseEmptyCreateParamsColumnforTimeStamp=0
USEINTEGRATEDSECURITY=0
USEREGIONALSETTINGS=1
UseSequentialRetrievalOnly=0
UseXViews=0
EnableUDFUpload=0
UDFUploadPath=Please enter the UDF folder path 

and my etc/odbcinst.ini looks like this

[ODBC Drivers]
Teradata Database ODBC Driver 16.20=Installed

[Teradata Database ODBC Driver 16.20]
Description=Teradata Database ODBC Driver 16.20
Driver=/Library/Application Support/teradata/client/16.20/lib/tdataodbc_sbu.dylib
Setup=/Library/Application Support/teradata/client/16.20/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup
# Note: Currently, Data Direct Driver Manager does not support Connection Pooling feature.
CPTimeout=60

Can anyone tell me what is wrong here_

question from:https://stackoverflow.com/questions/65853444/rstudio-teradata-connection-issue-unable-to-locate-sqlgetprivateprofilestring-f

Answer 1

Waitting for answers