In version 8 I used to run this code no problem:
libname ext 'C:\';
PROC SQL;
CONNECT TO ODBC(prompt);
CREATE TABLE ext.Test AS
SELECT * FROM CONNECTION TO ODBC
(
select DateTime from dbo.Date);
%PUT &SQLXMSG;
%PUT &SQLXRC;
DISCONNECT FROM odbc;
quit;
Pretty simple connection to ODBC. But after upgrading to version 9 it gives me the following error:
464 libname ext 'C:\';
NOTE: Libref EXT was successfully assigned as follows:
Engine: V9
Physical Name: C:\
465 PROC SQL;
466 CONNECT TO ODBC(prompt);
ERROR: The ODBC engine cannot be found.
ERROR: A Connection to the ODBC DBMS is not currently supported, or is not installed at your
site.
467 CREATE TABLE ext.Test AS
468 SELECT * FROM CONNECTION TO ODBC
469 (
470 select DateTime from dbo.Date);
ERROR: The ODBC engine cannot be found.
ERROR: A Connection to the ODBC DBMS is not currently supported, or is not installed at your
site.
471 %PUT &SQLXMSG;
ERROR: A Connection to the ODBC DBMS is not currently supported, or is not installed at your
site.
472 %PUT &SQLXRC;
-1
473 DISCONNECT FROM odbc;
ERROR: Connection to the odbc DBMS does not exist.
474 quit;
When I run PROC SETINIT;run; it shows that I do have an ODBC engine... what is the hold up here?
... View more