BookmarkSubscribeRSS Feed
ktothree
Calcite | Level 5


Hi all-

I am using 9.3 and get the following error when reading in Access files:

 

ERROR:
Error trying to establish connection: Unable to create Data Source.: Class not registered

 

ERROR: Error in the LIBNAME statement

The line of code is as follows:

Libname SBI oledb init_string="Provider=Microsoft.ACE.OLEDB.12.0;Password="";DataSource=&Path.\&loanFileName.;Persist Security Info=True";

I am assuming the 2nd error will resolve once the first error is remediated. Any help is appreciated. Thank you.

4 REPLIES 4
ballardw
Super User

Have you tried replacing the macro variables with appropriate literal text?

Astounding
PROC Star

Most likely the problem lies with your specification for Password.  Since your entire INIT_STRING is enclosed in double quotes, consecutive double quotes within the string are interpreted as one double quote instead of two.  Would the syntax for Password be acceptable if you changed to single quotes instead of double?  If not, try replacing the two consecutive double quotes with four consecutive double quotes.

Good luck.

ktothree
Calcite | Level 5

Thank you - I have tried your suggestions and still still get the connection error. I have reviewed the SAS note as well, and have ensured I have the ACE.

I have two co-workers in the office who are able to run this code with no issues - I am the only one running into this connection error. We have gone through all of our settings, ensuring I have everything they have. We are all running on the same platforms and programs. I believe something is not right with the install on my machine. We have reviewed the code line by line, ensuring there is no difference when I run it. I will next try to uinstall and re-install and see if that remediates this issue.

Thank you all for your suggestions.

SASKiwi
PROC Star

This SAS note is pretty close to your error:

http://support.sas.com/kb/37/412.html

Try the suggestions.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1189 views
  • 7 likes
  • 4 in conversation