**ODBC ... View more

regarding step 1, SQL Team is unable to login to a service account. they only have permission to login to SQL authentication. Our account was created on Active directory any other way if we can check from database level? ... View more

Hi Everyone, So we tried all the steps: Issue: SQL Library creation Error: CLI Error Steps performed: > we got windows service account created >DB Team updated the same on SQL >we created the library on console, updated odbc.ini entry and updated sasenv_local. >re-started SAS Services. still same error: ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ... View more

Hi All, so we checked the odbc.ini file and entry was no created for this SQL Library. We updated all the details. Still tables are not visible and we are receiving the same error : "ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number." ... View more

odbc drivers are installed, as all other SQL libraries are running fine.   We got Active directory domain user Service account created for this new library and Database team updated details, now if we try to create library on Management console, tables are still not visible.     ... View more

This is the error I receive via code: ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified ... View more

I get the following error: when I submit via code  ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified NOTE: Statements not processed because of errors noted above. ... View more