topic Error on SAS connection in SAS Enterprise Guide

Error on SAS connection

tmcrouse — Wed, 21 Dec 2011 15:00:14 GMT

I am using SAS and have my proc sql; statement and my connection statement however when I run all the way to the disconnect and quit I get this error:

The DB2 engine cannot be found

A connection to the DB2 DBMS is currently not supported or not installed on your site.

I have tried to go through the documentation to see if I can figure out how to fix it but not having any success. I suspect that my desktop support folks did not load or connect something correctly when loading my SAS. Any advice?

Error on SAS connection

Ksharp — Thu, 22 Dec 2011 03:56:08 GMT

Which way are you using to connect DB2?

ODBC or SAS/Access to DB2. But both of ways need you to installl DB2 customer software firstly.

From your log, it looks like you don't set up it.

Ksharp

Error on SAS connection

SASKiwi — Thu, 22 Dec 2011 19:53:09 GMT

If you search the SAS support site for your problem you will find many references to your problem including this:

http://support.sas.com/kb/20/510.html

So it could be SAS/ACCESS to DB2 is not licensed. Run PROC SETINIT to check if it is or not.

Error on SAS connection

ChrisHemedinger — Fri, 23 Dec 2011 16:32:25 GMT

Here's another easy way to see what SAS products you have licensed/installed.

In the Server List window, expand the SAS server you want to check (for example, SASApp). Right-click on the server icon and select Properties.

In the Properties window, select the Software tab. Then click View SAS Server Products. The SAS Server Products window appears, like so:

It's not an exhaustive list of all products, but it does cover the most common set.

Chris