proc sql and connect using

[DBailey]

I just tried that:

proc sql;

select count(*) as recs

from quest.businessunit;

connect using quest as q;

create table work.test as select * from connection to q (

select * from businessunit

);

disconnect from q;

quit;

the count worked but the connect using did not.

ODBC_2: Prepared: on connection 1
select COUNT(*) as "recs" from "dbo"."businessunit" TXT_1 WITH (NOLOCK)


ODBC_3: Executed: on connection 1
Prepared statement ODBC_2

ACCESS ENGINE: SQL statement was passed to the DBMS for fetching data.
37
38 connect using quest as q;
ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified

I'll see if I can find the authdomain and try a "connect to" instead of "connect as"

[Tom]

In that case open a ticket with SAS support and see if they can explain why it does not work and whether there is a solution.

[SASKiwi]

@DBailey - My issue is with SQL Server and SAS/Access Interface to ODBC. CONNECT USING works fine with a prior LIBNAME statement, but not with a pre-defined library.