Help using Base SAS procedures

the odbc engine cannot be found

Reply
Regular Contributor
Posts: 220

the odbc engine cannot be found

hi all,

ERROR for ODBC library : "THE ODBC ENGINE CANNOT BE FOUND. ERROR IN LIBNAME STATEMENT"

ERROR for BASE library : " Libname ABC not avilbale for user. error in libname statement"

i am getting this error message when i try to run odbc and base libname statement.

right now i don't have essential SAS/ACCESS interface to ODBC so if i install this essential- is that good enough to get rid off this error?

my second question is SAS support told me that download "SAS DOWNLOAD MANAGER" and then i will get that essential from it. so wanted to know what does "SAS DOWNLOAD MANAGER" do?

please advise...

Thanks,

sam

Super User
Posts: 19,867

Re: the odbc engine cannot be found

Is this a new install of SAS?

If so, ODBC and SAS/ACCESS aren't installed by default you need to check them off when you install. Best solution is to go back to your install media (download/disks) and reinstall the ODBC/ACCESS portion.

Regular Contributor
Posts: 220

Re: the odbc engine cannot be found

its not new installment. i have already on borad- the thing is don't have - "SAS/ACCESS interface to ODBC"-

Thanks.

Regular Contributor
Posts: 220

Re: the odbc engine cannot be found

as i said before-  i have SAS installed on my machine and need to get sas/accsss interface for ODBC- my question is,

- is this will change or affects my server existing installation?

- is this will change or affects my local machine's existing installlation?

- what are the steps that i can follow, after this SAS DOWNLOAD MANAGER installed on machine, to get "sas/accsss interface to ODBC" tool?

please advise.

Thanks.

Occasional Contributor
Posts: 7

Re: the odbc engine cannot be found

SAS Download Manager - This software is needed for you to download your software order from SAS FTP site. Whiel downloading the software, it will create a SAS Depot by dault with all your orders.

If you already dont have software depot, then do this which will be useful for you to handle the software instead of having multiple disks where as you can also create the same software depot from Disk if you have.

In addition to the install of SAS Access interface to ODBC, you may need to do configuration work.

Ask a Question
Discussion stats
  • 4 replies
  • 5158 views
  • 0 likes
  • 3 in conversation