topic Re: OBDC Can Not Be Found in SAS Programming

OBDC Can Not Be Found

HERR_LANGER80 — Fri, 07 Jul 2023 16:26:41 GMT

To all:

I am an intermediate SAS developer who has not had any problems with SAS up until this point where I am now trying to use a database engine.

Objective: Connect to a SQL Server database from within SAS.

Current approach: use SAS ODBC drivers

Important facts:

1. Using SAS onDemand for Academics;

2. Have run PROC SETINIT;

3. SAS/Access to SQL Server not part of the list;

4. Downloaded SAS Deployment Manager;

5. Deployed ODBC drivers for both 64 and 32 bit;

Simple code for testing.

libname sqlsRvr odbc dsn='SS_ODBC',schema='DBO'

Proc SQL;
SELECT * FROM Main_Disease_tbl;
QUIT;

Errors:

ERROR: The ODBC engine cannot be found.

ERROR: Error in the LIBNAME statement.

I don't get why this doesn't work.

Can someone assist me here with a possible explanation as to why this doesn't work?

Thanking you in advance.

Herr Langer

Re: OBDC Can Not Be Found

Reeza — Fri, 07 Jul 2023 16:27:37 GMT

I don't believe SAS OnDemand for Academics supports connecting to databases.

Re: OBDC Can Not Be Found

Kurt_Bremser — Fri, 07 Jul 2023 16:48:40 GMT

On Demand does not support any ACCESS module beyond ACCESS to PC Files, IIRC. And you would need to set up the DSN on the On Demand server, not on your PC. Which you can't do in this restricted environment.

Re: OBDC Can Not Be Found

HERR_LANGER80 — Fri, 07 Jul 2023 17:06:31 GMT

So If the Academic Version does not allow for Database connections then I guess that I will have to look into a full featured version of the product.

Thanks!

Re: OBDC Can Not Be Found

Reeza — Fri, 07 Jul 2023 17:21:25 GMT

Viya is available in Azure MarketPlace as Pay as you Go but no idea how that works personally 🙂

Re: OBDC Can Not Be Found

HERR_LANGER80 — Sat, 08 Jul 2023 01:48:43 GMT

Thank you Kurt.

And thanks to all of you who responded.

Re: OBDC Can Not Be Found

SASKiwi — Sat, 08 Jul 2023 02:49:52 GMT

If you need to get data out of SQL Server and into SODA, you can always extract the data in the SQL client of your choice into a delimited file and then upload it to SODA.

Re: OBDC Can Not Be Found

Kurt_Bremser — Sat, 08 Jul 2023 05:57:26 GMT

You can always export your DB data to text files and upload these to On Demand. This is in fact how it's done at the company I worked for. No SAS/ACCESS license needed, no maintenance of the DB client on the SAS server, and no danger of unexpected loads on the production DB server.