12-05-2013 04:23 PM
I am using 9.3 and get the following error when reading in Access files:
Error trying to establish connection: Unable to create Data Source.: Class not registered
ERROR: Error in the LIBNAME statement
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.
12-05-2013 05:14 PM
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.
12-06-2013 10:48 AM
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.