I've installed MySQL connector and added the connection on ODBC Data Source Administrator, I did as well the test: "connection successful". So I went to import data on data preparation -> Server -> ODBC. After filled the fields I tried to find tables but was sended to me that message: No one table was returned from the library selected NOTE: This session is executing on the X64_SR12R2 platform. NOTE: Additional host information: X64_SR12R2 WIN 6.3.9600 Server NOTE: SAS Initialization used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: The autoexec file, C:\SAS\Config\Lev1\SASApp\WorkspaceServer\autoexec.sas, was executed at server initialization. 1 2 The SAS System 12:08 Tuesday, April 16, 2019 1 The SAS System 12:08 Tuesday, April 16, 2019 1 2 /* *********************************************** */ /* Assign the libref for the data in a ODBC table */ /* 2 ! *********************************************** */ LIBNAME db_odbc ODBC PRESERVE_COL_NAMES=YES PRESERVE_TAB_NAMES=YES 2 ! DATAsrc="DataBase" USER=adm PASSWORD="{sas002}341F943245F55BDC2B048AB10EEBE51E" ; NOTE: Libref DB_ODBC was successfully assigned as follows: Engine: ODBC Physical Name: DataBase 3 options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;
... View more
